SUMMARY

• Oracle Certified DBA wif extensive experience in Oracle Database Administration, database project management, Engineering infrastructure support, design, implementation, configuration, installation, performance tuning, backup & recovery of Oracle V7.3, V8i, V9i, 10g,11g,12c and 19c on a HP, Sun Solaris Unix, AIX, Linux, Win2K & Windows NT Compaq Server environment.
• Oracle Database Administration supporting OLTP, VLDB, ERP, Ecommerce Web based Applications, Data mart and Data Warehouse ranging from small databases i.e., few GB’s to large databases i.e. terabytes + on a Unix environment.
• Oracle Database Administration supporting ERP Software i.e. SAP - R12, General Ledger, Accounting environment, People soft - FMD, CRM and HRM, MAMIS ERP Software.
• Installation and Implementation of Oracle Golden Gate, Shareplex Replication, Oracle Advanced Replication, Snapshots Replication and Streams Replication.
• Setup, installed, configured, and implemented Oracle Real Application Cluster (RAC) on Linux OS and ASM storage.
• Design, Setup, installed, configured, and implemented 13c OEM INFRASTRUCTURE ON ORACLE RAC wif High Availability and Disaster Recovery wif for database and host monitoring.
• Build, Setup and maintain Oracle Data Guard as solutions for Disaster Recovery.
• Implemented & maintained RMAN i.e., Recovery Manager, SQL Backtrack for Backup & Recovery.
• Ability to lead, manage, plan projects, problem solving, day-to-day operational activities including break/fix, space management, backup and restore and working efficiently wif other team members, developers, project managers and system administrators.
• Ability to handle multiple tasks, investigate/troubleshoot and resolve complex problems.
• Provided 24X7 on-call production and development support to ensure daily production business requirement are met.

PROFESSIONAL EXPERIENCE

Confidential

Senior Systems Engineer - Oracle DBA

Environment: Oracle 19c, 12.1,12.2, 11g, 10g RAC on Linux, OEM 13cR4, RMAN, ASM, Data Guard, Oracle Streams

Responsibilities:

• Design, Setup, maintain, configure, and build Oracle 19c, 12c, 11g on RAC database clusters on RedHat Linux.
• Design, Build, Maintain Database Monitoring and Alerting - OEM 13c Infrastructure for High Availability wifin Datacenters and Disaster Recovery across Datacenters.
• Build, Setup and maintain Oracle Data Guard and SRDF storage replication for disaster recovery.
• Build, Setup and maintain Golden Gate Replication Setup for trading databases as per the business requirements of the applications.
• Standards developed and documented to govern the patch and vulnerability management processes for Database infrastructure assets.
• Continuously Improve Enterprise Database Reports to improve Systems stability and reduce incidents and outages to improve High Availability of our Database Infrastructure.
• Lead Oracle Upgrades and Oracle RU patches wif our offshore teams.
• Troubleshoot and resolve production issues and investigate the root cause.
• Work wif Application Group/Developers on SQL/Database Performance tuning.
• Work wif offshore DBA team to assist in troubleshooting and automate standard tasks.
• Setup and maintain Oracle RMAN backups and perform recoveries when needed.
• Work wif Project managers for new upcoming database projects.
• Plan, schedule and Implement database changes using change management.
• Work off-business hours/weekend to implement infrastructure/production changes

Confidential

Lead Oracle DBA

Environment: Oracle 11g(11.1.0.7),10g(10.2.0.4) RAC on Linux, Oracle 9i, 10g DB, EM Oracle 10RG5 Grid Control, RMAN, ASM, Data Guard, Oracle Streams, Sybase.

Responsibilities:

• Setup, maintain, configure and build Oracle 11G, 10G RAC database servers on Linux.
• Build, troubleshoot and maintain Oracle Grid Control Infrastructure.
• Build, Setup and maintain Oracle Data Guard for disaster recovery.
• Participate in DR testing using flashback technology and opening the DR in Read/Write mode for Application testing.
• Lead Oracle Upgrades and Oracle PSU patches.
• Install and maintain Oracle IPD/OS and OS watcher on RAC cluster nodes.
• Troubleshoot and resolve production issues and investigate the root cause.
• Work wif Application Group/Developers on SQL/Database Performance tuning.
• Work wif offshore DBA team to assist in troubleshooting and assign standard tasks.

Confidential

Lead Oracle DBA

Environment: Sun Solaris, Red Hat Linux, VERITAS Cluster, Oracle 10g RAC, Oracle 9i, 10g, 11g, EM Oracle 10g Grid Control, RMAN, ASM, EM Job Scheduler, AUTOSYS, People soft FDM, CRM and HRM, MSSQL Server.

