SUMMARY:

• 10+ years of experience as Oracle DBA (12C, 11G, 10G, 9i, and 8i) on various platforms AIX, HP, SUN Solaris, SUSE Linux, RHEL, Oracle Enterprise Linux and Windows NT (Production, Development and Test environment Proficient)
• Optimized the database performance incidents on RAC databases hosted on the Exadata and non - Exadata platform
• Diagnosed the performance issue with tools TKPROF, 10046 & 10053 trace, Real Time SQL Monitoring, SQL Plan Management (SPM), SQL Tuning Advisor (STA), DBMS MONITOR (), SQL Profile etc.
• Experience in installation and configuration of GoldenGate11g/12c to support data replication in Oracle Database environment.
• Experience in Managing/working/converting oracle Golden Gate databases.
• Experience in installing and configuring Golden Gate 11g/12c.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Experienced in utilizing Golden Gate replication technology for ORACLE Upgrades
• Expertise in using Golden Gate to support data replication in the Oracle database environment.
• Prepared the test cases and conducted the technical talks on Oracle Database 12c features e.g. Histograms, SQL Profile etc
• Took the ownership of the production database issues and resolved successfully
• Interacted with the development and architect teams to gather requirements and provided the solutions
• Documented and shared the troubleshooting methods within the team
• Specialized in Migration of Oracle databases from Oracle 8i, 9i, 10G to 11G.
• Experience working in different/diverse environments such as OLTP, Data warehouse & Hybrid systems
• Strong Troubleshooting skills, understanding of RCA Approach and RAC
• Worked on multiple projects simultaneously, met project deadlines and worked under pressure. Worked independently with little or no supervision.
• Experience in planning & implementation of Backup & Recovery strategy, RMAN. Performance Tuning AWR/ stackpacks for as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, redo mechanisms and sql code.
• Proficient in ORACLE DBA - Installation of Oracle RAC, ASM, SAN and disaster recovery - data guard setup and Streams configuration. Designing & Testing of database, administration, backup & recovery strategy implementation according to the volatility of the data, user management, performance monitoring/tuning and database security
• Supported Oracle Data Warehouse databases, complex queries, de-normalized schemas, Performance related issues related to Data warehouses.
• Experience with the latest Oracle technologies like 10g/11G/12C RAC, CRS, AWR, ADDM, Temporary Table space groups, and Flashback technologies, Data Pump, SQL Tuning Advisor, SQL Access Advisor, Undo Advisor and Segment Advisor.
• Proficient with Tuning, SGA, Buffer Cache, Rollback Segments, and Redo Mechanisms.
• Monitored and Detected Alert Log Files, Listener Log, Redo Log status, trace files and Locks for the database.
• Experience working with SQL Server, T-SQL procedures and queries, SSIS, ETL, CLR C# procedures and functions, etc. Exposure to Basic Architecture of 11i OAS, Installation, Up gradation, Cloning, Patch Application of databases of all versions.
• Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools.
• Experienced in writing, debugging code using SQL, PL/SQL programming skills.
• Strong documentation and reporting skills
• Excellent interpersonal, collaboration, and problem-solving skills
• Process oriented, deft in preparing a technology road map with a clear framework for various processes to be implemented; competent in collaborating & engaging with the clients’ partners, third party advisors & vendor teams to develop appropriate metrics and measurements.

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines - IA

Sr Oracle DBA

