SUMMARY

• Having 9+ yrs of experience as a Database Administrator, this includes Oracle databases Production, Test, Dev and Real Application Cluster Database experience.
• Have the extensive experience in database support, upgradations and migrations from Oracle 9i/10g to Oracle 11g, Oracle 12c in mixed environments and cross OS platforms (Linux, Solaris, HPUX, AIX, and Windows Server).
• Installed and configured Oracle 9i/10g/11g/12c and Oracle RAC databases on Linux & UNIX Solaris environments.
• Upgraded Oracle Database from 10g/11.2.x to 12.1.0.x.
• Installed and configured of MS Sql Server 2001/2005/2008/2010/2012 databases.
• Installed MySQL 5.6 on Linux and provide support.
• Installed and Configured Oracle 11g GoldenGate.
• Configured OEM 13c/12c for databases monitoring.
• Performed GoldenGate migration activities from 11.2.0.2 to 11.2.0.4
• Involved in configuration of Oracle GoldenGate and Streams.
• Expertise in Migration of database from Non RAC to RAC.
• Upgraded Oracle RAC from 10g to 11g
• Upgraded Oracle Databases from 9.2.x/10.1.x to 11.2.x/10.2.x and Migrated From 10.1.x/11.1.x to 10.2.x/11.2.x
• Expertise in Migration of database from Non RAC to RAC.
• Involved in automation of the table partitions and indexes for the data ware house databases.
• Configured Oracle GoldenGate functionality between Oracle and MsSql Server Databases.
• Expertise in troubleshooting of Oracle GoldenGate process.
• Build the new environments using Oracle GoldenGate functionality.
• Troubleshooting of manger, extract, replicate processes in the Oracle GoldenGate.
• Configured Active Dataguard and provided support for the RAC instances.
• Performed failover and Switchover activities.
• Expertise in configuring Disaster Recovery - Physical Standby Database, Using cold backup in different mode like Max Protection, Max Availability, Max performance.
• Configured Physical standby database and performed day to day activities.
• Worked on database performance tuning activities like query, application, memory tuning.
• Written PL/SQL code for the applications better performance.
• Reviewed and deployed the PL/SQL code in the production databases.
• Co-ordinated with CAB team and Customers for the forecasting of the changes in the production databases.
• Written the code in oracle plsql for setup functions, trigger, packages, and cursors in the database.
• Expertise in cloning of the database Using cold backup, hot backup and RMAN
• Expertise in Hot backup & cold backup And Logical backup (Exp/Imp & Expdp/Impdp).
• Configured and Maintained Oracle RMAN Backups, Involved in RMAN Pointing Time Recovery and Preformed Duplicate the database using RMAN.
• Creating the Private, Public and Global database link.
• Creating Materialized View and Using Query Rewrite for Performance.
• Migration of Non-ASM database to ASM database environment using RMAN.
• Expertise in handling Internal Errors (ORA-00600) and Corruption Issues.
• Expertise in migration of databases from HP-Unix, Solaris to Linux.
• Applied patches to the database for security purpose.
• Performed database design activities.
• Experience in configuration of automated reports using perl and UNIX shell scripts.
• Experience in migration of applications from lower to higher versions and troubleshooting application’s performance.
• Expertise in database physical and logical modeling using CA Erwin.
• Basic Knowledge on MS SQL Server 2008/2012.

TECHNICAL SKILLS

Databases: Oracle RDBMS/ORDBMS 8i,9i,10G,11G,12c (RAC,ASM and Data Guard, Flashback Database Features)MS Sql Server, My SQL

OS: Linux, Solaris, HP Unix, IBM AIX, Windows Server

Oracle Technologies: RAC, ASM, Data Guard, Standby database,, External TablesTransportable Tablespace Partitioning, Materialized views and snapshots, partitioning, Oracle Flashback, Datapump, asmlib Oracle Streams, ocfs/ocfs2,GoldenGate