Responsibilities:

• Responsibilities include database Project Management, lead and implement Infrastructures Projects like Oracle Upgrades/Patches, Oracle 10G Grid Control Setup on RAC, Oracle RAC Setup for new/existing applications, ASM, Disaster Recovery, Oracle Physical Standby databases.
• Install, create and maintain Oracle RDBMS databases, software and tools for development, testing and production environments.
• Setup, build, configure and maintain 10.2.0.4 ORACLE RAC Database Servers on Linux.
• Support People soft databases for FDM, CRM and HRM.
• Lead Oracle Upgrades and Migrate existing databases from Sun Solaris to Oracle RAC on Linux.
• Responsible for Database decommission, database move to new server due to end of life of existing server.
• Monitor and analyze database performance indicators, resolve problems and recommends improvement actions.
• Participate in planning high availability and disaster recovery solutions to mitigate risks and increase application uptime.
• Monitoring, managing and modifying existing database infrastructure for improvement.
• Setup, configure, manage and troubleshoot Oracle 10g Grid Control on RAC Infrastructure. (Oracle Application Server OMS, OEM Repository database on RAC and the target Management Agents.)
• Identify and upgrade Oracle database version to supported and certified versions.
• Participate in planning and testing Disaster Recovery and VERITAS cluster fail-over tests.

Confidential

Sr. Oracle DBA

Environment: HP-UX 10.20.11.0 , Sun Solaris, AIX, Oracle RAC, Oracle Data Guard, Linux 3.0,4.0, Wind 2K, Windows NT 4.0, ORACLE 8.05, 8.1.7.2, 9.2, 10g, SAP R/3, MSSQL.

Responsibilities:

• Responsible to build, maintain Oracle databases across multiple HP-UX, Sun Solaris and Linux platform. Oracle installations, upgrades/patches, cloning, configuration, performance tuning, back-up and recovery, capacity planning, patching and administration of Oracle OLTP and data warehouse databases including SAP on Sun Solaris, HP-UX and Linux environments.
• Support day to day administration, support, and monitoring of Oracle databases in a SAP environment.
• Setup and lead Oracle Data Guard Project, Streams replication and Oracle Real Application Cluster (RAC) as solutions for Maximum Availability and Disaster Recovery on Production environments.
• Providing support of a very large SAP - Oracle data warehouse (> 1 terabytes), from a database administration point of view in a production and development environments.
• Identify and upgrade Oracle database versions to supported versions.
• Patch Oracle databases to comply wif Security alerts.

Confidential

Environment: Sun Solaris 2.6,2.8, Sun Cluster 2.2, Veritas Volume Manager 3.1 Veritas File System 3.3.2, Veritas Net Backup 3.4, ORACLE 7.3, 8.0.4, 8.1.6, 9x.

Responsibilities:

• Worked in ITS infrastructure support department and was assigned to ITS data center Relocation project was primarily involved in performing following tasks.
• Provided ITS application relocation strategy and methodology of database system migration as the member of project team.
• New data center infrastructure analysis, which mainly involved UNIX enterprise high availability servers and Oracle HA configurations.
• Database application installation, testing, migration and cut over on ITS development, system testing, and UAT, DR and Production environments.
• Setup Hot Standby Databases and Oracle Advanced Replication as solutions for Disaster Recovery on Production environments.
• Implemented Managed Recovery for Hot Standby Oracle 8i. Database.
• Planned and developed UNIX cron shell scripts to ship the archive logs from primary to target database and automated other database management and monitoring activities.
• Configured and performed Sun Cluster test for UAT and Production Environment.
• Installation and Configuration of Oracle 8.0.4 and 8.1.6 Software on Sun Solaris for Development and System Test, UAT, DR and Production Environments.
• Experience refreshing & cloning data between instances for User and development testing.
• Provided 24X7 Production Support on all ITS database infrastructures.

Confidential

Systems/Database Administrator

Environment: HP-UX 9.0, ORACLE 7.1, 7.3, ERP MAMIS/SAP

Responsibilities:

• Installation, Configuration & Maintenance of Oracle 7x for dvlp, testing and Production Environment.
• Involved in the creation and support of a development, testing and Production environment, security management and technical support.
• Setup and maintain databases and were responsible for remote database administration of the production plants and warehouse system environment.
• Tuning and monitoring of databases and servers to insure optimum performance.
• Setting up Backup and Recovery scripts and procedures.
• ERP implementation in manufacturing area.