• Optimized the database performance incidents on RAC databases hosted on the Exadata and non-Exadata platform.
• Diagnosed the performance issue with tools TKPROF, 10046 & 10053 trace, Real Time SQL Monitoring, SQL Plan Management (SPM), SQL Tuning Advisor (STA), DBMS MONITOR (), SQL Profile etc.
• Prepared the test cases and conducted the technical talks on Oracle Database 12c features e.g. Histograms, SQL Profile etc .
• Took the ownership of the production database issues and resolved successfully.
• Interacted with the development and architect teams to gather requirements and provided the solutions.
• Documented and shared the troubleshooting methods within the team.
• Work with Oracle support to resolve Oracle Support Requests (SR) as necessary.
• Conducted Performance Review of Oracle Database for business-critical applications with Senior Leadership team.
• Generated Stats pack/AWR reports from Oracle 12c/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Completed minimized the space related errors in Oracle Databases by conducting month review with Senior Management and addresses the space issues proactively.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Conducted Load Testing and collated the Test Results and Provided recommendations based on the Test Results.
• Experience in installation and configuration of GoldenGate11g/12c(12.2.0.1) to support data replication (Uni-Directional) in Oracle Database environment.
• Used Golden Gate to move large volumes of data between oracle servers with minimal impact to online systems and performing Golden Gate on process of extract and replication of single instance as well as RAC Databases.
• Upgrade/Migration of Databases from Oracle 11.2.0.4 to 12.1.0.2 via Golden Gate method (as part of ongoing project OCR) and using Oracle Provided API’s on Exadata machines.
• Configuration of Golden Gate DML replication, between one source and one target.
• Setting up and managing Golden Gate from one source to multiple targets, using export data pump utility as an initial load.
• Setup Golden Gate DDL replication between one source and multiple targets. Target schema would have replication from both DML and DDL replicates into different tables.
• Setup Integrated Extracts, replicates and convert them to Coordinated replicates as per need basis.
• Convert existing Integrated and Coordinated replicates to DDL replication from DML.
• Utilized Online redefinition feature of Oracle to make table level changes in Database thereby reduced app downtime and with minimal or no Golden Gate impact.
• Installed Oracle Data guard for Oracle Disaster recovery, High Availability and data protection.
• Implemented Oracle RAC with Data Guard implementation for disaster recovery.
• Work Experience with Latest TOAD 10.2 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Log miner, Segment Advisor, Database Monitor, Server Stat’s, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Implemented range, list partitions and hash partitions.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance
• Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Upgraded Oracle databases from 11gR2 to 12c.
• Involved in designing logical & and physical data models using power designer.
• Implemented Oracle Database 11g four node Real Application Cluster (RAC) on Linux EXADATA systems (Half Rack Node).

Environment: Oracle 10g/11g(RAC)/11G(11.2.0.4/) HP-UNIX (64 bit), Grid Control (OEM), SQLPLUS,VNCserver, Xmanager, Putty.Netsecure,Humming Bird,Dbartisan 8.5,Erwin,Oracle Golden Gate, OID, Schema Manager,Toad 12.0, Toad, PL/SQL.

Confidential - Plano, TX

Sr Oracle DBA

• Experience in installation and configuration of GoldenGate11g/12c (12.2.0.1) to support data replication (Uni-Directional) in Oracle Database environment.
• Used Golden Gate to move large volumes of data between oracle servers with minimal impact to online systems and performing Golden Gate on process of extract and replication of single instance as well as RAC Databases.
• Responsible for installing and configuring Golden Gate 11g/12c on Oracle Servers.
• Responsible for upgrading Golden Gate 11g to Golden Gate 12c(12.1 & 12.2).
• Performed Initial load, extract, pump, replicate trial files and exporting data onto Repository Database using Golden Gate tool.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installing & Configuring Oracle 11g/12c Software and Database, 12c Grid Control, Linux.
• Implemented advanced features of Oracle 11gR2/12c such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Installed and setup 12c Oracle Enterprise Manager Grid Control and Mass Agent Deployment on several hosts.
• Installed Oracle Data guard for Oracle Disaster recovery, High Availability and data protection.
• Implemented Oracle RAC with Data Guard implementation for disaster recovery.
• Work Experience with Latest TOAD 10.2 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Log miner, Segment Advisor, Database Monitor, Server Stat’s, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Implemented range, list partitions and hash partitions.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database.
• Monitored data transfer between the Database servers using Goldengate11g/12c.
• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups.
• Upgraded Oracle databases from 11gR2 to 12c.
• Involved in designing logical & and physical data models using power designer.
• Implemented Oracle Database 11g four node Real Application Cluster (RAC) on Linux EXADATA systems (Half Rack Node).
• Installed and configured Oracle Enterprise Manager 11g Grid Control, Data guard set up for higher availability of Instances.

Environment: Oracle 10g/11g(RAC)/11G(11.2.0.4)/12C(12.1.0.2), HP-UNIX (64 bit), Grid Control 12C (OEM), SQLPLUS,VNCserver, Xmanager, Putty.Netsecure,Humming Bird,Dbartisan 8.5,Erwin,Oracle Golden Gate, OID, Schema Manager,Toad 12.1, Toad, PL/SQL.

Confidential, West Des Moines - IA

Sr Oracle DBA

