PROFESSIONAL SUMMARY:

• 7+ years of professional experience as an Oracle Database Administrator with expertise in Oracle 12c, Golden Gate, Backup & Recovery using RMAN, RAC, ASM, Flashback Technology, Performance Tuning, Capacity planning, Patching, Migration/ Upgradation, Data guard and Cloning.
• Extensive experience on Database Administration for Oracle 12C, 11g, 10g & 9i databases on very large - scale environments on different platforms such as Linux AIX, etc.
• Experience in Oracle cluster-ware setup and configuration, installation of oracle RAC using ASM.
• Experience in setting up Oracle Golden Gate unidirectional and bi-directional data replication.
• Expert in cloning of databases using 12c PDB cloning (local and remote).
• Good experience on Backup & Recovery methods of Database using RMAN. Good experience in export/import using data pump.
• Involved in Instance Tuning and SQL Tuning of the database to improve the performance.
• Experience in implementing High Availability solutions with Oracle Data Guard(created physical and logical standby databases).
• Strong skills of upgrading databases to higher version (11g to 12c,10g R2 to 11g).
• Experience in application tuning (SQL statements and storage structures) and Instance tuning (Memory, I/O) using various tools like ADDM (Automatic Database Diagnostic monitor), AWR (Automatic workload Repository) and statspack.
• Experience in using Flashback Technology (Flashback full container, using flashback version and transaction queries).
• Good experience in configuring ASM and providing Automatic Storage Management for Oracle data files, control files and redo log files, etc. in RAC environment.
• Worked on variety of platforms like Windows, Unix/Linux, Sun Solaris, HP -UX & AIX.
• Expert in handling the Oracle Enterprise Manager (OEM).
• Experience in applying bug fixing patch sets on databases.
• Experience in creating databases manually and using DBCA (Database Configuration Assistant).

TECHNICAL SKILLS:

Databases: Oracle 12C, 11g, 10g, 9i & 8i

Operating Systems: UNIX, LINUX, SUN SOLARIS, HP -UX, AIX & WINDOWS NT/ 98/2000/2003.

Languages: SQL, PL/SQL, UNIX Shell Scripting, XQuery, HTML& C.

Tools: /Utilities: GoldenGate, OEM, RAC, RMAN, ASM, Data pump, Data Guard, SQL Developer, TOAD, ADDM & AWR, MobaXterm.

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Sr. Oracle Database Administrator

Responsibilities:

• Created 12c container (3-node RAC on ASM and standalone) databases on Linux.
• Installed GoldenGate and set up unidirectional data replication from multiple source systems to one data warehouse on 12c databases.
• Configured integrated extracts and replicats.
• Created scripts to monitor the status of extracts and replicats.
• Tuned GoldenGate to handle tables with high transactions and large amount of data.
• Worked on setting up credential stores to store GoldenGate logins and passwords.
• Implemented partitioning on large tables to help with performance.
• Worked on unplugging/plugging and cloning of PDBs. Used Remote cloning method to create PDBs by cloning a remote PDB with the help of DB Links.
• Implemented Transparent Data Encryption (TDE) on 12c databases. Worked on creating password-based software key stores, Auto-login key stores, Keys, taking backup of key stores, etc.
• Export/Import of master encryption keys in case of moving databases or cloning.
• Worked on storage migration from Netapp to EMC.
• Configured backups using Commvault tool for both standalone and RAC databases. Monitored backup reports daily.
• Configured and used Flashback Technology for recovery of objects in the database.
• Performed database refresh activities by exporting and importing data using datapump utility.
• Worked on setting up purging policies to trace files using ADRCI.
• Applied PSU patches to 12c databases.
• Involved in Security Management by creating roles and assigning them to users depending on their requirement.
• 24X7 Production on-call support

Environment: Oracle 12C, RAC, Linux, AIX, OEM, CommVault, SQL Developer, MobaXterm, Shell Scripting.

Confidential, New York

Oracle Database Administrator

Responsibilities:

• Installation and configuration of oracle 12c and 11g RAC.
• Upgrading of oracle databases from 11g to 12c.
• Creating Databases on RAC environment and troubleshooting issues.
• Administration of oracle databases 12c and 11g using OEM (Oracle Enterprise Manager). working on backup and recovery methods of databases using RMAN utility.
• Performing application tuning of poorly written SQL statements and storage structures, Instance tuning of memory & I/O using the tools ADDM and STATSPACK.
• Installed and configured bi-directional GoldenGate for high data availability.
• Implemented high availability solution using Data Guard.
• Successfully migrated the data from files to oracle database.
• Developed Shell scripts, PL/SQL procedures and Triggers as per the requirements of the application.
• Monitoring the health of the database by checking the alert log files and trace files frequently.
• Generated AWR and ADDM reports to improve the performance.
• Implemented patch sets on databases to fix the bug problems.
• 24*7 production Database Administration and on-call support.

Environment: Oracle 11g/12C, Oracle 10g/11g RAC, Linux, Sun Solaris, HP -UX11, OEM, AWR, ASM, Shell Scripting, ADDM, STATSPACK.

Confidential, Illinois.

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 11g and 10g databases and responsible for its administration.
• Upgrades database from 10g to 11g on Linux.
• Involved in Tuning of time consuming SQL Queries.
• Maintained database backup and recovery by using RMAN utility and logical backups.
• Used GoldenGate technology to replicate data across databases and migrate data between databases.
• Used Oracle GoldenGate Replication for Reporting.
• Involved in migration of data from files to oracle database.
• Enhanced the performance of the applications by dividing the large amount of data into smaller tables and indexes with the help of Partitioning.
• Created Standby databases on OLTP environment to synchronize automatically with the production database.
• Developing shell scripts for automatic backup and also to check the errors in alert file to monitor database health
• Implemented and maintained User management and Security.
• Fixed Security and priority problems using patch set updates.
• Analyzed AWR and ADDM reports to resolve performance issues.
• Setting up the SGA parameters according to the requirement.
• 24*7 production Database Administration and on-call support.

Environment: Oracle 10g/11g, Linux, IBM-AIX 6.1, Sun Solaris, AWR, ADDR, Oracle 10g RAC, Shell Scripts, ASM, SQL, PL/SQL, Oracle OEM.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and configured the Oracle 10g RAC databases on Linux platform.
• Upgraded the databases from Oracle 9i to Oracle 10g.
• Performed regular day-to-day backups using RMAN utility.
• Written shell scripts for backups and triggers for database maintenance using PL/SQL.
• Maintained the database Security. Created Users and granted them the specific Roles and Privileges, Dropped users according to the requirements.
• Created indexes to enhance the query performance.
• Creating profiles and attaching them to users.
• Performing day-to-day activities like database backup, keep tracking of the alert log files & trace files and monitoring the disk usage.
• Reorganization of tables using Expdp & Impdp.
• Creating tablespaces by allocating a specific block size.
• Generated STATSPACK reports to monitor the system.

Environment: Oracle 10g/11g, Linux, Sun Solaris, HP -UX11, Oracle 10g RAC, Shell Scripts, ASM, SQL, PL/SQL, Oracle OEM.