We provide IT Staff Augmentation Services!

Lead Oracle Dba Production Support Resume

OBJECTIVE:

I want to carve a niche of my own in the dynamic and growing field of information technology.

SUMMARY:

  • An Oracle DBA with almost 9+ years IT experience in Oracle (11gR2, 10g, 9i) 11g RAC, 10g RAC, installation, upgrade, designing, backup, recovery, migration, performance tuning, streams, data guard etc. spanning various industries like insurance, banking, financial, telecom, pharmaceutical and retail marketing etc. in variety of environments like UNIX, LINUX, Windows NT 4.0/2000/2003 in production, test as well as development databases.
  • Experience in installation, configuration, administration of Oracle 9i, 10g, 11g, 10g RAC, 11g RAC database in Unix/Linux and Windows environments.
  • Expertise working on oracle 10g &11gR2 RAC environment.
  • Installed oracle database server on HP - UX, Solaris, IBM AIX, Red Hat Linux environment.
  • Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
  • Experience in Real Application Cluster environment (RAC) with ASM and OCFS2 file systems.
  • Upgrade Grid Control from 11g to 12c -- Configuration ops plugins, setup monitoring, configure Oracle VM 3.2 -- Tuning and Installation of 6 physical server OVM 3.2 environment. 2 for DEV, 2 for TST and 2 for PRD, server pools, vlan, powerpath.
  • Migrate 11g to 12c Database, Upgrade 11gr2 Rac to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features.
  • Upgrade Weblogic to 12c -- Configure WLS Cluster, deploy Code, Maintain performance and best practices, monitor in Grid 12c.
  • Continuous research in leveraging new features of oracle and bringing them under day to day DBA activities
  • Expertise in scheduling the jobs using Grid control.
  • Expertise in Oracle Golden gate Installation, DB Creation, Replication and Implementation on Single & RAC Databases
  • Expertise in using oracle Export/import, Datapump utility to migrate data across schemas
  • Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases.
  • Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Experienced in using 10g features Data pump, AWR, ASM, ADDM, Grid Monitoring, and Oracle Enterprise Manager.
  • Installation, maintenance and tuning of RAC applications.
  • Experience in implementing, configuring and managing Data Guard with Physical Standby Databases for High availability configuration.
  • Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases
  • Zero Downtime Migration to Oracle Exadata with Oracle GoldenGate.
  • Experience in installation, configuration and administration of Oracle Databases.
  • Implementation of High Availability solutions with Oracle 10g RAC, Physical Standby Databases (Data Guard.
  • Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
  • Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE,11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
  • Experience in applying security patches to the databases
  • Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
  • Experienced in Oracle Support processes for technical requests through Oracle and other Support
  • Procedures
  • Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
  • Installed 11.5.10, including Financials, Purchasing and Public Sector Financials. Upgraded 11.5.9 to 11.5.10.
  • Provide Oracle Apps DBA support for 11i.
  • Demonstrated ability to work well with a wide variety of people at various levels, faster co-operation and
  • Collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and
  • Willingness to communicate when help is needed.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 5.9,5.10,, AIX 5.1, 5.2, RHEL 5.6,5.8 and Windows 95/98/ME/NT/2005/2008XP.

Databases: Oracle 12c/11g/ 10g/9i/8i, Oracle ExaData, Oracle Golden Gate

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

ETL Tools: EM, SQL*Loader, TOAD, Fog light, Spotlight, SQL Loader, Erwin:

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

PROFESSIONAL WORK EXPERIENCE:

Confidential

Lead Oracle DBA Production Support

Responsibilities:

  • Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production
  • Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux.
  • Implemented ASM on RAC. Managing disks and disk groups with ASM.
  • Performed migration activities from 10g to 11g R2 for large databases.
  • Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
  • Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches
  • Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
  • Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
  • Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
  • Monitored and trouble shooted database issues with OEM grid control.
  • Built physical standby using RMAN Active duplication method as well for Disaster recovery site
  • Installing, configuring and maintaining Enterprise Manager Cloud Controlto monitor and manage Exadata and regular databases.
  • Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT).
  • Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata .
  • Performed database recovery using GRP (Guarantee Restore Point) .
  • Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
  • Automated routine DBA tasks like backup’s and stats by using Grid control job’s
  • Provided Assistance to application team at the time of SQL tuning in applications.
  • Upgrade Grid Control from 11g to 12c -- Configuration ops plugins, setup monitoring, configure Oracle VM 3.2 -- Tuning and Installation of 6 physical server OVM 3.2 environment. 2 for DEV, 2 for TST and 2 for PRD, server pools, vlan, powerpath.
  • Migrate 11g to 12c Database, Upgrade 11,2 Rac to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features.
  • Upgrade Weblogic to 12c -- Configure WLS Cluster, deploy Code, Maintain performance and best practices, monitor in Grid 12c.
  • Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
  • Additionally, part of rotation oncall DBA to support databases 24X7
  • Installation, upgrade, security patching, and maintenance of Oracle TimesTen databases.
  • Implementation and/or development of Timesten database management tools (backup/recovery, monitoring, reporting, database/server installation, etc.). Ongoing maintenance of same.
  • Assist with the specifications and requirements for determining hardware requirements to support Timesten databases. Assist with changes to the hardware or O/S on database servers.
  • Assist engineering teams with performance and tuning (database parameters, indexes, and SQL code).
  • Troubleshoot server and database problems to maximize database availability.