• Optimized the database performance incidents on RAC databases hosted on the Exadata and non-Exadata platform.
• Diagnosed the performance issue with tools TKPROF, 10046 & 10053 trace, Real Time SQL Monitoring, SQL Plan Management (SPM), SQL Tuning Advisor (STA), DBMS MONITOR (), SQL Profile etc.
• Prepared the test cases and conducted the technical talks on Oracle Database 12c features e.g. Histograms, SQL Profile etc .
• Took the ownership of the production database issues and resolved successfully.
• Interacted with the development and architect teams to gather requirements and provided the solutions.
• Documented and shared the troubleshooting methods within the team.
• Work with Oracle support to resolve Oracle Support Requests (SR) as necessary.
• Conducted Performance Review of Oracle Database for business-critical applications with Senior Leadership team.
• Generated Statspack/AWR reports from Oracle 12c/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database.
• Created a purge script to remove more than one-year old data.
• Scheduled a regular hot backup process and involved the in the backup activities.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Experience in installation and configuration of GoldenGate11g/12c(12.2.0.1) to support data replication (Uni-Directional) in Oracle Database environment.
• Used GoldenGate to move large volumes of data between oracle servers with minimal impact to online systems and performing GoldenGate on process of extract and replication of single instance as well as RAC Databases.
• Responsible for upgrading Golden Gate 11g to Golden Gate 12c(12.1 & 12.2).
• Performed Initial load, extract, pump, replicat trial files and exporting data onto Repository Database using Golden Gate tool.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database.
• Monitored data transfer between the Databases servers using Goldengate11g/12c.
• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups.

Environment: Oracle 10g/11g(RAC)/11G(11.2.0.4/) HP-UNIX (64 bit), Grid Control (OEM), SQLPLUS,VNCserver, Xmanager, Putty.Netsecure,Humming Bird,Dbartisan 8.5,Erwin,Oracle Golden Gate, OID, Schema Manager,Toad 12.0, Toad, PL/SQL.

Confidential, Dallas - TX

Sr Oracle DBA

• Implemented new Oracle 11G R2 (11.2.0.1) database set up for Dev, Test and Prod Instances.
• Architecting and documenting the project details including physical storage, network layout, backup policy, service request, project implementation planning etc.
• Develop and administer configuration management and User profile configuration with access grants.
• Install, Upgrade and manage Oracle Grid Control.
• Designing and building a reporting database.
• Managing, developing scripts and execution of data replication.
• Monitoring DBMS performance and develops procedures, where necessary, to improve the DBMS environment as required.
• Working on Teradata Administrator for creating profiles, roles and enabling the Query logging when required.
• Performance tuning via AWR and Statspack. Fine tune Transaction intensive servers i.e. OLTP situations (I/O bottlenecks, SGA, Pinning objects, Sort space, Redo logs) using explain plan, tkprof and identifying the execution plan and tune queries, using Indexes, hints etc. Exporting dictionary statistics from production to stage for tuning.
• Configure full db backups using RMAN.
• Providing Graphical inputs to Manger on CPU busy and daily peak and no peaks timelines of the Teradata System.
• Designing, developing and maintaining Oracle database structures and data in the support of Human Services initiatives
• Supporting Oracle databases, with experience including requirements definition, data modeling, and logical/physical design.
• Install, upgrade and manage Oracle RAC databases with ASM and SAN.
• Install, patch, upgrade, test and maintain all Oracle software.
• Usage of MS SQL Server, DBMS tools and utilities usage for database administration, cloning, backup and recovery, database performance tuning and monitoring.
• Implementation of Golden Gate TDM for Real time Data Warehousing Live reporting.
• Oracle Migrations without down time using Oracle Goldengate 10g TO 11G Cross platform.
• Exadata migration: Played a vital role in migrating 7 TB Production superdome database (Oracle 10g ) to Exadata Oracle 11g environment.
• Created standardized, pattern-based enterprise service bus solution for inter-system message exchange and monitoring.
• Configuration of Database, User Creation, Role & Profile Assignment in SAP and Non-SAP environment.
• Use OEM, Oracle Advisors for monitoring.
• On boarding Oracle Identity Management (OIM) Tool for Oracle Databases
• Set up SQL loader and Data Pump as required using shell scripts.
• Schedules and coordinates database maintenance activities.
• Verify that database entities follow approved standards and Enforce database standards for objects.
• Approving all production schema changes and control all migrations of Oracle schema objects.
• Assure that Security Policies are in place and Add/Remove new users as requested by data owners.
• Work with Oracle support to resolve Oracle Support Requests (SR) as necessary.
• Provide after hours and on-call support as required.
• Excellent knowledge of Oracle 11g SOA suite.
• Prepare and maintain Documentation using SharePoint and MS Office 2007

Environment: Oracle 10g/11g(RAC)/11G(11.2.0.2/) HP-UNIX (64 bit),AIX (64 BIT), ZLINUX, Grid Control (OEM), SQLPLUS,VNCserver, Xmanager, Putty.Netsecure,Humming Bird,Dbartisan 8.5,Erwin,Oracle Golden Gate, OID,Schema Manager,Toad 9.0, Toad, PL/SQL.

Confidential, NYC - NY

Oracle DBA