Programming Languages: PL/SQL, SQL, Unix Shell scripting, (sh, bash, ksh),Perl,JAVA Scripting

Development/Administration/Performance Tools and Utilities: RMAN with recovery catalog and without, SQL PlusSTATSPACK, AWR/ADDM,TKPROF, EXPLAIN PLAN,Oracle SQL Optimizer, hints, TRACE AnalyzerQuest TOAD, Oracle Enterprise Manager, Remedy, Liquibase, SqlDevloper, Golden,Lotusnotes

Unix Tools/Commands: cron, at, vi, sed, awk, other Unix, Linux commands and utilities, Notepad ++

PROFESSIONAL EXPERIENCE

Confidential, Sterling,VA

Database Administrator-III

Responsibilities:

• Providing databases support for production, development and test environments.
• Installed Oracle11g software and created databases on Linux.
• Installed and providing support for MS Sql Server and MYSQL server databases.
• Managed Logical And Physical Database Design.
• Requirement study, Installation of Oracle 12c/11g/10g Database design & creation.
• Configured Oracle 11g dataguard and performed day to day activities.
• Installed and configured Oracle 11g/12c RAC instances on Linux and Unix
• Configured High availability using Physical standby and Dataguard.
• Preforming the failover and switchover activities for production instances.
• Configured Oracle GoldenGate and performed date to date support activities.
• Built the new environments using Oracle GoldenGate functionality.
• Working on supporting of Oracle GoldenGate instances and troubleshooting the performance issues.
• Working on configuration of Bi-directional and unidirectional replication process in Oracle GoldenGate between OLTP and OLAP databases.
• Configured the automated jobs for cleanup dump files and monitoring the manager logs for Oracle GoldenGate Instances.
• Working on code deployment process between the instances using Oracle GoldenGate.
• Experienced in monitoring databases through OEM.
• Refresh Schema and tables using datapump.
• Experienced in Production databases restoration and recovering.
• Experienced in Memory Tuning, Query Optimization, SQL Tuning & Database Tuning .
• Monitoring the ASM instances on the multiple nodes.
• Written and Implemented PL/SQL Scripts to check the performance of database.
• Experience in configuration of automated report using perl and UNIX shell scripts.
• Experience in migration of applications from lower to higher versions and troubleshooting application’s performance.
• Involved in automation of the table partitions and indexes for the data ware house databases.

Environment: Operating system: AIX, Linux, HP-Unix, Windows

Confidential, Herndon,VA

Database Architect

Responsibilities:

• Provided Oracle databases support for production, development and test environment.
• Managed Logical And Physical Database Design.
• Installed / configured Oracle 11.2.0.2 Golden Gate and implemented bi-directional replications.
• Implemented GoldenGate bi-directional with oracle 11g.
• Configured Datapump, Extract and Replication Processes in GoldenGate.
• Performed day to day GoldenGate activities
• Configured custom scripts for GoldenGate for the extract and replicate process.
• Migrated the GoldenGate from 11.2.0.2 to 11.2.0.4
• Worked on veridata configuration for GoldenGate to compare records between source and target.
• Upgraded RAC databases from oracle 10g to 11g
• Applied PSU patches for RAC databases.
• Configured active dataguard and performed DR activities.
• Configured OEM 12c for databases monitoring.
• Refresh production environment to QA/E2E/Test/Dev environment using RMAN backups and cold/hot backups.
• Refresh Schema and tables using datapump.
• Experienced in Production databases restoration and recovering.
• Experienced in Memory Tuning, Query Optimization, SQL Tuning & Database Tuning.
• Written the code in oracle plsql for setup functions, trigger, packages, and cursors in the database.
• Automated Backup & Recovery procedures using UNIX shell scripts and PL/SQL Scripts through cronjobs.
• Written code in PL/SQL, Perl and UNIX shell to generate the reports.
• Performance tuning review and provided effective technical solutions.
• Application Tuning like Procedures, SQLs using Explain plan and TKProf.
• Configured grid for monitoring all the databases.

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Confidential, Littleton,CO

