SUMMARY

• Confidential is an experienced Oracle Database Administrator (DBA) with over 9+ progressive years of proven experience solving complex database, OLTP, data warehousing, and database intelligence systems.
• He has supported development, testing, and production environments on Exadata machines, HP - UX, Linux, AIX, Solaris, and Windows 2008/2012.Experienced in several other technologies like Oracle Goldengate, Shareplex for Oracle, MS SQL Server and MySQL. Good knowledge on Mongo, Hadoop, E-business R12 and AWS web services.
• Extensive experience as an Oracle DBA (12c/11g/10g/9i) non-RAC and RAC including installation, configuration, performance tuning, backup and recovery, disaster recovery etc.
• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments
• Experienced in installation, configuration and maintenance of ORACLE 10g/11Gr2/12c RAC, ASM database for high availability on Exadata, HP-UX, Sun Solaris, Linux and AIX.
• Extensive experience of Oracle Exadata in various aspects of installing, configuring, monitoring, applying/rollback of bundle patches, one-offs, Storage cell software, InfiniBand switch software, ILOM firmware etc.
• Experienced in troubleshooting Exadata issues on X3, X4.
• Extensive experience on Oracle 12c new concepts of multitenant container databases, configuring, managing and upgrading.
• Extensive experience in upgrading/migrating databases from 9i, 10g to 11gRAC and 11gRAC databases to 12c RAC on Linux, Solaris servers. Worked on multitenant architecture by creating and maintaining container and pluggable databases.
• Experienced in Oracle Migration and upgradation of applications. Good understanding of migration processes and doing the migration and upgrades of 10gr2 databases to 11gr2 from HP-UX to 11gr2 SunOS servers, involving character set conversions using CSSCAN and CSALTER.
• Experienced in administration of databases like Creating and Managing Users, Views, tablespaces, indexes, roles, space management, and resizing, partitioning and shrinking tablespaces. Database security by restricting users by granting related privileges, roles.
• Experience in Capacity planning, Sizing tablespaces, create database, scripts, Monitor databases, interact with developers, Oracle Install, 24x7 operation DBA support, Disaster recovery Automate jobs, Schema managing, Tune database, Tune SQL.
• Experienced in SQL Performance and Database/Instance Tuning of the database using AWR/ADDM reports, SQL TRACE, SQLT, Explains plans, Sql Tuning Advisor, Memory Tuning advisors, OSWATCHER etc.
• Worked on Database refreshes from Production environment to Scrub box using various tools Datapump, RMAN, Oracle SMU, EMC Clone, and cleansed the PCI sensitive data. Cleansed databases are then used for refreshing non-production environments for development/test team purposes.
• Applied oracle critical patches and other patches with rolling strategy using oracle utilities.
• Good expertise in writing of UNIX shell scripts and scheduling cronjob. Use of awk, grep, top, sed, etc commands.
• Strong leadership qualities with ability to define individual and shared goals for teams and growth path for individuals. Good interpersonal Communication Skills and a good Team player with activities and timelines.
• Got trained and did certification on Oracle EBS R12 Administration.
• Extensive Knowledge on Cloning Oracle applications using Rapid clone, Patching Oracle Applications using adop, Customizing autoconfig templates etc.
• 8+ Years of experience working on setting up, maintaining and troubleshooting Dataguard (Physical, Logical and Active Dataguard) for Disaster recovery and reporting purposes.
• 4+ Years of experience in Oracle Goldengate replication.
• 4+ Years of experience in Shareplex replication for Oracle.
• Experienced working on setting up and maintaining Dataguard (Physical, Logical and Active Dataguard) for Disaster Recovery purposes.
• Installed and Configured Dataguard Broker and Observer to implement FSFO for fast and Automatic Failovers.
• Upgraded databases from 9i/10g to 11g RAC and 11g RAC to 12c RAC with minimal downtime using Oracle Goldengate replication tool.
• Installed, configured Shareplex Replication which replicates from online to reporting Servers and disaster recovery servers.
• Supported 4-way Shareplex replication for Oracle databases 11g on Linux Servers.
• Experienced in troubleshooting various issues like performance, out of sync in Shareplex, Goldengate, Dataguard environments.
• Implemented Oracle Goldengate for uni-directional, bi-directional in Oracle environments.
• 2+ Years of experience as an SQL Server Dba on versions MS SQL Server 2005/2008/2012 .
• 2+ years of experience as an MySql DBA on versions MySql 5.1/5.5/5.7 on Linux platforms.
• Experienced in Administering MS Sqlserver databases 2005/2008/2012 like Creating users, granting privileges, monitoring performance, storage etc.
• Involved in Upgrading MS SQL Server 2005 databases to 2012 version on Windows server 2012.
• Involved in planning and monitoring Log Shipping.
• Planning, implementing and troubleshooting SQL Server Replication.
• Monitoring extended events, event logs and Server error logs for troubleshooting purposes.
• Responsible for Database Backups & Restoration, Backup Strategies and Scheduling Backups.