• Managing databases large production ranging from 10 to 40 TB. Configuring shell scripts for back up and monitoring alerts.
• Proficient in Installation and Setting up of Oracle 10G and 11G on RAC databases and non RAC- databases.
• Implementation of Oracle Security Standards Audit Checklist.
• Quarterly refresh Activities like rebuilding indexes and tables and resolving Fragmentation issues on Database.
• Extensive experience with database replication technologies (Data Guard/Standby)
• Performed day-to-day activities: Such as, daily error checks and database health, monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• Implementation of Transactional Data management for High Availability (Active-Active)
• Upgrading from Oracle 9i/10g RAC to Oracle 11g RAC Database
• Migration onto heterogeneous environments that is from Windows to Red Hat LINUX and 32 bit to 64bit environment from Red Hat LINUX to SUSE LINUX Itanium 64 bit
• Performing quarterly CPU patching
• Performing Daily checks on SAP systems with TCodes and managing Database with SAP DBA tools.
• Install and Configure Oracle 10G Grid Server and Clients for 600 Instances.
• Extensive usage of Oracle 10g Grid for scheduling backups, alerts and monitoring
• Performance tuning via AWR, Statspack, Tkprof. Fine tune Transaction intensive servers i.e. OLTP situations (I/O bottlenecks, SGA, Pinning objects, Sort space, Redo logs) using explain plan, tkprof and identifying the execution plan and tune queries, using Indexes, hints etc. Exporting dictionary statistics from production to stage for tuning.
• Configure complete / incomplete backups using data pump, rman and hot backups.
• Setup Database Audit for KFS Databases (Key Financial Databases) for SOX-AUDIT and restrict access for external access.
• Managing offshore team and setting up 24X7 monitoring.
• Involved in Oracle database designing using ERWIN tool for development projects.
• Involved in design and development of the project using PL/SQL queries, functions and procedures.
• Proficient in raising tar with Oracle Support and using Metalink/Oracle Support to resolve the bottlenecks in the database environment.
• Signing off on newly created databases for new requirements and the servers migrated from Windows to LINUX and Oracle RAC databases from Red Hat LINUX 32 bit to SUSE LINUX 64 Bit Monitor Performance of database using Grid Control, Creation of standby databases with Data guard Broker. Involve in writing Scripts for the newly signed oracle servers.

Environment : Oracle 11g (RAC)/ 10g (10g RAC)/9i/8i, RHEL 3.0, Zlinux, ImpExp, Grid Control (OEM), Enterprise Manager Console, SQL PLUS, PL/SQL, VNC server, xmanager, Putty.

Confidential, Seattle - WA

Oracle DBA

• Installation, configuration and maintenance of Oracle 10g RAC database.
• Upgraded databases from 9i to 10G
• Created test, production and archive database and its application table spaces. Created admin users and granted the role to the users with high-level security to protect the database from unauthorized access.
• Oracle Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Monitoring the application related jobs and data replication activities.
• Installation and Configuration of SAP application and working on Performance of Application.
• Performed application tuning and performance monitoring.
• Worked as part of a team and provided 24/7 support when required.
• Actively involved in designing, developing and testing the application.
• Creating roles and users and Space management.
• Optimize databases queries and recommend tuning enhancements.
• Performed troubleshooting of the database.
• On-going SQL tuning using Explain Plan and SQL Trace.
• Involved in writing shell Scripts for Backup and recovery methods.
• Database maintaining including backups, cloning restores, imports, exports.
• Management of Tablespaces such as dropping/creation and modification of storage parameters for disk optimization, coalescing tablespaces regularly in case of fragmentation and Analyze the statistics periodically and taking remedial action.
• DR testing for Class1 Databases on Half Yearly Basis
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators in Linux kernel tuning and server configuration.
• Configured hot backup shell scripts for large databases > 3 TB and data pump (expdp/impdp) for selective tables. RMAN backup for specific instances.
• Providing RCA for node evictions and other database issues.
• Use of 3rd party tools like Remedy, DB Artisian, and Toad
• Configuring cronjobs for gather statistics, rebuilding indexes, tablespace alerts
• Performing activities viz explain plan, Tkprof, AWR, statspack (Library Cache, Buffer Cache, wait sessions, Hit Ratios, Pin Ratios, Scattered Reads), Analysis, packages and procedure pining, Index creation, Sql - Hints, Partitioning, statistics gathering, undo management, created snapshots

Environment: Oracle 10g/9i/8i, IBM-AIX,HP-UX,Redhat Linux, Solaris, OEM, SQL, SQL Plus, Toad,Erwin.

Confidential

Software Engineer

• Installation, configuration and upgrading of Oracle server software and related products.
• Applying Critical patch updates for every quarter.
• Cloning the production database from a cold/hot backup.
• Scheduling regular backups for all the production databases.
• Creating primary database objects (tables, views, indexes).
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Assisted in software installation and development environment creation by creating databases and modifying scripts that access them.
• Prepared documentation on software and application installations for training purposes.