SUMMARY

• A highly skilled and versatile Oracle Database Administrator with over 9 years of database experience. A technical leader who consistently offers creative problem - solving solutions with results that exceed business and customer expectations. Proven ability to build strong relationships with internal customers and external vendors.
• 9 years of experience in the field of Oracle Databases Administration handling complex and heterogeneous database systems in high availability production environment which are supporting mission critical applications.
• Working as a part of team and providing 24X7 production support 11g/10g/9i databases hosted on platforms HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
• Proficient in database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, capacity planning, space management, database security, auditing, troubleshooting, physical and logical database design, TAR support, Unix shell scripting and documentation.
• Excellent knowledge on oracle 10g and 11G architecture and administration, good understanding of new features.
• Experience in configuration of Oracle 10g, 11g and 12c physical & logical standby database using Data Guard.
• Expertise in Disaster Recovery Planning and high availability solutions by performing switchover and failover operations in Data Guard.
• Experience in creating and managing Single Instance databases and RAC primary and standby databases under various business critical environments.
• Good hands-on experience in High Availability solutions with Oracle 10g, 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams, Golden gate.
• Good hands-on experience in configuration of Oracle 10g R2, 12c OEM Grid Control to monitor database.
• Good hands-on experience applying recommended Upgrade Patches as well as CPU/SPU and PSU patches to the standalone and RAC databases.
• Excellent experience in cloning oracle databases for development and testing using manual and RMAN backup and restores using duplicate database backups.
• Excellent skills in logical backup techniques using Data Pump and export/import utilities and Physical backups (Cold and Hot) manually and using RMAN.
• Extensive skills in performing database crash recoveries techniques like Point in time/scn/cancel using full backup, level 0 and level 1 incremental differential and cumulative backups.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
• Excellent skills in generating execution plan using EXPLAIN PLAN and gathering reports using TKPROF for Application Tuning and gathering optimizer statistics for SQL Tuning.
• Experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Experience in creating and managing control files, redolog files, data files and archive redolog files.
• Experience in Database and table reorganization using methods like Online table reorganization, coalesce, deallocate and shrink space.
• Expertise in Network Management like configuring database listeners and net service names manually and using tools like Network Manager (netmgr) and Network Configuration Assistant (netca).
• Expertise in usage of oracle tools like DBCA, Datapump, Import/Export, OEM, Putty, Oracle Universal Installer, SQL Loader and Toad.
• Participate in Oracle updates, fixes and upgrades / Software Patches - e.g. validate the upgrade; test and exploit new features.
• Installed and Configured Golden Gate replication in Production and Pre Production environments.
• Configuration and implementation of Bidirectional Streams.
• Good experience on My Sql DB admin and configuration, replication and backup.
• Good experience on Mongo DB admin and configuration, replication and backup.
• MongoDB Data migration from MySQL to MongoDB, setting up the MongoDB Shards cluster, shell scripts to implement backup and log rotations activities.
• Expertise in RDBMS Tools like SQL Loader, Import/Export, Data Pump, RMAN, OEM Grid Control
• Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management, Materialized Views, and Oracle Streams.
• Good experience in SQL, PL/SQL, Shell Scripting, Backup and Recovery procedures.
• Experience in Capacity planning & Managing database security
• Implementation and maintenance of Database Security TDE, create and maintain users, roles, privileges and profiles.
• Setup and Configured different types of Auditing like Statement level, Object-Level and Fine-Grained Auditing.
• Performing database and Apps system administration of Oracle 9i 10g and 11g,12c databases having size 100 GB to TB’s.
• Excellent Troubleshooting skills in OS level and Database level.
• Worked as a change manager to initiate, review, assign & implement production changes following the CSDM process which are based on ITIL Methodology. 24x7 on-call Production support for database activities.
• Experience in automating the daily routine activities.
• Provided full technical support to various application teams before the databases go live.
• Experience in interaction with the top management on escalations of the complex issues.
• Communicated with Oracle support via the Metalink in order to troubleshoot important issues.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
• Strong interpersonal, communication and analytical skills.

TECHNICAL SKILLS

Databases and Tools: Oracle 11g, Oracle 10g, Oracle 9i, OEM Cloud Control 12c, SQL Plus, RMAN, RAC, GoldenGate, Data Guard, MySQL

Operating Systems and Software: Red Hat Linux Enterprise Server, HP-UX, Sun Solaris, Oracle Enterprise Linux and Windows 2008/2012/2015 , Mac OS X

Programming Languages and Tools: SQL, PL/SQL, Shell Scripting

