Sr.oracle Dba Resume
3.00/5 (Submit Your Rating)
Columbia, SC
SUMMARY:
- Over 25+ Yrs of total IT experience.
- Expert in Oracle database administration with over 23 Years of experience involving database design, analysis, implementation, performance tuning and administration. (From Oracle6 - Oracle12c).
- Written Shell scripts in Unix/Linux to support DBA related monitoring scripts.
- Over 2 yrs of Experience in Installing and Maintaining Oracle Application Server.
- Used Enterprise Manager Grid control (OEM)/OEMCC 13c to send alert, monitor database Performance etc.
- Expert in set up operational procedures for Production database support24X7 Experience in Maintaining the Large Databases (Multi Tera Bytes) and high volume growth databases.
- Possesses good knowledge of performance Tuning: I/O and Memory tuning, Wait event analysis, Hit ratio Analysis and response time Improvement. SQL tuning using SQL trace and event trace 10046, tkprof,AWR,ASH,ADDM and explain plan. Implemented Successfully Materialized Views, Index Organized Tables, Table and Index Partitions, Parallel Query and Outlines for SQL plan stability. Good knowledge about when and how to rebuild tables and Indexes to Improve Performance. Used extensively the Unix/Linux OS utility vmstat, mpstat, strace, iostat, sar and free while troubleshooting performance Issues.
- Backup and recovery: Used RMAN for database backup. Regularly involved in the restore tests of the backups from Tapes. Used Export, Data pump and Custom Scripting to backup PL/SQL codes.
- Done replication using Materialized Views/logs(8i), Physical standby dataguard and Goldengate. Used SQL*Loader to do bulk loading of data from flat files.
- Maintained 4 nodes Linux RAC Cluster Oracle Database on ASM storage. Have good knowledge about Cluster interconnect Issues and resolutions.
- Proactive support of Production, Standby/DR, QA and development multi-node clusters and databases.
- Administered Oracle Database on AWS and on Oracle Cloud DbaaS.
PROFESSIONAL EXPERIENCE:
Confidential, Columbia, SC
Sr.Oracle DBA
Responsibilities:
- Installed Oracle 12c Database software, Created the Oracle Database to support optimal performance of the MMIS system.
- Implemented Active Data Guard and Fast start failover.
- Implemented RMAN Backup and recovery methodology.
- Tested recovery methodology to make sure the RMAN backups are good and validated the recovery process.
- Created patching process documentation for the regular patching of the Oracle software.
- Used Enterprise Manager Cloud Control 13c to do the Database Administration tasks.
- Worked on Mark Logic Database implementation.
Confidential
Sr. Oracle DBA
Responsibilities:
- Work involve supporting the Oracle Databases. Regular monitoring of the database performance, RMAN backup and general database management task which includes user creation, space management, object creation, manage grants and roles, privilege management etc.
- Other task includes re-fresh different schemas in the development database with the data dumps from the client. Involved in lot of Database Performance Analysis and tuning projects.
- One of the client’s conversion process ETL was running for over 24hrs after analyzing the trace and execution plan created a bitmap index for the column involved in the query and the process finished within seconds.
- Between Jun 2011 and Sep 2011 went to on-site project in US for an ETL performance tuning project.
- It was estimated the ETL process was taking about 56 days to run.
- After tuning the database and changes to the ETL design, I was able to reduce the processing time to less than 6 days.
- The Clients expectation was 14 days. The tuning task involved physical changes to the DB, server, and parameters after analyzing the AWR reports and design changes are suggested to enable scalability to the application.
- Worked in cloud Services Team in the CTS managing the Oracle Databases on AWS and Resolved many Critical Issues which were more challenging.
Confidential
Sr. Oracle Database Administrator
Responsibilities:
- Lead the Oracle10g Upgrade Project. Also did lot of tuning exercise of the clients Production database using Explain plan, sqltrace/tkprof, spotlight and EM Grid Control.
- Taking care of applying all the necessary patches including the quarterly CPU Patches.
- Other tasks includes DEV/QA database refresh, database monitoring (Uptime, correcting errors, performance and tuning). Also setup the heterogeneous connection between Oracle and SQL Server databases.
- Migrated the client’s Oracle10g database from sun Solaris to Oracle Enterprise Linux on the X-86-64 bit architecture successfully and also setup the Data Guard (Physical standby databases).
- There was an Issue with an ETL job which ran every day to populate certain tables from which the daily reports needs to be produced and these reports needs to be available before 8:00 AM to the client. Due to the volume of the data growth this process was started taking more time.
- Analyzed and monitored the job and made changes to the design of the job and by adding relevant indexes and hints enable to bring down the processing time to an acceptable level.
Confidential
Sr. Oracle Database Administrator
Responsibilities:
- As one of 7 members DBA team, I was responsible for the support and optimal operation of Over 50 databases in terms of high availability and response time.
- Involved in upgrade projects from Oracle8i and 9i to 10g.
- Installed and maintain Oracle Application server 10g.
- Involved in the regular Oracle CPU patching exercise over different databases and Oracle application Servers.
- Involved in the Performance Tuning of different databases.
- Worked on Oracle 10g RAC/ASM databases administration.
- Other duties are Oracle Database general management including space management, Backup and recovery Testing, RMAN backups, creating Service request with Oracle Support as and when required and follow-up with them to fix the Issues.
- One of the performance tuning project was a batch job tuning. The batch job which needs to run regularly every day for the normal day to day activity was started taking long time to run (over 4days), this is not acceptable as daily day to day work was affected. Client expectation was 12 hrs. As this application was a 3rd party application and the codes are all wrappers, you can’t see the code or edit the code. So did the trace and monitored the process while it was running. Without touching the code used creation of new indexes, created outlines to change the execution plans and with additional parameter changes I was able to bring down the run time of that batch job to less than 8 hrs.
- In another performance tuning exercise there was an Issue with the Oracle application server batch processing. The process used to take couple of minutes started taking hours to run. Monitored and analyzed the trace and found that the process is waiting on the slave process. So advised to increase the slave process and the process finished in seconds.
- After the 10g upgrade one of the payroll process started running for more than 8 hours and failed after running out of TEMP tablespace. Analyzed the explain plan and adding necessary parameter changes and hints, I was able to bring down the processing time to 15 minutes.
Confidential, Austin, Texas
Oracle Database Administrator (Team Lead)
Responsibilities:
- Involved in the database design, database creation, formulated database security and backup Procedures.
- Worked closely with system administrators in the purchase of hardware. (SunE10K, Sun4500, EMC Disk and BCV, IBM X-86 blade Servers etc).
- Analyzed different database monitoring and performance tuning tools.
- Created and maintained optimally over 50 database instances of high volume (App. 4 TB each).
- Scheduled the automated cron jobs for report Processing, Hot Backups, RMAN backup and Export Backups using Dynamic scripts
- Automated the Index rebuilding using dynamic scripts and analyzed tables on a regular basis.
- Automated the Regular Database Lookup scripts for Storage Utilization and Database performance.
- Involved in Performance and Capacity planning for the high Volume Data growth.
- As the service is 24X7 to the clients, worked diligently in planning and promoting of newer releases to Production Database.
- Worked on Recovery and Restoration of Database in the instances of Hardware failures.
- Used DBA monitoring tools like Spotlight and EM.
- Involved in selection and interview process of candidates for Database Development Team and Database Administration Team.
- Involved in Performance tuning exercise such as sizing of the buffer cache, shared pool, PGA, rollback segments, Temporary tablespace, log buffer, redo log etc. Adjusting the read/write caches of the SAN for each LUNS depending on the application requirement. Used Table and Index partitioning, parallel query and other parallel operations for index rebuilds etc. Balanced the I/O by moving files to different file systems whenever there were Issues.
Confidential, Cedar Rapids, IOWA
Database Administrator
Responsibilities:
- Involved in the maintenance of Database of inbound client specific (Fleet Credit Card) application.
- Performed database activities such as creating database, adding data files, rollback segments, planning storage requirements and maintaining users etc.,
- Performed Database Tuning - Tuning involved, SQL Tuning, SGA tuning, Shared Pool tuning, Tuning SQL/PLSQL areas, Buffers and Disk I/O tuning.
- Tuned the SQL for efficient throughput using EXPLAIN PLAN.
- Y2K test lead for ensuring all applications was Y2K compliant. Environment is VB 5.0, Oracle 7.3.x and HP-UX. The responsibility involves maintenance of Y2K database (Backup / Adding data files / Tablespace creation / Importing database objects from the production database to Y2K database instance.