Senior Oracle DBA Resume

SUMMARY

Oracle DBA for Oracle 7/8/9i/10g/11g/12c/18c/19c with RAC on Solaris and Linux
Oracle E - Business Suite 11i/R12 Application DBA with Oracle Single sign on (SSO)
Amazon AWS EC2/RDS cloud migration with Aurora, PostgreSQL, MySQL, MariaDB, Oracle, SQL Server, DynamoDB, Redshift
Migration EBS R12(12.2.6) and OBIEE 12C Application and Oracle Database (11g/12C) from on premise to Oracle Cloud Infrastructure (OCI)
SQL Server DBA for 2000/2004/2006/2012/2014/2016 and MySQL Certified DBA

TECHNICAL SKILLS

Oracle RAC, Stream, Golden Gate, Data Guard, Oracle Discoverer, B2B, BPEL, APEX, SOA, OBIEE, ODI, OBIA, OID, OUD,OAM, OEM, IPM/ODC, Data Warehouse
PL/SQL,NoSQL, R, Python,C++,Java Scripts, ASM, Toad
Backup and Recovery Manger (RMAN), SQL Developer, Unix/Linux/windows shell scripting and automation, PowerShell

PROFESSIONAL EXPERIENCE

Senior Oracle DBA

Confidential

Responsibilities:

Migrated on premise EBS R12(12.2.6) Application and database, OBIEE 12C Application and OBIEE/ODI to Oracle Cloud Infrastructure (OCI)
Migrated 3 Oracle databases (11g and 12C) from on premise to Amazon AWS cloud
Migrated USP EDW Oracle data warehouse from on premise to McKinsey’s Nerve Cloud for the COVID-19 Drug Shortage Supply Chain project
Upgraded Oracle EBS 11i/R12 application (11.5.10.2) to R12(12.1.3), R12(12.1.3) to R12(12.2.6) and Databases from 10g to 11g, from 11g to 12c
Upgraded 40 Oracle databases from 10g/11g/12C to 12C/18C/19C
Upgraded SQL Server cluster from 2012 to 2016
Upgraded OBIEE/ODI application and database from 11g to 12C

Senior Database Administrator

Confidential

Responsibilities:

EBS Apps DBA for Oracle E-Business Suite 11i/R12 (11.5.10,11.5.10.2 and 12.1.0) with 3 Oracle RAC database nodes, 5 middle tier nodes and 4 DMZ nodes.
Oracle RAC 9i on Solaris 9/10 and Oracle RAC 10g/11g Installation, patching, upgrading and configuration on Solaris, and Linux
Cloned and refreshed EBS 11i/R12 Dev, Test, Account, Training, Project and Convert systems from Production
Applied CPU patches for EBS 11i/R12 and Oracle Databases.
Performed RMAN and NetApp Snapshot backup
Scripting daily cron job for monitoring database and application activity and log and storage usage
Oracle Production DBA for 30 Oracle databases and Installed, upgraded, migrated from version 7,8,9i,10g,11g running on Solaris, Linux and windows
Performed cold and hot backup and test recovery using RMAN and NetApp Filer Storage Snapshots
Installed and upgraded 9i/10g/11g OEM Grid Control/Cloud Control
Built DBAMENU to automatically start/stop middle services when start/stop the related databases
Oracle Data warehouse CORPBI using Oracle Stream and Golden Gate and Informatica
Installed Oracle database 11g and Kintana Middle Tier application for Project and Portfolio Management System for Changing Control and Patching.
Integrated Oracle EBS 11i/R12 with Oracle Imaging and Process Management (IPM), Oracle Document Capture (ODC) for iExpense
Installed and Integrated Oracle EBS 11i/R12 with B2B/BPEL/BAM using SOA11g and WebLogic 11g
Installed Oracle WebCenter 11g, used for AP invoice Scanning

Senior Database Administrator

Confidential

Responsibilities:

EBS 11i MAXFINP maintaining, patching, monitoring and RMAN backup and no-production cloning.
Oracle Production DBA for AIMS and VISAER Database for Aviation Management and Airline Maintenance and Engineering System on Red Hat Linux ES and Oracle10g.
Oracle Development DBA for 8 Databases: RPTDB, No-Fly, Purser, Aircraft Forecast, CAMP, DMI, Flight Attendants Trip Report, Dining and Cabin Services
Automation data from Call Center to RPTDB database
Created Shell Scripts and set up scheduled task to import Confidential employee information from Microsoft Active Directory into the MAX-No-Fly Oracle database
PL/SQL procedures to check security clearance of Confidential Employees against the No Fly List, Selectee List and Cleared List
Oracle Application Express (Apex) 3.0 for Security Department to record, track the training records and print Certifications
Built Oracle Forms to record and track the orders and inventories
Built Oracle Reports by using Crystal Reports to print weekly, monthly and annually report
Administrated and maintained MS SQL server 2000/2005 for a customer service ticket