SUMMARY

• Oracle certified associate with 9 years of experience as Oracle database administrator. Led million dollars’ worth of engagement for clients primarily across Pharmaceuticals, Retail pharmacies and Tele - communication industry. Managed offshore team of 10+ members and acted as day-to-day client liaison for all queries and escalations.
• Coordinating onsite and offshore DBA team with Client.
• Managing Oracle database administration function involving:
• Installation, configuration, upgradation and patching of Oracle server software and hardware.
• Disk space management, user profile creation and user rights management.
• Creation & administration of all database objects, including tables, indexes, views, sequences, packages, procedures.
• Database / SQL tuning, performance monitoring and troubleshooting.
• Resolution of database startup problems and database reorganization.
• Database Tuning using AWR, ASH and ADDM utility.
• Problem Analysis and Troubleshooting.
• Implementation of backups (hot & cold back-ups) using User Managed & RMAN method along with recovery, monitoring procedures and ongoing support.
• Configuring Oracle RAC systems
• Golden Gate implementation/data replication between two data center.
• Veridata implementation to check both data consistency.
• HPSM for emergency request like Hot fix, backup database access, production deployments.

TECHNICAL SKILLS

Operating Systems: HPUX, IBM AIX & Windows 2000/2003/2008/2012/ XP, Linux

RDBMS: Oracle Database administrations 9i, 10g, 11g,12c

Languages: SQL, PL/SQL,UNIX Shell scripting etc.

Tools: RMAN,TOAD,SQL *Loader, Exp/Imp, Expdbp/Impdp, BRTOOLS SAP,OEM etc.

Tuning Tools: TKPROF,EXPLAIN PLAN, AWR, Tuning Advisor etc.

Ticketing & Tracking Tools: Team Track, HPSM

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Creation & administration of all database objects, including tables, indexes, views, sequences, packages, procedures.
• Checking fragmentations on tables and re-organize them using Exp/Imp, Expdp/Impdp, BR Tool (SAP server).
• Backup and Recovery Physical (Hot& Cold Backups) and Logical (Export/Import).
• Backup Consistency checks on storage nodes to confirm successful backups. Installation, Migration, Troubleshooting and Administration of Oracle 12c/11g/10g DB’s.
• Adding and resizing database files.
• Creation of schemas, Tablespace and importing data dumps.
• Analyzing tables and gathering their statistics.
• Monitoring scheduled processes like stale stats, retention policy, archive destination, enable/disable triggers configured in database and database maintenance scripts.
• Monitoring Database growth, Tablespace growth, available space for growth, OS mount points, audit trails and alert logs.
• During DR monitor database health check, ensure all monitoring scripts are running and crontab scripts are uncommented.
• Performing daily administrative and performance tuning tasks like monitoring the Diagnostic files, Background Trace files and Users Trace files.
• Created new Databases (RAC) with ASM file system.

Confidential

Oracle DBA

Responsibilities:

• Installation, configuration, upgradation and patching of Oracle server software and hardware.
• Disk space management, user profile creation and user rights management.
• Creation & administration of all database objects, including tables, indexes, views, sequences, packages, procedures.
• Database / SQL tuning, performance monitoring and troubleshooting.
• Writing Pl/sql blocks, Procedures, functions, triggers.
• Generated AWR/ADDM reports from Oracle 11g/10g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth
• 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
• Monitoring data Extraction /replication between two active side using Golden Gate.
• Setup Golden gate extracts and replicates between active-active databases for data replication
• Worked on Golden gate transformation rules for CDR’s and error handling
• Comparison of data between two active-active sites through Oracle Veridata.
• Follow up with oracle team for oracle SR.
• During DR monitor database health check, ensure all monitoring scripts are running and crontab scripts are uncommented.
• Performing daily administrative and performance tuning tasks like monitoring the Diagnostic files, Background Trace files and Users Trace files.
• Perform Backup activities of DB using RMAN as per the defined policy and Restoration of the same as and when required.
• Allocating logical volumes to the tablespaces as per the requirement and keeping track of the same.
• Created new Databases (RAC) with ASM file system.
• Cloned a database from backup of other database.
• Upgrade database by applying Application Patches for different application builds.
• Have ensured process enhancement of overall project by creating and designing a couple of automation scripts to enhance the productivity of the team and Environment.
• Performed Diagnosis & Tuned database and SQL statements as and when required.
• HPSM for emergency request like Hot fix, backup database access, production deployments.

Confidential

Oracle DBA

Responsibilities:

• Installation, configuration, upgradation and patching of Oracle server software and hardware.
• Disk space management, user profile creation and user rights management.
• Creation & administration of all database objects, including tables, indexes, views, sequences, packages, procedures.
• Checking fragmentations on tables and re-organize them using Exp/Imp, Expdp/Impdp, BR Tool (SAP server).
• Backup and Recovery Physical (Hot& Cold Backups) and Logical (Export/Import).
• Backup Consistency checks on storage nodes to confirm successful backups. Installation, Migration, Troubleshooting and Administration of Oracle 10g/9i DB’s.
• Adding and resizing database files.
• Creation of schemas, Tablespace and importing data dumps.
• Analyzing tables and gathering their statistics.
• Monitoring scheduled processes like stale stats, retention policy, archive destination, enable/disable triggers configured in database and database maintenance scripts.
• Monitoring Database growth, Tablespace growth, available space for growth, OS mount points, audit trails and alert logs.
• Handling performance issues like Blocking sessions, long running sessions, processes, wait sessions, wait events, top CPU Consuming sessions and locks.
• Refreshing the Dev. and Test database using Exp/Imp and Expdp/Impdp.