Hardware: Linux, HP-UX, Centos, Solaris

Software: PlSql, MySQL

Environment: Oracle 9i/10gR2/11gR2/12c, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control

Confidential

Lead Oracle DBA Production Support

Responsibilities:

  • Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production
  • Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux.
  • Implemented ASM on RAC. Managing disks and disk groups with ASM.
  • Performed migration activities from 10g to 11g R2 for large databases.
  • Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
  • Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches
  • Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
  • Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
  • Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
  • Monitored and trouble shooted database issues with OEM grid control.
  • Built physical standby using RMAN Active duplication method as well for Disaster recovery site
  • Performed database recovery using GRP (Guarantee Restore Point) .
  • Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
  • Automated routine DBA tasks like backup’s and stats by using Grid control job’s
  • Provided Assistance to application team at the time of SQL tuning in applications.
  • Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
  • Installing, configuring and maintaining Enterprise Manager Cloud Controlto monitor and manage Exadata and regular databases.
  • Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT).
  • Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.

Hardware: Linux, HP-UX, Centos, Solaris

Software: PlSql, MySQL

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control

Confidential

Lead Oracle database administrator

Responsibilities:

  • Obtain and Maintain DBMS Software & Patches
  • Oracle Database Up gradation 10g to 11g (10.2.0) to (11.1.0)
  • Decommissioned of Databases.
  • Oracle Client Installation on Solaris10, Linux & HP-UX.
  • Manage ASM on RAC environments.
  • Extending the database storage capacity by creating new table spaces. Adding data files as per requirement.
  • Troubleshoot Error-07445 & Error-4031
  • Modify Static & Dynamic Parameters on RAC environments.
  • Refresh database using exp/imp and Data pump.
  • Remove audit logs older than 30 days.
  • Interacting with Oracle Support for technical assistance requests.
  • Configuring RAC for load balancing with other integrated applications.
  • Create and relocate services in RAC.
  • Managing Physical structure of Oracle database like Data files, Redo log file and Control files.
  • Three Node cluster failover test.
  • Creation of standby database as per requirement and maintenance.

Hardware: Linux, HP-UX, Centos, Windows

Software: PlSql, MySQL

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control

Confidential

Senior Oracle DBA

Responsibilities:

  • Upgradation, migration of databases.
  • Installation, creation of database and RAC.
  • Recovering the database in the event of a hardware or software failure.
  • Testing, and implementation of disaster recovery methodology
  • Ensure production database is in sync with standby database.
  • Creation of standby database as per requirement.
  • Regular monitoring of database and troubleshooting the errors.
  • Determining and implementing the backup/recovery plan for each instance according to project’s needs.
  • Performing Oracle cold backups to ensure consistency of the data.
  • Performing Oracle hot backups while the database is operational.
  • Adding/resizing data files to the table spaces.
  • Performing Oracle import/export as a method of recovering data or individual objects
  • Optimizing Sql statement using explain plan.
  • Taking cpu utilization reports daily
  • MySql to Oracle migration
  • Cloud machine setup.
  • Oracle silent installation on cloud machine.

Hardware: Linux, HP-UX, Centos, Windows

Software: PlSql, MySql

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control

Confidential

Oracle database administrator

