SUMMARY

• A Professionally qualified Oracle Certified Professional (OCP) having more than 7 years of experience. My main area of expertise is on Oracle Database Administration including Performance Tuning, Application tuning, RAC, Dataguard, Golden Gate and also having hands - on experience on migrating database across different platforms.
• My technological forte is Oracle from versions 8i to 11g and extensively handled the following areas:
• Extensive experience in Installation and configuration of 8i, 9i, 10g, 11g and 12C databases across different platforms (AIX, UNIX, Linux, Sun Solaris and Windows).
• Extensive performance tuning experience, specializing in instance tuning and SQL optimization.
• Extensive experience in database performance tuning, query tuning and application tuning.
• Extensive Experienced in tuning of ERP jobs, time/CPU consuming SQL Queries.
• Expert in Oracle performance tuning. SQL tuning and Real Application Clusters (RAC) specializing in tuning and monitoring for high availability.
• Extensive experience in Application tuning and resolving the performance issues.
• Expertise in using Grid, SQL Trace, Explain Plan, TKPROF tools in resolving the performance issues for application and database instance.
• Extensive experience in handling the large production applications like 5000 parallel users connecting to the application and database instance.
• Extensive experience in perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Extensive working knowledge on Patching the databases (CPU, PSU and bug fix patches) and version upgrades from 9i to 10G, 11G.
• Expertise in planning and designing the database backup (Offline, Online and RMAN backups). Expertise in backup restore and recovery, refresh the production databases, clone and creating the auxiliary databases. Experience in various scenarios of Database Recovery.
• Extensive experience in Configuring Disaster Recovery Site for single instance and RAC databases.
• Extensive working experience in various projects involving various tools of Oracle Database like DGMGRL, OPatch, RMAN, Exp and imp, expdp and impdp, LSNRCTL.
• Strong knowledge in change, Incident and Problem Management Process.
• UNIX shell scripting for automatic deployment, testing of objects in Database instances.
• Excellent communication skills in gathering business requirements from the client and documenting, Technical design documents adhering to Client business data privacy policy.
• Proficiency in understanding client needs and distributing the work among team members.
• Strong Conceptual, Business, Analytical and Communication skills. Highly motivated team player with immense ability to grasp new concepts and work independently as a part of the team.
• Thirst for knowledge and willingness to walk an extra mile for better quality of deliverables.

TECHNICAL SKILLS

Hardware: Sun OS 5.9 & 5.10, HP-UX Itanium & PA-RISC, Linux x86 & Itanium, IBM-AIX

Software Products: Oracle 8i / 9i/10g/11g SQL / PLSQL, Oracle AS 10.1.2, 10.1.3, Oracle Golden Gate

Tools: SQL *Plus, OEM, TOAD, RMAN, Exp / Imp, DGMGRL, GGSCI, SQL Developer

Other Tools: Manage Now, Maximo, BMC Remedy, BJS (Batch Job Server).

PROFESSIONAL EXPERIENCE

Confidential - Austin, TX

Senior Oracle Consultant (Oracle DBA)

Responsibilities:

• Installation and configuration of 8i, 9i, 10g, 11g and 12C databases across different platforms (AIX, UNIX, Linux, Sun Solaris and Windows).
• Developed a performance & tuning system using for oracle, implemented for role-based security, and established SQL*NET version 2.
• Application Performance issues resolved by generating Statspack/AWR reports from Oracle 10g/9i database and analyzed the reports for Oracle wait events, time consuming SQL queries.
• Performed analysis of current optimization model and provided recommendations to move to Oracle’s cost-based optimization. Lead the stress test initiative to evaluate the success of this approach.
• Established and wrote the Performance Tuning guidelines for the Engineering Department to enhance the quality of our product for all current and future code development. This document includes hints for SQL and JDBC performance tuning, application tuning methodologies, determining instance and I/O efficiency, and using tools like STATSPACK, Precise/Indepth and TKPROF.
• 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.Resolve database slow performance issue, query fine tuning and analyze AWR reports and recommend the application team for the best performance.
• Developing the sql scripts and shell scripts for monitoring space, wait events, locks and long operations running on the database on pro-active manner and ensure a healthy database without problems.
• Developing the script for monitoring the alert log for the database performance and resolving the performance issues and ensure the smooth running of the database queries.
• Tuning the SQL statement by analyzing the explain plan and ADDM re-ports. Resolve the query tuning problem for smooth running of the application queries on the database.
• Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Configuring alerts using shell script for critical database issues and scheduling them using crontab.
• Inform the best table structure to the application team and converting normal tables into partitioned tables as on required and resolve the performance issues
• Compressing and shrinking the tables and data files to increase space at tablespace level.
• Successfully designed and developed a backup/recovery strategy and procedures for several Oracle 7 database instances.
• Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.
• Migrating the data from one database to the other using Export and Import Utilities.
• Work with Oracle support by creating Tars for any seeded application/database functionality.

