SUMMARY

• A highly motivated, self - starting Oracle Database professional with exceptional organization and communication skills, and more than 17 years of IT experience.
• Recognized as a consistently productive and effective team member and leader who will take on additional responsibilities and master new skills.
• A solid problem solver who will always bring projects in with the highest levels of quality control, and add to the team's effectiveness and to bottom line results.
• Delivered innovative IT solutions to directly contributing to bottom line while spearheading operational improvements to increase productivity/reduce costs.
• 24*7 Oracle DBA support and maintenance including supporting advance configurations such as Oracle ASM, Oracle RAC (9i - 12c) and Data Guard etc. Oracle Grid Infrastructure/Database upgrade.
• Very strong in Installation/Upgrade and Patching Oracle RAC/NON-RAC database
• Very good experience in Oracle Database Backup & Recovery methods including both Oracle RMAN as well as User-Managed methods (cold backup and hot backup)
• Setup and Configuration of Oracle Automatic Storage Management (ASM) 11g starting from disk provisioning and partitioning on Linux and creating/managing ASM disk groups. Zero downtime during storage migration using ASM
• PLSQL development (Procedure/Function/Package/Triggers/Advanced Queue).
• Expert in installation and setup of Oracle RAC Grid Infrastructure . Policy managed Oracle RAC database.
• Expert in designing and implementation of partitioning schemes ( Range, List, Hash, Composite ) for the database objects (Tables and Indexes).
• Strong in Oracle RAC database maintenance and support activities including RAC database backup and recovery, administration, Performance Tuning, Node Eviction troubleshooting and performing Hang analyze during unresponsive instance .
• Oracle database Performance Tuning using SQL Profile/Baseline/SQL Patch
• Good experience using Oracle tracing methods including SQL Trace with TKPROF analysis, Database wide event tracing for troubleshooting purposes.
• Strong in logical database backup and restore methods by using Oracle Data Pump Export/Import.
• Shell scripting; have written scripts for database monitoring activities and Database migration from DB2 to Oracle.
• Good experience in analyzing Oracle AWR (Automatic Workload Repository) reports for performance bottlenecks and for top resource consuming SQL queries. Additionally, I have implemented best practices for SQL and PGA sizing and involved in documentation of known database problems as they arise.
• Deploying Oracle Enterprise Manager Grid Control (OEM) with standard management, diagnostic, tuning, and change management packs to perform various administrative tasks. Setting-up and configuring Oracle Management Server (OMS) to monitoring database operation.
• Performed Daily Monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.
• Involved in on call Production support 24x7 rotation in Oracle DBA teams.
• Setup Transparent Data Encryption, Times Ten Database/Transparent Data Encryption/F5 Networks Load Balancing/Failover/EMC Data Domain, Oracle Resource Manager, Golden Gate
• Python scripting (pymongo, Oracle X) to transfer the data between Oracle and Mongo database
• AWS (migration to AWS EC2 instances)

TECHNICAL SKILLS

Operating Systems: UNIX (HP/SUN/IBM), Linux (OEL/Redhat) and MS Windows

RDBMS: Oracle 7.x to 11g R2

No SQL Database: Mongo DB

Languages: PL/SQL, SQL, Unix Shell Scripting, Java, C++, Python

Tools/Utilities: Oracle Enterprise Manager Grid Control (OEM), DBverify, SRVCTL, CRSCTL, NETCA, NETMGR, DBCA, DBUA, EXPDP, Quest TOAD 8.5, Data Domain, Recover Point, Golden Gate, Times Ten Database, Flashback, DBRM

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• As a Sr Oracle Database Engineer, responsible for Maintaining the Database infrastructure globally.
• Installation, Configuration, implementation and Administration of Oracle 11g RAC/10g RAC databases
• Patching, Upgrading and cloning Oracle databases
• Managing, troubleshooting and resolving Oracle Database and Oracle RAC issues.
• Providing support for Production/Non-Production database
• Implementing Policy Managed Database
• Data Migration using Expdp and RMAN
• Using ASM to perform storage migration with Zero downtime
• Shell scripting for automation process
• Performance tuning of Oracle Database
• Configure, manage and maintain Oracle Data Guard environments
• Working with Audit team to maintain Audit Compliance

Confidential

Responsibilities:

