AREAS OF XPERTISE

• Meticulous observation, and analysis
• Bridge and communicate within and between teams
• Oracle DBA, 11g and 12c RAC and Non - RAC database installation, patching, Cloning, Upgrades, Production Support and Administration.
• Oracle E-business Application Suite 11i and Release 12 Application DBA, Patching, online patching, Hot patching, administration, Cloning, EBS 11i to R12 upgrade, Performance Tuning, Weblogic Administration.
• RMAN Backup and Recovery.
• 11i, 12c Grid Control and 13c Cloud Control Configuration, Monitoring and Administration.
• Data Guard installation and Administration.
• Oracle 11g/12c software installations, migrations, database capacity planning, automated backup implementation, performance tuning on Linux/Unix and AIX Platforms.
• ASM disk creation and configuration.
• Knowledge in Oracle Cloud, Oracle Golden gate and Python Programming.
• Follow best practices.
• Mentor Junior DBAs, Lead Team Members.
• Earlier: Developer / Programmer using Java, C++, C.

PROFESSIONAL EXPERIENCE

Confidential

EBS DBA Platform ownership and management

Responsibilities:

• Take ownership of EBS/ERP Platform and help governance, co-ordination with various DBA teams, Application Teams and IT teams to manage Oracle 12.1.0.2 RDBMS 10 Node RAC and 10 Node Application Servers with EBS R12.2.5 Applications that has 97 TB Database on RHEL 7.6 OS with Mirroring, Goldengate Replication, DataGuard

Confidential

EBS and Oracle DBA

Responsibilities:

• ODM Migration planning support from AIX to Linux Servers
• Configure Backups from Cloud Control 13c
• Support for Oracle EBS R12.2 Application on Linux
• Production Support for Oracle EBS R12.1.3 Application on Linux and 11GR2 / R12 Database on AIX
• Install and Configure 11gR2 and 12c Data Guard
• Configure Grid control 12c and monitor Oracle EBS APPS and DBs using Grid control
• Production Support for Oracle OBIEE Databases on AIX
• Linux (RHEL and OEL) and AIX Administration with respect to Databases
• Upgraded Oracle DB from 11.2.0.2 to 11.2.0.4
• Upgraded Oracle DB from 11.2.0.4 to 12.1.0.2
• Upgrade Vertex 6 to Vertex 8
• Vertex Monthly updates and Patching
• Upgrade Oracle EBS 12.1.1 to 12.1.3
• Team lead and Co-ordinate off-shore DBAs for 24X7 Support, Migration, Patching and other DBA Tasks
• Audit Tasks
• Linux support, Printer Support for Oracle, other Administrative support
• Co-ordination with Development and Network support Team and Management
• EBS and Oracle Database CPU Patching, Performance Improvements
• Migrations through CVS
• Weblogic Administration (Basics)
• Automic support (Basics)

Confidential

EBS and Oracle DBA

Responsibilities:

• Monitor Production and Non-Production EBS R12.1.3 Application and 11.1.0.7 Databases on Oracle Enterprise Linux.
• Identify Performance intensive SQL Query and operations and suggest solution
• Storage and Capacity planning
• Work with Oracle support and Oracle On-Demand in Administrating the Databases and Applications
• Work in progress on Migrating Peoplesoft Databases from MS Windows to Linux Operating System
• Move Oracle EBS R12.1.3 and Database 11GR1 from Oracle On-Demand Servers to Bic’s In-house Servers.

Confidential

EBS and Oracle DBA

Responsibilities:

• Upgraded 11.5.10.2 EBS Application to EBS R12 (R12.1.3) on Linux (OEL 5.6 and 6.1)
• Manage EBS 11i and R12 Application on RAC
• Administer Oracle 11gR2, 4 Node RAC Production Database and Oracle EBS 11.5.10.2 on Oracle Enterprise OEL Linux 5.6 with EBS 11.5.10.2 Application.
• Administer RAC and non-RAC Test Instances on Oracle Enterprise OEL Linux 5.6.
• Clone RAC to RAC and RAC to non-RAC Database using active database RMAN duplication and cloned EBS Application.
• Installed and configured Cloud Control 12c and Agents to monitor several Oracle Instances.
• Installed and configured Grid Control 11gR1 and Agents to monitor several Oracle Instances.
• Cloned 11.2.0.2 Grid Infrastructure to create a new RAC.
• Upgraded (out-of-place) Oracle Grid Infrastructure and Oracle Database from 11.2.0.2.2 to 11.2.0.3.2
• Installed Oracle Unbreakable Linux 5.6 on 7 servers, Installed 11.2.0.2 Grid Infra Structure and 11.2.0.2 RDBMS SW on 4 Node RAC, Upgraded Oracle Database 10.2.0.4 from another Production Servers to the new Servers to Oracle 11.2.0.2. Configured 3 node EBS Middle Tier with PCP.
• Cloned Single Node Database with 10gR2 and EBS 11.5.10.2 to 2 Node RAC with 11gR2 and EBS 11.5.10.2.
• Installed, configured and administer Physical Data Guard with MAX Performance (default) mode on 10.2.0.4 Single node Oracle Database.
• Installed, configured and administer Physical Data Guard with MAX Performance (default) mode on 11.2.0.2 RAC Primary with EBS and Single Node Secondary/Standby.
• Recovered Database from block corruption
• Mentor and lead a junior DBA that works offshore

Confidential

Oracle Production DBA / EBS DBA

Responsibilities:

• Administer and Maintain 2 node RAC Production E-Business Suite 11.5.10.2 Application and 10gR2 (10.2.0.4) Database, Data Guards and other Development, UAT and Test Instances on Linux OS.
• Administer and Maintain a Production, 11gR2 ImageDB databases that work with the EBS application and its Test Instances
• Administer and Maintain a Production Database for OBIEE and its Test Instances
• Configured nodes to be monitored from Grid Control
• Configured Data Guard Broker

Confidential

Oracle Production DBA

Responsibilities:

• Maintaining 2 Large Production Databases (Terabyte Database): One with 6 Node, 10gR2 (10.2.0.4), RAC on Solaris for ATT (Cingular Mobile), and the other one with 4 Node, 10gR2 (10.2.0.4), RAC on Solaris OS Platform for Belk
• Maintaining a 4 Node RAC Data Guard for the Production Database
• Maintaining 2 Medium size Production Single Node 10gR2 Databases on Solaris OS Platform
• Maintaining 12 QA and test Databases on Solaris, RHEL (Linux 5) and AIX OS Platforms
• Installed 2 node 10gR2 (10.2.0.4) RAC on RHEL (Linux 5) OS Platform
• Created a 10gR2 Physical Standby Data Guard instance using RMAN backup.
• Export and Import Schemas and Full Database using Datapump
• Configured Netbackup client for RMAN - Netbackup, backup and recovery for RHEL 5 Linux on a 2 node RAC 10gR2 (10.2.0.4) Database
• Installed 2 node 11gR2 RAC (Grid Infrastructure, ASM, Database) on RHEL5 (Linux) Platform

Oracle EBS Application DBA / DBA

Confidential

Responsibilities:

• Maintained R12.0.6 Ebusiness Suite with Financials Module as the major functional application in HP-UX platform, version B.11.23 as an Application DBA and DBA for Production and 3 Test and QA instances.
• Day to day monitoring of Database using 10gR2 Database control and OEM Grid Control, monitoring of EBS Application using OAM, apply patches using adpatch, change configuration using context file and autoconfig, compile EBS objects using adadmin, clone database and EBS using RMAN, adpreclone and adcfgclone, help identify performance problems and help fix them, Monitor RMAN backup and check the usefulness of the backups.