TECHNICAL SKILLS

Databases: OLTP, Data warehouse, Oracle Databases 12c/11g/10g/9i/8i, MS SQL Server 2005/2008/2012 , MySQL 5.1/5.5/5.7, Teradata 13/14, Mongo 2.6/3, Redshift.

DBA Skills: Database Maintenance, Disaster Recovery, Security Management, HA Management, RAC, ASM, CRS cluster.

Tools: /Utilities CRON, TOAD 10.1/12, OEM Grid Control 10g/12c, Datapump, export/import, SQL Loader, RMAN, DBNEWID, BMC Change Control, Erwin, Shareplex for Oracle, AWR, ADDM, Oracle Streams, Sql Developer, Oracle Golden gate, DB Artisan 8.7/9.7.

Shell Scripting: UNIX Shell Scripts on Sun Solaris, HP-UX and Linux platform

Operating Systems: RHEL 4.0/5.2/5.6/6.2/6.5/6.8 , HP-UX 10/11.21, 11.31, AIX 4.3/7.1, Solaris 8/7/11, SunOS 5.10, Oracle Linux, Windows 2003/2008/2012

Languages: C, JAVA

PROFESSIONAL EXPERIENCE

Confidential, Chandler, AZ

Sr. Oracle DBA

Responsibilities:

• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments.
• Experienced in supporting Oracle 11gR2 RAC and Oracle 12c RAC databases on AIX, SunOS 5.10, Linux servers and on Exadata machines.
• Installed and Configured 6 node 12c RAC with Data guard setup on Linux, Solaris servers.
• Upgraded Oracle 11g database to 12c databases. Worked on multitenant architecture by creating and maintaining container and pluggable databases.
• Installed, configured and maintained Oracle Golden gate 12c between oracle databases and upgraded databases from 11g to 12c with minimum or zero downtime.
• Experienced in converting a non-cdb database to cdb database, cloning pluggable databases, performing point-in-time recovery for a pluggable database. Experienced in 12c multitenant databases performance tuning.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Experienced in implementing and managing Oracle Exadata Machine. Oracle Certified Exadata Implementation Specialist.
• Extensive experience of Oracle Exadata in various aspects of installing, configuring, monitoring, Storage cell software, InfiniBand switch software, ILOM firmware etc.
• Involved in creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers.
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc.
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications. Monitor and troubleshoot database issues with OEM grid control.
• Experience in writing autosys jils for Oracle jobs.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: Oracle 11gR2/12cR1, Solaris 11, RHEL 6.5, Dbartisan 9.7, AIX 7.1, Shell Scripting, RMAN, Data pump, OEM 12c Grid Control, Pac2000, Exadata.

Confidential, Scottsdale, AZ

Sr. Database Administrator

Responsibilities:

• 24/7 Supported critical OLTP Production databases on RAC and non-RAC with Goldengate and Dataguard environments.
• Installed, Configured and maintained 11g/12c RAC and non-RAC databases on AIX servers.
• Upgraded Oracle 11.2.0.4 RAC databases to 12.1.0.2 on AIX and Linux servers.
• Built Dataguard physical and Active databases on AIX servers.
• Experience in implementing Oracle wallet (TDE) for data security for single and RAC databases.
• Worked on Performance issues which rose after migrations using AWR, ADDM, and Sql tuning Advisors etc.
• Maintaining and Troubleshooting Goldengate replication v11.1 in 2 Node RAC database in AIX servers.
• Experienced in Database refreshes in production to non-production using RMAN, datapump.
• Created and Managed users, user profiles, tablespaces, datafiles, archive log.
• Monitor and troubleshoot database issues with OEM 12c grid control.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: Oracle 10gR2/11gR2/12c, RAC, ASM, Goldengate v11.1, Data Guard, AIX 6.1, Linux, Solaris 5.10, Shell Scripting, RMAN, Data pump, OEM Grid Control 12c, Toad for Oracle, PCI.

Confidential, Phoenix, AZ