• Member of core engineering team, responsible for Installation, migration, upgrade of Production, DR and Non Production databases (RAC/GI/NON-RAC/RAC ONE).
• Troubleshooting Grid Infrastructure and Production performance issue and provide a solution in timely fashion (Node Eviction/Hanganalyze).
• Developed shell script(s) for Data migration from mainframe to Oracle, Housekeeping and auto startup/shutdown of non RAC database.
• Also, responsible for ongoing troubleshooting of Production (Grid Infrastructure and database) and DR (Physical Standby) database.
• Working very closely with App team (Datwarehouse, BPEL) to provide support/solution in production and non-production environment.
• Implementation of Times Ten database

Confidential

Sr Oracle Database Engineer

Responsibilities:

• Confidential has over 10,000 databases around globe.
• Working in Global Oracle (US region) team to provide production L3 support to all regions.
• Responsible for troubleshooting Sev1/2 issues in database
• Performance/Outage/Configuration/Rman issue of RAC (Clusterware/ASM) and non-RAC environments with IM (Incident Management) team to diagnose production problem and provide a solution in a timely manner.
• Worked with App team to provide a solution for any database performance/connectivity issue and deploy the changes in Production and non-production environment.
• Worked with DR team to configure/test the failover and failback of Production application.
• Worked on SAN migration project with Infrastructure team. Performed Oracle 11g Database installation/creation on RAC and non-RAC environment.
• Maintained Physical standby and Exadata environment, performed database backup/recovery using RMAN.

Confidential

Responsibilities:

• Provided consulting services to EMC and Oracle's direct client through Horizon Consulting Services
• Received consistently superior performance evaluations.
• Successfully designed and implemented diverse High availability, DR and Business Continuity solutions (using Oracle RAC, Oracle Data Guard, Oracle Golden Gate, RMAN and EMC Recovery Point).
• Commended for expertise with a major data integration project.
• Responsible for maintaining/administering/installation/performance tuning/troubleshooting Oracle Production database RAC; 5 node cluster (Oracle Clusterware/Grid/ASM) (10tb) 24X7
• Successfully designed and implemented High availability, DR and Business continuity solutions using Oracle RAC, Oracle Data Guard, Oracle Golden Gate and EMC Recover point
• Provided technical direction, guidance and support to all the DBAs in troubleshooting/monitoring/administering the Oracle Database(s).
• Helped improve the claim processing system by 40% by utilizing the Oracle Advanced Queue and Oracle Times Ten database.
• Successfully rolled out BI-DW project (1st Phase) in 2011, this project was designed/developed and deployed in 8 months. (Oracle 11g R2 RAC/OEL/Golden Gate, Oracle PL/SQL).
• Executed the upgrade and migration of Oracle database Production environment from Oracle 9i RAC 5 node cluster (HP-UX, CFS) to Oracle 11gR2 RAC 5 node cluster (Fujitsu, OEL). Implemented Oracle Resource Management to manage the Production resources among all production application.
• Implemented the Data Center Consolidation project (Oracle Data Guard/Oracle Golden Gate).
• Successfully Implemented the Archive environment. Designed, developed and implemented data Synch process to synch the data between Production and Archiving system to offload the production load to Archive environments (Oracle Partitioning, Oracle Golden Gate, Oracle Pl/SQL).
• Designed the Quarterly maintenance process to improve the production system performance.
• Successfully designed/developed/deployed the Fee Negotiation system, which helped company to increase revenue.
• Designed, Developed and implemented Data Masking process for HIPPA compliance.
• Improved the Claim Data Process by utilizing the Oracle Advance Queue to meet the Client SLA.

Confidential

Sr. Oracle DBA

Responsibilities:

• Managed Oracle database DEV/QA/Reporting and Production system. Provided technical support with new innovative technology.
• Designed and deployed the ORACLE RAC to support high availability for our production system in 2003.
• Designed and implemented the Backup and Recovery strategy to support our Business continuity SLA with operation.
• Participated in designing the EMC disk layout to house our production system data along with EMC and sys admins.
• Involved in Installation, Patch installation, Oracle Database upgrade, Performance tuning, Backup Recovery (RMAN). Actively involved in troubleshooting of data issue in production system.
• Involved in design/development of application.
• Worked as PL/SQL developer and Oracle database administrator to design/administer and support the process to load the rating data into S&P's database and clean the data so that this data is available to Rating analyst next day to provide the rating information to their client.
• This process was very crucial for S&P to support their Rating operations (This process is still being used by S&P)