Confidential - Austin, TX

Senior Oracle Consultant (Oracle DBA)

Responsibilities:

• Installed Oracle RAC (database clustering) version 10g and 11g on new servers across the platforms like AIX, Linux, HP UNIX, Sun Solaris and Windows.
• Established and wrote the Performance Tuning guidelines for the Engineering Department to enhance the quality of our product for all current and future code development. This document includes hints for SQL and JDBC performance tuning, application tuning methodologies, determining instance and I/O efficiency, and using tools like STATSPACK, Precise/Indepth and TKPROF.
• Designed and implemented a web based solution in Perl and DBI: DBD for capturing and reporting metrics from STATSPACK, Database Resource Manager, Shared Server Architecture (formerly known as Mutli-Threaded Server), latching and wait event statistics and the efficiency of the Shared Pool.
• Developed and designed several shell scripts to be included in the TrueSource product that provides automated database maintenance, backups, and tuning support.
• Designed and implemented shell script based DBA tool that provides solutions to enterprise database management from a common interface. Some of the current modules include Tablespace Monitor, Change Management, Security Manager, Session Manager, Lock Manager, Utlstat and File IO.
• Established standards for all Oracle database environments based on Oracle’s Optimal Flexible Architecture (OFA). This initiative involved redesigning all new and legacy environments to adhere to these newly established standards.
• Established and wrote the Database Administrators Procedures document for the IT department. This document outlines all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.
• Redesigned a thorough backup and recovery strategy for all major production systems. This initiative involved the design and development of several UNIX shell scripts used for both physical and logical backups. Also included in this effort was the development of various recovery strategies that included media failure, user failure and block corruption.
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts, Oracle Enterprise Manager and Precise/SQL.
• Automize the procedure for quarterly CPU and PSU patches applied on the CRS and Database instances across the environment.
• Upgradation of total environment from version 9i and 10G to 11G
• Recommend the new patches to the business and application team and applying the CPU and one off patch regularly and maintain the database security up to date.
• Installation, Upgradation of Oracle Kernel software (silent, Oracle GUI) using exceed third party software and connecting to the server remotely.
• Modifying the database structure as necessary, from information given by application developers.
• Creating Primary objects like (tables, indexes, etc.) as on application requirement.
• Strategise the best way and create the scripts to Automize the cloning process and restore the production backup to pre-production for load testing purpose
• Resolve the archive log gaps and rebuild the Standby databases when stand by database is not in synch with production.
• Migrate EHMS and CDW database from AIX to Linux Build Physical standby database.
• Develop and draft the project plan in best way for moving 10TB of oracle database from AIX to Linux and upgrade the version rdbms from 10G to 11G.
• Perform the restore test and configure the disaster recovery database.
• Restore test and DR test on normal network and virtual LAN to minimize the downtime when database crashes.
• Configuration of Physical standby database for disaster recovery and configure real time apply option in the stand by database.
• Database Purging, remove the old data without application down time and database performance issues.
• Migration of huge database (10TB) from AIX to Linux
• Converting the Endian format (Data file OS format conversion) using RMAN

Oracle Senior DBA

Responsibilities:

• Installation and configuration of 8i, 9i, 10g, 11g and 12C databases across different platforms (AIX, UNIX, Linux, Sun Solaris and Windows).
• Developing the sql scripts and shell scripts for monitoring space, wait events, locks and long operations running on the database on pro-active manner and ensure a healthy database without problems.
• Developing the script for monitoring the alert log for the database performance and resolving the performance issues and ensure the smooth running of the database queries.
• Generating AWR reports on regular basis to identify the database performance at peak load and create base lines and compare when ever issue found with the database performance.
• Tuning the SQL statement by analyzing the explain plan and ADDM re-ports. Resolve the query tuning problem for smooth running of the application queries on the database.
• Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Creating Primary objects like (tables, indexes, etc.). Controlling and monitoring user access to the database.
• Tuning the SQL statement by analyzing the explain plan and ADDM re-ports.

Confidential - Richmond, VA

Oracle Senior DBA

Responsibilities:

• Performed needed DBA tasks to redesign and tune an Oracle 8i database on a VMS host.
• Managed a small group of developers responsible for researching and recommending solutions for the department’s current and future Oracle Web infrastructure.
• Selected as task leader and programmer for converting from SQL database to Oracle from windows to VAX/VMS and HP UNIX.
• Implemented a secure infrastructure for developing transaction based financial applications in PL/SQL for use within the company’s newly created web based infrastructure.