SUMMARY:

• Eight plus years experience as a Sr. Oracle Database Administrator primarily worked on UNIX/LINUX (Sun Solaris, HP - UX,AIX, RedHat)/Windows environment, both in production and development environments. Has extensive experience with:
• Oracle Database Administration including Analysis, Design, Performance Tuning, Backup and Recovery.
• Performance Tuning and regular maintenance/monitoring of Production Databases.
• Installed and configured of Real Application Clusters (Oracle 11g RAC, 10g RAC), Standby Databases (DataGuard) for High Availability and Disaster Recovery.
• Ugraded databases from Oracle 8i to 9i, 9i to 10g, 10g to 11g
• Capacity Planning, Physical & Logical Modeling. Disaster Recovery & Security Management.
• Experience in using Export, Import, SQL*Loader, OEM Grid Control, SharePlex, Golden gate.
• Migrated databases from Windows to LINUX, HP-UX,AIX to LINUX
• Analyzing, Coding and Implementation of Oracle based applications.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Monitoring and management of various database components (logical & physical) like tablespaces.
• Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.
• Performance Tuning: Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, OEM Grid Monitoring.
• Expertise in maintaining Database Roles, Users using Security Compliance Auditing, expertise in loading data from Flat Files using SQL*LOADER and External Table.
• Good experience in managing Very Large OLTP and Datawarehousing databases.
• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Experience on Backup Methodologies (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Scheduling jobs through Oracle Job Scheduler, cronjobs (Unix) and Schedule Tasks (Windows).
• Experience on Recovering Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures and functions using Oracle tools.
• Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, Linux, HP-UX, IBM AIX, WIN 2000

Languages: C, C++, SQL, PL/SQL, UNIX Shell Scripting,PERL scripting.

Database/Applications/Tools: ORACLE 9i/ 10g RAC/11g RAC,12c RAC, Exadata, Recovery Manager ( Confidential ), TSM, TDP, STATSPACK, AWR,ADDM,ASM,Developer 2000, TOAD, SQL*Loader, TOAD, OEM/GridControl, Erwin, Remedy, Maximo, Golden Gate.

Business Intelligence Tools: Informatica, Cognos

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Oracle Database Administrator III

Responsibilities:

• 24 X 7 Production Oracle database support and administration
• Installed, configured and maintained Oracle Databases.
• Evaluating, Supervise, plan, Installing Database servers, Database software, upgrading to new versions, co-coordinating with hardware changes and applying oracle database patches
• Involved in the implementation of High availability with Real Applications Clusters, Disaster Recovery solutions with Standby Databases (DataGuard).
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM
• Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis Supported the development team at offshore in issue fixing, migrations of code & other support activities.
• Ugraded databases from Oracle 8i to 9i, 9i to 10g, 10g to 11g, 11g to 12c
• Migrated databases to Exadata.
• Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance ( Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager ( Confidential ).
• Resolving Oracle listener and TNS names problems
• Install, configure Oracle GoldenGate for replication, Initial load, direct load, exp/imp.
• Troubleshoot Repcat, Extract, Abend scenarios, data issues with developers and application teams.
• Monitored the growth of the database objects for capacity planning.
• Database Administration and Planning including database design, backup & recovery.
• Developing a backup and recovery strategy and performed backups and recoveries.
• Re-organizing the tables for better response time.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented data replication using materialized views, GoldenGate.
• Capacity planning and bench marking
• Developed PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 12c,11g RAC,10g RAC,9i, Exadata, RedHat Linux, Sun Solaris, HP-UX, IBM Aix, Grid Control, DataPump, Confidential, ASM, TOAD, SQL, PL/SQL, ERWIN, Oracle Golden Gate 11g, 12c, Oracle X2/X3/X4 full rack Exadata machine

Confidential, Bloomington, MN

IT - Oracle DBA (Senior)

Responsibilities:

• 24 X 7 Production Oracle database support and administration
• Installed, configured and maintained Oracle Databases.
• Evaluating, Supervise, plan, Installing Database servers, Database software, upgrading to new versions, co-coordinating with hardware changes and applying oracle database patches
• Involved in the implementation of High availability with Real Applications Clusters (Oracle 11g RAC), Disaster Recovery solutions with Standby Databases (DataGuard).
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM
• Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis Supported the development team at offshore in issue fixing, migrations of code & other support activities.
• Ugraded databases from Oracle 8i to 9i, 9i to 10g, 10g to 11g, 11g to 12c
• Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance ( Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager ( Confidential ).
• Resolving Oracle listener and TNS names problems
• Install, configure Oracle GoldenGate for replication
• Monitored the growth of the database objects for capacity planning.
• Database Administration and Planning including database design, backup & recovery.
• Developing a backup and recovery strategy and performed backups and recoveries.
• Re-organizing the tables for better response time.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented data replication through materialized views, GoldenGate.
• Capacity planning and bench marking
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Developed PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 12c,11g RAC,10g RAC,9i, RedHat Linux, Sun Solaris, HP-UX, IBM Aix, Grid Control, DataPump, Confidential, ASM, TOAD, SQL, PL/SQL, ERWIN, Golden Gate

Confidential, Eagan, MN

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production Oracle database support and administration
• Installed, configured and maintained Oracle Databases.
• Evaluating, Supervise, plan, Installing Database servers, Database software, upgrading to new versions, co-coordinating with hardware changes and applying oracle database patches
• Involved in the implementation of High availability with Real Applications Clusters (Oracle 11g RAC, 10g RAC), Disaster Recovery solutions with Standby Databases (DataGuard).
• Standby Database (Data Guard) setup and configuration.
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM
• Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis
• Supported the development team at offshore in issue fixing, migrations of code & other support activities.
• Ugraded databases from Oracle 8i to 9i, 9i to 10g, 10g to 11g
• Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance ( Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager ( Confidential ).
• Resolving Oracle listener and TNS names problems
• Installed, configured, upgraded Oracle GoldenGate, troubleshooting GG issues
• Monitored the growth of the database objects for capacity planning.
• Database Administration and Planning including database design, backup & recovery.
• Developing a backup and recovery strategy and performed backups and recoveries.
• Re-organizing the tables for better response time.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented data replication through materialized views, GoldenGate.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Loading data from flat files into Oracle Database using SQL*Loader, External Tables and automated the process by using UNIX Shell scripting.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Developed PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 11g RAC,10g RAC,9i, DB2, RedHat Linux, Sun Solaris, HP-UX, IBM Aix, Grid Control, DataPump, Confidential, ASM, TOAD, SQL, PL/SQL, SQL*Loader, ERWIN, Golden Gate