PROFILE:

• Oracle DBA with 17 years of experience in database administration3 years administration E - Business suite, providing 24x7 production support and development support 12c, 11g R2, 10gR2, 9i databases on different platforms with practices for Oracle database infrastructure, standards and implementation.
• Extensive experience in Installations, configuration, cloning, security, patching, upgrades.
• Database backup and recovery using RMAN including duplicating, cloning databases.
• Installation and configuration of Oracle 10g, 11g, 12c using cluster ware and ASM.
• Strong experience in RMAN.
• Experienced in installation and configuration of Oracle primary and standby (Data guard) database and switchover/switchback of database in 10gR2 /11gR2, 12c.
• Experience in multi-node and RAC environments.
• Created development, testing, staging, production, RAC and standby databases enabling load balancing.
• Monitor database backup Jobs and necessary actions for failed backup jobs
• Including script corrections, disk space monitoring and database availability.
• Setup procedure for database statistics gathering - frequency, best time of the day to execute stats gathering jobs. understanding of oracle utilities SQL Trace, ASH, SQL Tuning Advisor Explain Plan, TKPROF, AWR, ADR.
• Creating roles, profiles, privileges and assigning roles to users.
• Extensively worked on monitoring and optimizing the database by performance tuning.
• Hands on experience with various tools like SQL*Loader, TOAD and Oracle Enterprise Manager (OEM).
• Developing shell scripts and SQL scripts to carry out routine checks on databases.
• Implemented proactive monitoring scripts for production databases.
• Troubleshooting for slow performing SQL by enabling database tracing including session
• Specific tracing. performed SQL tuning using Explain Plan.
• Create database trigger, stored procedure and packages PL/SQL coding.
• Knowledge of Oracle Support Process for Technical requests using Oracle Metalink and their support procedures.
• Identifies server hardware, software and configurations necessary for running databases.
• Result oriented, Self-motivated, Team Player, Ability to work independently and can work during weekends and on-call rotations for support and maintenance activities.
• Technical support for client, configuration, install software, install application, update patch, fix problems and troubleshooting.

AREAS OF EXPERTISE:

Oracle Database.

Oracle Cluster ware.

Data guard.

Recover Manager.

Interfacing with other Applications.

Backup Database.

Disaster &Recovery Database.

Clone Database.

Patch Update.

Oracle Installation.

Oracle RAC installation.

E - Business Suite administration.

Golden gate.

Aix / Linux / UNIX.

Windows.

WORK EXPERIENCE:

Oracle Database Administrator

Confidential

Responsibilities:

• Installation and configuration of Oracle 110g, 12c, 19 using Cluster ware and ASM.
• Configuration security, installation database and upgrade database.
• Backup and recovery database using RMAN including duplicating, cloning Databases.
• Installation and configuration of Oracle primary and standby (Data guard).
• Work with multi-node and RAC environments.
• Created development, testing, staging, production, RAC databases enabling load balancing, failover.
• Monitor database backup Jobs and necessary actions for failed backup jobs.
• Monitor database activity, disk space monitoring and database availability.
• Troubleshooting.
• Technical support for client, configuration, install software, install application, update patch, fix problems and troubleshooting.

Oracle Database Administrator

Confidential

Responsibilities:

• Building database structure for any new project.
• Installation and configuration of Oracle 10g, 11g,12c.
• Configure Oracle RAC.
• Troubleshooting for slow performing SQL.
• Creating roles, profiles, privileges and assigning roles to users.
• Work with multi-node and RAC environments.
• Configuration security, installation database and Upgrade database, cloning.
• Understanding of oracle utilities SQL trace, ASH, SQL Tuning Advisor, Explain plan, TKPROF, AWR, ADR.
• Technical support for client, configuration, install software, install application, update patch, fix problems and troubleshooting.

Senior Oracle Database Administrator

Confidential

Responsibilities:

• Installation and configuration of Oracle 10g, 11g, 12c using Cluster ware and ASM.
• Configuration security, installation database and upgrade database.
• Backup and recovery database using RMAN including duplicating, cloning Databases.
• Installation and configuration of Oracle primary and standby (Data guard).
• Work with multi-node and RAC environments.
• Created development, testing, staging, production, RAC databases enabling load balancing, failover.
• Monitor database backup Jobs and necessary actions for failed backup jobs.
• Monitor database activity, disk space monitoring and database availability.
• Understanding on oracle utilities SQL trace, ASH, SQL Tuning Advisor, Explain plan, TKPROF, AWR, ADR.
• Creating roles, profiles, privileges and assigning roles to users.
• Extensively worked on monitoring and optimizing the database by performance tuning.
• Hands on experience with various tools like SQL*Loader, TOAD, Oracle Enterprise Manager (OEM).
• Developing shell scripts and SQL scripts to carry out routine checks on databases.
• Implemented proactive monitoring scripts for production databases.
• Troubleshooting for slow performing SQL by enabling database tracing including session Specific tracing. Performed SQL Tuning using Explain Plan.
• Create database trigger, stored procedure and packages PL/SQL coding.
• Knowledge on Oracle support process for technical requests using Oracle Metalink.
• Make procedures to interface with another applications and databases.
• Technical support for client, configuration, install software, install application, update patch, fix problems and troubleshooting.

Senior Oracle Database Administrator

Confidential

Responsibilities:

• Installation and configuration of Oracle 10g, 11g, 12c using cluster ware and ASM.
• Configuration, cloning, security, installation database and upgrade database.
• Backup and recovery database using RMAN including duplicating, cloning databases.
• Installation and configuration of Oracle primary and Standby (Data guard).
• Work with multi-node and RAC environments.
• Created development, testing, staging, production, RAC databases enabling load Balancing, Failover.
• Monitor database backup Jobs and necessary actions for failed backup jobs.
• Monitor database activity, disk space monitoring and database availability.
• Setup procedure for database statistics gathering - frequency, best time of the day to Execute stats gathering jobs, correct level of gathering statistics.
• Understanding of oracle utilities SQL trace, ASH, SQL Advisor, Explain plan, TKPROF, AWR,ADR.
• Creating roles, profiles, privileges and assigning roles to users.
• Hands-on experience with various tools like SQL*Loader, TOAD, Oracle Enterprise Manager (OEM).
• Developing shell scripts and SQL scripts to carry out routine checks on databases.
• Implemented proactive monitoring scripts for production databases.
• Troubleshooting for slow performing SQL by enabling Database tracing including session Specific tracing. performed SQL tuning using explain plan.
• Database trigger, stored procedure and packages PL/SQL coding.
• Make procedures to interface with other applications and databases.
• Technical support for client, configuration, install software, install application, update patch, fix problems and troubleshooting.