Methodologies: ITIL V3 Foundation

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Lead Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 11gR2 clusterware on 2 node clusters for high availability.
• Installation, configuration and maintenance of Oracle 10g and 11g databases databases hosted on platforms HP-UX, SUN SOLARIS, AIX, RedHat Linux .
• Conversion of multiple single instance databases to 2 and 4 node RAC databases.
• Monitored and performed Health checks of OCR, Voting Disks and inter connect for better performance and troubleshooting issues in RAC environment.
• Upgraded databases from 10.2.0.5 to 11.2.0.3 and from 11.2.0.3 to 12.1.0.1.0 using DBUA and manual methods.
• Applied CPU/PSU patches to various database versions including 10g and 11g. Applied 11.2.0.4 patch set on multiple databases.
• Installed and Configured Golden Gate replication in Production and Pre Production environments.
• Configuration and implementation of Bidirectional Streams.
• Performed My Sql DB administration and configuration, replication and backup.
• Worked on Mongo DB admin and configuration, replication and backup.
• Worked on Golden Gate 12c Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing Golden Gate configuration.
• Configured different levels of Auditing like Statement level, Object-Level, Fine-Grained Auditing.
• Setting up of Data Guard for production databases and resolved archive log gap issues and performed switchover and failovers.
• Performed migration of Non ASM databases to ASM databases.
• Database server tuning. Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers.
• Planned and performed Daily, Weekly and Monthly backups and also tested and performed various restore and recovery scenarios using RMAN on test databases.
• Cloned the database using RMAN using Active Database feature to configure Active standby database for Data Guard environment.
• Exported and imported database objects and schemas from one database to another using Data Pump utility.
• Performed database refresh activities using Data Pump utilities (expdp/impdp) to perform table level and database level defragmentation.
• Finely tuned SQL statements using Explain Plan and Statspack. Optimized SQL statements for maximum performance by using TKPROF and Explain Plan.
• Resolved database issues with the help of Oracle Customer Support via Meta link.
• Involved in customer service orientation and consulting with the customers for resolving business escalation problems.

Environment: Oracle 11gR2, 10g on HP-UX, IBM-AIX, Linux, Sun OS. Database 10g/11gR2/12c, Oracle Enterprise Manager 10g/12c, Golden Gate, Toad, RMAN, Data Pump, Putty, SQL Developer, Shell Script, OUI.BMC Remedy, espresso

Confidential

Sr. Oracle DBA

Responsibilities:

• Upgrading the databases from Oracle 10 to 11g.
• Migrated databases from HP-UX to AIX.
• Configured Oracle 10g Dataguard with Two Dataguard standby databases and resolved archivelog gap issues.
• Migrated databases from single instance to RAC environment.
• Implemented database new features like Automatic Shared Memory management, online table redefinition and Flash Recovery Area.
• Applied Oracle Critical Patch Updates to resolve the security vulnerabilities.
• Analyzing and tuning the database performance using AWR, ADDM and ASH reports.
• Performed database installations and configuration.
• Managed disk space and capacity planning.
• Applied database patchsets to resolve the database bugs.
• Implementing the database security using Oracle database profiles and password verify function.
• Performed database cloning using RMAN Duplicate feature and Active Duplication feature.
• Created RMAN backup scripts for full, incremental and cumulative level backup for both tape and disk locations.
• Performed database point-in-time recovery using RMAN backup.
• Creating and maintaining RMAN catalog database for development and production databases.
• Created and maintained tablespaces, data files, redolog files, indexes and undo/rollback segments.
• Analyzing and Tracing top SQLs affecting the database performance and coordinating with the application team to solve in timely manner.
• Configuring database archivelog mode and force logging for database recovery.
• Migrated databases across various platforms using transportable tablespace and RMAN.
• Generating the capacity management report to analyze and procure the storage for future space requests.
• Refreshing databases across the environments using hot backups, datapump and export/import.
• Involved in customer service orientation and consulting with the customers for resolving business escalation problems.
• Managing and creating users, profiles, roles, privileges as per the client requirement.
• Created and managed database objects like tables, indexes, partitions, views, sequences etc.
• Modifying Oracle parameter (init.ora) for Oracle performance and growth.
• Created database links and listeners for database connectivity both remotely and in the host.
• Participated in On-call Rotation Schedule within the DBA group.
• Resolved database issues with the help of Oracle Customer Support via Meta link.

Environment: Oracle 11gR2, 10g on HP-UX, IBM-AIX, Linux, Sun OS. Oracle Enterprise Manager 10g, Golden Gate, Toad, RMAN, Data Pump, Putty, SQL Developer, Shell Script, OUI.BMC Remedy