Responsibilities:

  • Provide production support for critical payments system of bank.
  • Provide support for various ongoing projects.
  • Designing the infrastructure for new projects and make implementation plan.
  • Determining and implementing the backup/recovery plan for each instance according to project’s needs.
  • Maintenance of different databases on AIX server.
  • Taking backup and restoration of databases with import and export utilities. Or individual objects.
  • Optimizing Sql statement using explain plan.
  • Performing regular maintenance of production db’s.
  • Working with materialized view and managing the snapshot refresh.
  • Implementation of 10g RAC.
  • Tuning Sql statement using Tkprof, explain plan utilities
  • Managing logical, hot and cold backups manually/RMAN
  • Manual/RMAN database cloning to same/different servers.
  • Provide on call support.
  • 15. Installed 11.5.10, including Financials, Purchasing and Public Sector Financials. Upgraded 11.5.9 to 11.5.10.

Hardware: AIX, HP-UNIX, Solaris

Software: Pl/Sql, UNIX shell scripts.

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control

Confidential

Oracle database administrator

Responsibilities:

  • Upgradation, migration of databases.
  • Installation, creation of database and RAC.
  • Recovering the database in the event of a hardware or software failure.
  • Testing, and implementation of disaster recovery methodology
  • Ensure production database is in sync with standby database.
  • Creation of standby database as per requirement.
  • Regular monitoring of database and troubleshooting the errors.
  • Determining and implementing the backup/recovery plan for each instance according to project’s needs.
  • Performing Oracle cold backups to ensure consistency of the data.
  • Performing Oracle hot backups while the database is operational.
  • Adding/resizing datafiles to the tablespaces.
  • Performing Oracle import/export as a method of recovering data or individual objects
  • Optimizing Sql statement using explain plan.
  • Oracle Golden Gate Implementation on Single & RAC Databases.
  • Oracle Golden Gate Implementation & L3 support.
  • Oracle Golden gate Replication for many servers.
  • Implement Oracle Golden gate monitoring for many Databases.
  • Oracle Golden Gate new builds Installation,DB creation on Oracle 9i & 10g.
  • Oracle Golden gate Day to day Oracle DBA activity.
  • Taking cpu utilization reports daily
  • Provide Oracle Apps DBA support for 11i.

Hardware: HP-UX, Solaris

Software: Pl/Sql

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control

Confidential

Database administrator

Responsibilities:

  • Analysis of approach
  • Database design.
  • Installation of Oracle9i/10 on windows, Solaris.
  • Creation of databases in production environment database
  • Adding/resizing datafiles to the tablespaces
  • Created Oracle users
  • Handling export and imports of database objects
  • Taking cpu utilization reports daily
  • Configure Sql net, net8 and Oracle net services
  • Monitoring hot/cold backups and verify their success and return the backup in case of failure.
  • Check database alert log and trace file manually to detect problems
  • Oracle Golden Gate Implementation on Single & RAC Databases.
  • Oracle Golden Gate Implementation & L3 support.
  • Oracle Golden gate Replication for many servers.
  • Implement Oracle Golden gate monitoring for many Databases.
  • Oracle Golden Gate new builds Installation,DB creation on Oracle 9i & 10g.
  • Oracle Golden gate Day to day Oracle DBA activity.
  • Monitoring the billing servers
  • Coding (pl Sql)
  • Testing

Hardware: HP-UX, Solaris, AIX

Software: Pl/Sql, UNIX shell scripts

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control

Confidential

Database administrator

Responsibilities:

  • Team member
  • Analysis of approach
  • Database design.
  • Installation of Oracle9i/10 on windows, Solaris.
  • Creation of databases in production environment database
  • Adding/resizing datafiles to the tablespaces
  • Created Oracle users
  • Handling export and imports of database objects
  • Taking cpu utilization reports daily
  • Configure Sql net, net8 and Oracle net services
  • Monitoring hot/cold backups and verify their success and return the backup in case of failure.
  • Check database alert log and trace file manually to detect problems
  • Oracle Golden Gate Implementation on Single & RAC Databases.
  • Oracle Golden Gate Implementation & L3 support.
  • Oracle Golden gate Replication for many servers.
  • Implement Oracle Golden gate monitoring for many Databases.
  • Oracle Golden Gate new builds Installation,DB creation on Oracle 9i & 10g.
  • Oracle Golden gate Day to day Oracle DBA activity.
  • Monitoring the billing servers
  • Coding (pl Sql)
  • Testing

Hire Now