SUMMARY

• Technically sophisticated & result driven Oracle 10g Certified Associate with 8 years of professional experience in Database Administration.
• Spearheading the effort with Confidential Wireless as an Oracle RAC Database Administrator.
• Involved in Installation, Configuration, Patching, Space Management, Starting and stopping and Monitoring Database Server, Troubleshooting in Backup, Optimizing performance tuning on Databases in high availability Production Environments.
• Demonstrated problem analysis/ resolution skills, ability to troubleshoot, solve problems quickly & completely.
• Independently handled multiple databases for multiple clients (Leveraged) in multiple environments.

TECHNICAL SKILLS

Database: Oracle Database 10g/11g/12c, Oracle Apps

Database Tools: Oracle Enterprise Manage(OEM), OUI, Migrations, DB control/Grid Control, RMAN, SQL Developer, Oracle, Export/Import(IMPDP & EXPDP), Oracle Database Assistance, TKPRPF, SQL Plus, ISQL Plus,Golden Gate, Exadata

Operating Systems: SQL server 2008, SQL server 2014,Windows 2000/03 Server, Windows XP, IBM AIX, Confidential UX, Solaris

Programming Skills: PL /SQL programming,, Shell Scripting in UNIX,LINUX

PROFESSIONAL EXPERIENCE

Confidential

Oracle database administrator

Responsibilities:

• Participate in Change Management meeting, Taking ownership in giving RCA of critical issues.
• Oracle Enterprise Manager (OEM) installation and Administration 12C, 13C.
• Experienced in troubleshooting and decision making knowledge on Mission critical issues during bridge call.
• Oracle 11g config, administration, troubleshooting.
• Capacity planning, database architecture/design for 11g databases.
• Performance tuning for production databases .
• RMAN Backup and Recovery - Standalone and RAC; Physical Standby Database and Active Data guard Standalone and RAC.
• Oracle DBA responsibility for all L1, L2 & L3 tasks including monitoring, maintenance, user management, refresh, data pump.
• Making structural changes to the databases
• Routine dbase tuning & administrative activities
• Planning and executing of db maintenance activities like dump & load, index rebuild, databases health checkup
• Administrating in Golden gate .
• Create shell scripts to automate/monitor dbase operations
• Providing test databases to application, development and testing team based on request.
• Optimizing the performance of production databases.

Confidential

Oracle RAC Database Administrator

Responsibilities:

• Administrating and Maintenances of 24*7 production databases.
• Oracle DBA responsibility for all L2 & L3 tasks including monitoring, maintenance, user management, refresh, data pump, New server build up projects .
• Installation and configuration of oracle 11g/12c databases.
• Planning and Implementation of various data guard and Physical standby setup with switchover and failover tests in Production environments
• Golden Gate activates of the live databases for testing and development.
• Database up gradation and migrations.
• Creation of monitoring tools and automated DBA tasks using shell scripts.
• Installation of Oracle 10g and Patch installation in AIX and LINUX
• Implementation of Data Guard on LINUX.
• Experience on RAC environment and hand on practice.
• Conceptual knowledge of RAC environment.
• Installation of Grid control and oracle client 11g.
• Implementation of RMAN backup & recovery procedures.
• Database creation, migration &up gradation.
• Making structural changes to the databases.
• Routine database administrative activities in golden gate.
• Planning and executing of db maintenance activities like dump & load, index rebuild, databases health checkup.
• Create shell scripts to automate/monitor dbase operations.
• Providing test databases to application, development and testing team based on request.
• Optimizing the performance of production databases.
• Experienced in troubleshooting and decision making knowledge on Mission critical issues .

Confidential

Oracle RAC Database Administrator

Responsibilities:

• Verifying backup report and checking backup jobs in crontab.
• Configuration of RMAN
• Performing Level0 and Level1 backups
• Validating the Backup Sets and checking successful and failed backups.
• Preparing Backup scripts and configuring in different database as per environment.
• Starting and Stopping Instances and Oracle cluster ware.
• Backup and Recovery of Voting Disk and OCR.
• Adding and Deleting Nodes.
• Running manual gather stat job weekly basis.
• Migrations of data files from one mount point to another.
• Oracle Client Installation in different database.
• OUI used for grid control.
• Installation of OUA in production environment.

Confidential

Oracle RAC Database Administrator

Responsibilities:

• Monitoring the nodeapps status of multiple rac databases.
• Checking the status of backups for node apps.
• Experience on ASM and Exadata
• Starting and Stopping Instances and Oracle cluster ware.
• Administering OCR and Voting Disk.
• Backup and Recovery of Voting Disk and OCR.
• Adding and Deleting Nodes.
• Running manual gather stat job weekly basis.
• Migration of database from Non ASM to ASM end.
• Experience in PL/SQL Programming