Sr. Database Administrator

Responsibilities:

• 24/7 Supported critical OLTP Production databases on RAC and non-RAC with Goldengate and Dataguard environments.
• Have a good understanding of Wyndham hotel business and its brand partners.
• Reviewing Development team requests, discussing and suggesting oracle recommended approaches to maintain healthy database.
• Installed, configured and maintaining 2 Node 11.2.0.3/12 c RAC databases in Linux/Solaris Servers.
• Experienced in monitoring database performance through OEM and through database command line.
• Maintaining and Troubleshooting Goldengate replication v11.1 in 2 Node RAC database in Solaris servers.
• Experienced in Database refreshes in production to non-production and masking the sensitive data in non-prod environments.
• Documented Audit mechanism and implemented for the oracle databases according to PCI security requirements.
• Experienced in Administering Teradata databases like Creating users, granting privileges, monitoring performance, storage etc.
• Experienced in Teradata viewpoint, which is used for monitoring users, storage, performance etc.
• Experienced in preparing Design/Vision documents and identifying database/server requirements for new projects.
• Experienced in Administering MS SQL Server databases like Creating users, granting privileges, monitoring performance, storage etc.
• Experience working in PCI and SOX environments and processes related to management of such environments.
• Experienced in Basic MS SQL Server Database Administration.
• Upgraded Oracle 11.2.0.3 2 Node RAC databases to 11.2.0.4 on Solaris servers.
• Performed troubleshooting of database using AWR and ADDM reports for 11g databases.
• Performed SQL tuning using SQL Tuning Advisor in Oracle Enterprise Manager.
• Worked with oracle support and performed root cause analysis for critical issues.
• Installed Oracle snap management utility (SMU), which is used for database cloning, refreshes and database backups.
• Working on multiple projects and delivering projects within timeline.

Environment: Oracle 10gR2/11gR2/12c, MySql 5.1/5.5/5.6, RAC, ASM, Goldengate v11.1, Data Guard, Linux 6.2, Shell Scripting, RMAN, Data pump, OEM Grid Control 12c, Toad for Oracle, Oracle SMU, Teradata 14, Teradata viewpoint, Oracle Goldengate, MS SQL Server, PCI, SOX.

Confidential, San Ramon, CA

Oracle Production DBA

Responsibilities:

• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments.
• Installed and Configured 3 node 11.2.0.3 RAC with Data guard setup on AIX.
• Working on Migrations of 10g databases to 11g databases on AIX environment.
• Installed and configured OEM 12c grid agents on AIX servers.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Built Dataguard physical and Active databases on AIX servers.
• Experience in implementing Oracle wallet (TDE) for data security for single and RAC databases.
• Installed and Configured Dataguard Broker and Observer to implement FSFO for fast and Automatic Failovers.
• Configured RMAN backup jobs for newly built databases.
• Worked on Performance issues after migrations using AWR, ADDM, and Sql tuning Advisors etc.
• Implemented Oracle latest features Advanced Compression, Oracle partitioning (Interval Partitioning).

Environment: Oracle 9i/10gR2/11gR2, RAC, ASM, Dataguard with FSFO, DG Broker, Observer, AIX, Linux, Shell Scripting, RMAN, Data pump, OEM Grid Control 12c, Toad for Oracle.

Confidential, San Leandro, CA

Oracle Production DBA

Responsibilities:

• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments.
• Experienced in supporting Oracle 11gR2 RAC databases on SunOS 5.10, Linux.
• Installed and Configured 3 node 11.2.0.3 RAC with Data guard setup on Linux.
• Monitoring and supporting more than 100 database instances using scripts and daily health check like alert logs, invalid objects, tablespaces usage, long running queries, backups, listener up and running, etc. Writing UNIX shell scripts and set into cronjob to monitoring all databases and send alerts in email. Also, wrote scripts for monitor Shareplex and migration monitoring and purging.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Involved in building backup and recovery plans for critical databases from failures with minimum downtime.
• Involved in creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers.
• Aided application team at the time of SQL tuning in applications.
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc.
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Installed, Configured and Supported application, which had 4-way shareplex replication.
• Upgraded databases from 9i, 10.2.0.4 to 11.2.0.2/11.2.0.3 , applied CPU patches and put one-off patches, which has 4-way replication with shareplex replication without any downtime.
• Created and maintained partitions for large tables, used 11g partitioning feature automatic partitions creations.
• Experienced in Advanced Compression, table partitioning.
• Created and Managed users, user profiles, tablespaces, datafiles, archive log.
• Monitor and troubleshoot database issues with OEM grid control.
• Experience in writing autosys Jils for Oracle jobs.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: Oracle 9i/10gR2/11gR2, SunOS 5.10, HP-UX 11.11, RHEL 5.6/6.2, Dbartisan 8.7, AIX, Shell Scripting, RMAN, Datapump, OEM Grid Control, Db Artisan, Pac2000.

