Rachita Gupta

E-Mail:rachita.gupta0902@gmail.com Contact:+91 9871261630 Career Objective2.7 years of experience as Oracle DBA working in Production, Development and Test support. Worked in the area of patching, backups, administrating and maintaining Oracle Database. Immediately available to join.

Professional Experience Infosys Limited: Oracle Database Administrator [August 2013 - March 2016] Project: Telecommunication DomainDescription:

We take care of the day to day activities/issues which occur in databases. We support more than 700 databases. In addition to that, we are presently deploying more than 800 patches on varied

environments. We are also undergoing the training for EM 12C.

Core Competencies: 2.6 years of result oriented professional experience in administering Oracle Database 10gR2 and

11gR2. Managing over 700 databases on Linux, Unix and Solaris platform with database sizes 2 TB+. Database Server Administration-Experience in PSU Patching for 2 node RAC cluster. Management of Table spaces such as creation /dropping and modification of Storage parameters

depending on the application. User management (creation, dropping, granting and revoking privileges, account (lock, unlock,

password expire), profiles and roles. FS Management. Good knowledge in Data pump (export-import: full, schema and schema objects). Planning and implementation of Backup and recovery procedures of Databases including Hot, Cold

Backup and Recovery Manager (RMAN) Having knowledge in Data Guard administration. Done sync of primary and standby database

through manual log apply and through incremental backup. Having experience of raising SR and working with oracle support team to find the root cause and

fix the issues (bug). Generation of AWR reports and optimal memory recommendations from AWR reports. Basic RAC commands, status checking of resources, startup and shutdown of all resources and

database. Basic working commands in ASM to check space. Performance information and monitoring/interpreting alert log and trace files. Attend daily change requests for production database. Performed switchover testing of a Stand Alone environment through DGMGRL. Ticket Management tool (BMC Remedy 7.1) to manage user/project requests (SR, INC, CRQ, PBI

and PKE).Operating System:

Basic knowledge of creating users, groups, deleting users, groups, changing permissions, Changingownership, SSH configuration, topas, iostat, vmstatetc. on UNIX servers.

Crontab - Job scheduler -Scheduling RMAN backups, logical backups (exp or expdp) using shell script in cronjob, and reports generation (daily basis, weekly and monthly)

Review and modify shell scripts scheduled for RMAN backup, logical backup and for other scheduled jobs if required.

Responsibilities:

Joining the bridge calls with application team/server team to discuss any issues and giving recommendations

Monitoring and taking action the proactive group mailbox alerts Supporting the Oracle databases on windows environment. Working on customer/user requests Working on Incidents (low,medium,High) Working on changes Done Patching Basic checks for all resources on RAC environment and resource shutdown and startup activity Synchronization of standby databases. Done database recovery. Handling file system space issues. Export and import activity SR follow up to fix the bug with Oracle support team.

EducationBachelors of Technology in Computer Science [August 2008-July 2012]LIMAT For Women Percentage: 72.3%

AISSCE, CBSE [April 2007- March 2008]M.V.N Aravali Hills Percentage: 73.8%

AISSE,CBSE [April 2005- March 2006]M.V.N Aravali Hills Percentage: 90%

Academic Projects Project based training from Ducat Institute in Core Java in June-2010.

Project Undertaken : Java Exam SimulatorTechnology Used : JavaDescription : To depict the environment of Online Exam.

Project based training from Ducat Institute in Advanced Java in June-2011.Project Undertaken : War Card GameTechnology Used : JavaDescription : The equally divided deck is played by 2 players

Intelligent Transport SystemProject Description : Design smart and efficient system to manage traffic in

accordance with traffic density.Project Utility : Reduce waiting time, traffic congestion and fuel

consumption thus improving traffic efficiency

Extra-Curricular Activities and Leadership [August 2008 - July 2012]

Participated in Faridabad Industries Association on April 21, 2012 as a team member and presented the project “Intelligent Transport System Control” which was shortlisted for the competition.

Participated in the National Conference “Data Mining & Warehousing” and presented the paper on “Intelligent Transport System Control”.

Participated in Zest-2012 as Member in Literary Committee and organized the event “Baatuni (Kshanika)”.

Participated in Zest-2011 as Member in Literary Committee and organized the event “Pictionary”.

Participated in competition “Business Plan” of Entrepreneurship Cell as a team and stood second in 2010.

Participated in Technomania-2010 as Event-Coordinator and organized the event “Gadget Freak”.

Participated in Zest-2009 as Coordinator in Informalz Committee and organized the event “Arm Wrestling”.

Personal DetailsDate of Birth : 02-09-199Nationality : IndiaGender : FemaleMarital Status : Unmarried