Sr.Database Administrator

Responsibilities:

• Configured grid for monitoring all the databases.
• Providing Oracle databases support for production, development and test environment.
• Managed Logical And Physical Database Design.
• Upgraded databases from 9i, 10g to 11g.
• Performed production deployment activities using Oracle Golden Gate instances.
• Performed day to day GoldenGate activities
• Configured custom scripts for GoldenGate for the extract and replicate process.
• Migrated the GoldenGate from 11.2.0.2 to 11.2.0.4
• Migrated oracle databases from HP-Unix, Solaris to Linux.
• Performed switch over and failover activities.
• Configured Physical standby databases and performed day to day activities.
• Installed / configured Oracle 11.2.0.2 Golden Gate and implemented bi-directional replications.
• Performed day to day GoldenGate activities
• Refresh production environment to QA/E2E/Test/Dev environment using RMAN backups and cold/hot backups.
• Refresh Schema and tables using datapump.
• Experienced in Production databases restoration and recovering.
• Applies PSU patches for RAC databases.
• Written the code in oracle plsql for setup functions, trigger, packages, and cursors in the database.
• Automated Backup & Recovery procedures using UNIX shell scripts and PL/SQL Scripts through cronjobs.
• Experience in configuration of automated report using perl and unix shell scripts.
• Experience in migration of applications from lower to higher versions and troubleshooting application’s performance.

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Confidential

Database Administrator

Responsibilities:

• Configured grid for monitoring all the databases.
• Successfully Installed and Implemented RAC Database on Linux and Sun Solaris.
• Created various RAW Partitions for the database and symbolic links to access these Raw Partitions from the Oracle Database.
• Involved in creating the database on Shared Disk Subsystem on RAW partitions and put the Database in Archive Log Mode.
• Taking hot backup of files using Disk Dump (DD) command.
• Configured 'SRVCTL' utility to administer the RAC database.
• Configured the listeners and aliases to set up Transparent Application Failover.
• Upgraded oracle RAC databases from 10g to 11g.
• Configured GoldenGate and developed custom scripts for data replications
• Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 10g/11g RAC.
• Upgrading RAC/NON RAC databases from 9i to 10g and from 10g to 11g.
• Managing the cluster ware files i.e., OCR files & voting disk.
• Creation of RAC Database Using ASM.
• Monitoring the ASM instances on the multiple nodes.
• Configuring the RAC database in archive log mode.
• Converting the single instance database to RAC database for test instance.
• Maintaining RAC and non-RAC databases, adding ASM disks on prod and non-prod RAC databases.
• Created undo tablespaces, redologfile groups and thread 2 for adding second instance to the RAC System.
• Configured Recovery Manager (RMAN) for RAC Database backup, restore and recovery operations.
• Creation of the database with the complete understanding of hardware configuration to provide maximum performance and high availability.
• User Creation and Maintenance.
• Performed every day Database health Check.
• Taken the backup of the database regularly using Logical, Cold and Hot Backup.
• Cloning databases and Disaster Recovery Database.
• Written the code in oracle plsql for setup functions, trigger, packages, and cursors in the database.
• Tuning heavy data loads. Monitoring and Performance tuning.

Environment: Operating system: Sun Solaris, AIX, Linux, HP-Unix, windows

Confidential

Associate DBA

Responsibilities:

• Creation of the database with the complete understanding of hardware configuration.
• User Creation and Maintenance.
• Enabled the Database in Archive Log Mode
• Performed every day Database health Check.
• Taken the backup of the database regularly using Logical, Cold and Hot Backup procedures
• Taken care of space related activities.
• Assigning specific Profiles, Privileges and Roles to Database Users for Database Security.
• Creating and dropping of users, granting and revoking rights as and when required.

Environment: Operating system: Linux, HP-Unix