Confidential, Irvine, CA

ORACLE Production/Migration DBA

Responsibilities:

• Installation, Configuration, Maintenance of oracle 10gR2, 11gR2 databases on SunOS 5.10.
• Migration and consolidation of 9i, 10gr2 databases from hp-ux/Solaris to 11gr2 SunOS server Farm, and involving character set conversions using CSSCAN and CSALTER.
• Migrated more than 50 applications (around 50 databases) using datapump, RMAN, Transportable tablespaces (TTS).
• Implemented transportable tablespaces method for migrating huge databases (up to 10 TB) and resolved the issues during the migration of live Production databases.
• Used Datapump export/import as the prime method for migrating smaller applications. Also, worked on customizing the process by creating pre-check, migration and validation scripts.
• Validated the database migrated from offshore as per migration process.
• Implemented Oracle Goldengate for replication between Oracle database tables.
• Implemented RMAN cloning as a migration strategy for very large applications and later customized the target environment as per client standards. Renamed Databases to new name using DBnewid.
• Upgraded databases from 10.2.0.4 to 10.2.0.5 using Patch sets.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Scheduled jobs like collecting stats for tables/indexes etc., regular backups and monitoring tasks using Oracle scheduler, Crontab.

Environment: Oracle 9i/10gR2/11gR2, SunOS 5.10, HP-UX 11.11, Toad 10.1.1.8, Shell Scripting, RMAN, Datapump, CSSCAN, CSALTER, OEM Grid Control, Oracle Goldengate 10.

Confidential, Old Columbia Pike, MD

Oracle DBA

Responsibilities:

• Supported critical OLTP development and Production databases on RAC environment.
• Upgraded oracle databases from 9i to 10gR2 and 10gR2 to 11gR2.
• Installed and Configured of OEM Grid Control to administer and monitor database.
• Worked with a team for installation and maintenance of 4 nodes ORACLE 11g RAC, ASM database for high availability on HP-UX 11.31 server. Well conversed using the CRSCTL and SRVCTL tools for maintaining database.
• Supporting Developers and testing teams across different projects for new module implementation, DDLs and package creation using Erwin Data modeler logical to physical design, refreshing data for testing environment from production using RMAN and Datapump.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration.
• Implemented failover strategy using HP Service guard.
• Worked on Shareplex Replication, which replicates from online to reporting Servers and disaster recovery servers.
• Installed, Configured and used BMC change control to track DDL changes for the Oracle databases.
• Involved in partitioning large tables to improve the performance.
• Performed troubleshooting of database using AWR and ADDM reports for 10g, stats pack for 9i databases. Performed SQL tuning using SQL Tuning Advisor in Oracle Enterprise Manager.
• Experienced in doing Complete/Incomplete and Tablespace point in time recovery of database using RMAN.
• Used Erwin for data modeling to support application teams.

Environment: OEM Grid Control, Oracle 9i, 10g, 11gr2, HP-UX 10/11.21, 11.31, AIX 4.3, RMAN, HP Service guard, Import & Export, Datapump, Data guard, oracle 10g/11g RAC, ASM, CRS clusters, BMC change Control, VERITAS Cluster, TOAD 7.2/10.1, Shareplex replication 5.2/5.3 etc.

Confidential, Mahwah, NJ

Oracle Database Administrator

Responsibilities:

• Support has been provided for the critical OLTP databases, Data warehouse Production databases.
• Upgraded oracle databases from 9i to 10g.
• Worked on RAC on Red Hat Linux Advanced Server with 4 nodes.
• Successfully implemented physical standby database using Oracle Data Guard feature for Disaster recovery in RAC.
• Planned, tested and implemented different backup and recovery strategies for 9i and 10g databases using RMAN utility.
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc. Aided application team at the time of SQL tuning in applications
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Communicated and coordinated with Oracle using TAR system for major database issues/ problems; apply the required patches, test and roll out and implement the patches into production.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, RHEL 4.0, RMAN, Import & Export, Datapump, Data guard, VLDB, ASM, TOAD, VERITAS Cluster etc.