OBJECTIVE

• Seeking for a position as Senior Oracle Database Administrator in a fast - paced environment where my technical work experience, skills and educational background could be put to optimal use in a diverse environment supporting Oracle Database technologies in supporting business needs.

SUMMARY

• Oracle Database 11g Administrator Certified Professional (11g OCP), Oracle Database 10g Administrator Certified Professional (10g OCP), and ITIL Foundation Certified (IT Service Management).
• Over12 yearsdirectexperience in administration of Oracle databases 19c/18c12c/11g/10g/9i/8i/8.0 and Oracle E-Business Suite R12.2/R12.1/11i.
• Installed & configured 19c/18c/12c/11g/10g/9i/8i/8.0 databases, FMW,11gAS/10gAS/9iAS, Oracle E-Business Suite R 12.2/12.1/11 i, 13c/12c/11g/10g Grid Control OEM
• Frequent cloning of Database(RAC) and EBS application R12.2/R12.1/11i
• Configured OAM/SSO and integrate with R12.2, Configured SSL for EBS 12.2/11i
• Supported and resolved issues for Oracle Financial modules GL, AP, INV, PO and SYSADMIN modules for Application R12.2 and R11i
• Upgraded database from 10g to 11g to 12c, 32bit to 64bit conversion, merging APPL TOP, Split configuration for 11i and R12 upgrade from 11i
• Installed and Administration of 12.1, 11gR2 RAC/ASM over 1TB production database on oracle clusterware
• Upgraded Oracle E-Business Suite from 12.1 to 12.2.3 and from 12.2.3 to 12.2.5
• Lead project of migration from 12.2.4 (AIX) to 12.2.5 on RHEL Linux
• Expertise in Maintenance, OPatch/ADPATCH/ADOP Patching utilities, Built R12.2 on RAC databases with shared file system, configured TLS, SSO/OAM, Load Balancing.
• Very strong in AutoPatch, Upgrade, Adadmin, Autoconfig, Adctrl, Adsplice, Adrelink, AdMergePatch, Adpatch, ADOP, License Manager, Cloning and Oracle E-Business Suite Manager
• Configured Oracle EBS integrated soa gateway for SOAP services on 12.2.5.
• Planned & implemented the migration projects, DRS, backup and recovery strategies.
• Proficient in various tools, such as Log Miner, ERWIN, OEM, Server Manager, Network Manager, SQL*Loader, Forms, Reports, DBCA, DBUA,Toad, Import/Exports, Netback up
• Provided 24 X 7 user support and troubleshoot the application and database issues.
• Upgraded Oracle Database (19c/18c/12c/11g/10g/9i/8i/8.0) from one version to another, from one platform to another platform, from singe instance to RAC and cross O/S platform and cross Endian platform.
• Implemented and Administered Data Guard / Standby Database/RAC 10g/11g/12c
• Keen problem-solving, troubleshooting and communication skills
• Designed and developed many PL/SQL stored procedures, functions, and triggers
• Performed multiple Oracle Database upgrades in SAP R/3 ERP environments
• Over 8 years of experience with performance analysis and tuning (using AWR and ADDM), database partitioning and reorganization, patching and upgrading.
• Implemented/supported Oracle E-Business Suite 11i (11.5.10.2) thru R12 (12.2.5) Technology Stack, System Administration, Cloning, Patching, Workflow, ADI, Discoverer and functional Applications modules: GL, AP, FA, INV and PO.
• Excellent analytical, problem solving, written and oral communication skills

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle Apps DBA

Responsibilities:

• Supported multi-terabytes production databases and database applications in a 24*7 environment
• Supported Oracle E-Business Suite R12 (12.1.3 & 12.2.5) Technology Stack
• Upgraded Oracle E-Business Suite from 12.1 to 12.2.3 and from 12.2.3 to 12.2.5
• Frequent Rapid cloning of Oracle E-Business Suite 12.2.5 for SBX/UAT/DEV/QA during upgrade of 12.2.3 to 12.2.5
• Performed online patching (ADOP) on Oracle E-Business Suite 12.2.5
• Database performance tuning for R12.2 Financial and 11i applications
• Installed, patched and upgraded of Oracle core technology products; Oracle database (both Standard/Enterprise editions 11g/12c/18c/19c), Fusion Middleware 11g and security management
• Performed multiple upgrades of Oracle databases from 10g/11g to 12c & 12c to 18c/19c.
• Supported Oracle databases in Oracle Exadata Database Machine X4-2, X6-2
• Configured and Maintained Oracle 10g/11g/12c GoldenGate & Streams replication solutions.
• Designed and implemented Oracle GoldenGate architecture for minimal downtown migrations.
• Configured bi-direction replication with conflict detection and resolution.
• Tuned Oracle GoldenGate for lag reduction & upgraded Oracle GoldenGate to newer versions.
• Performed multiple Oracle Database upgrades to 10g/12c, 18c & 19c in SAP R/3 ERP environments
• Configured and administered databases high availability: Oracle RAC and Oracle DataGuard
• Oracle Middleware Administration - APEX, ORDS, OAS, OID, SSO, WebLogic, Apache Tomcat, Apache HTTP Server, Glassfish, Apache Web Server, BI Publisher, and similar systems.
• Supported and used ServiceNow (IT Service Management System)
• Provided technical analysis and resolution of problems and incident reporting.
• Assisted in the establishment of procedures and processes for backup and recovery, database maintenance, patch management, applications support and job scheduling.
• Identify opportunities to optimize the ETL environment, implement monitoring and validation processes to ensure data accuracy and integrity
• Configuration management, performance tuning and administration of mission critical production databases
• Created schema data models, performed ETLs and validated results with business representatives
• Defined Oracle database architectures and strategies to meet application availability, scalability and performance requirements
• Created and maintained UNIX Shell Scripts for database proactive monitoring
• Contributed to improving and creating DBA policies, procedures and standards
• Participated in the after-hours roster for on-call support
• Provided technical guidance for integration, testing, design, development, planning of new major, large scale, production systems/databases
• Acted as a database project leader for critical, time driven, visible projects
• Integrated/collaborated with application development and support teams on various IT projects
• Applied patches to Oracle databases 10g, 11g, 2c, 18c & 19c.

Confidential, Atlanta, GA

Sr. Oracle Database Administrator

Responsibilities:

• Supported production databases and database applications in a 24*7 environment
• Responded to problems quickly and provides both short and long term resolutions
• Provided technical analysis and resolution of problems and incident reporting
• Assisted in the establishment of procedures and processes for backup and recovery, database maintenance, patch management, applications support and job scheduling.
• Identify opportunities to optimize the ETL environment, implement monitoring and validation processes to ensure data accuracy and integrity
• Configuration management, performance tuning and administration of mission critical production databases
• Installed, patched and upgraded of Oracle core technology products; Oracle database (both Standard/Enterprise editions 11g and 12c), Fusion Middleware 11g and security management
• Created schema data models, performed ETLs and validated results with business representatives
• Defined Oracle database architectures and strategies to meet application availability, scalability and performance requirements
• Created and maintained UNIX Shell Scripts for database proactive monitoring
• Contributed to improving and creating DBA policies, procedures and standards
• Participated in the after-hours roster for on-call support
• Provided technical guidance for integration, testing, design, development, planning of new major, large scale, production systems/databases
• Acted as a database project leader for critical, time driven, visible projects
• Integrated/collaborated with application development and support teams on various IT projects
• Applied patches to Oracle databases 11g & 12c.
• Performed upgrades of Oracle databases 11g to 12c.

Confidential, Roswell, GA

Sr. Oracle Database Administrator

Responsibilities:

• As Senior Oracle DBA (Innovation Team), I worked with other organizations in driving the Implementation of Oracle databases into GM owned data centers.
• This includes but is not limited to working closely with application teams, infrastructure groups, operational DBAs, engineering DBAs, change management
• Innovation teams to design, plan, implement, and guarantee DBs into a highly standardized, monitored, and automated environment.
• Migrated Oracle databases to Oracle Exadata Database Machines in GM Data Center.
• Understood database related architecture, design, implementation and/or performance issue resolution, and then seamlessly transferred ownership to the Database Operations team.
• Performed troubleshooting of Oracle Database issues. Provides long-term improvement suggestions for stability of these environments.
• Applied patches to Oracle databases 10g & 11g.
• Configured and Maintained Oracle 10g/11g GoldenGate & Streams replication solutions.
• Maintained High Availability of multi-terabytes mission-critical Oracle databases in diverse applications environments: Oracle Siebel, SAP, Oracle E-Business Suite and other environments.
• Provided physical and logical database support in a multiple projects; performing daily database administration activities ranging from simple to complex;
• Created and maintained UNIX Shell Scripts for database proactive monitoring.

Confidential, Dubuque, IA

Sr. Oracle Apps DBA

Responsibilities:

• Lead the project of Upgrade of Oracle E-Business Suite 11i to 12.1.3 for Oracle Financial and HCMS
• Performed frequent Rapid cloning of Oracle E-Business Suite 11i and 12.1.3 for SIT/UAT/DEV
• Applied patches to Oracle E-Business Suite 11i & R12 (on database and apps tier)
• Designed and implemented Oracle GoldenGate architecture for minimal downtown migrations.
• Configured bi-direction replication with conflict detection and resolution.
• Tuned Oracle GoldenGate for lag reduction & upgraded Oracle GoldenGate to newer versions.
• Migrated multiple databases from legacy data centres to IBM Cloud environment (IBM SmartCloud Enterprise SCE+)
• Supported Oracle databases in Oracle Exadata Database Machine X3-8.
• Used Oracle Enterprise Manager Cloud Control 10g & 12c to monitor and manage multiple databases (10g and 11g)
• Performed Annual Disaster Recovery (DR) Testing in Oracle DataGuard 10g & 11g Physical Standby Databases
• Created and maintained UNIX Shell Scripts for database proactive monitoring
• Installed, deployed and maintained High Availability and Mission Critical RAC Databases with sizes of over 1TB
• Recommend appropriate technologies, enhancements upgrades and modifications to systems and proceduresto improve the services provided by the Information Technology department
• Led a team of Oracle DBAs in upgrading mission critical environment from single instance to high availability RAC environment on Oracle Linux operating system
• Advised, provided guidance and developed High Availability and Disaster Recovery Strategies for Oracle RAC Database and DataGuard 10g & 11g environments.
• Installed, configured and managed Oracle Agents, Grid Control, and 12c Cloud Control
• Configured Oracle 11gR2 Active Data Guard Physical Standby Databases and for reporting
• Installed and upgraded Oracle databases 9i, 10g and 11g in UNIX, SunOS/Solaris, VMware ESX, Linux, IBM AIX and Windows Server environments.
• Installed and configured a three-nodes Oracle Database RAC 11gR2 (11.2.0.3) with GNS (DNS, DHCP) and High Availability IP (HAIP) Features on ASM
• Performed multiple Oracle databases cross-platforms upgrades and migrations (9i/10g/11g) from SPARC Solaris 9/10 to IBM AIX 6.1 and from Windows Server 2003 / SPARC Solaris 10 to RedHat Linux 5.5/6.2
• Participated in onsite/offshore multi-shift coordinated teams to ensure warm hand-offs.

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Performed Oracle E-Business Suite 11i installations, administration and maintenance
• Applied patches to Oracle E-Business Suite 11i (on database and apps tier)
• Performed multiple Rapid clones for Oracle E-Business Suite 11i (for non-prod refreshes)
• Provided physical and logical database support in a 24/7 availability environment; performing daily database administration activities ranging from simple to complex;
• Oracle Data Guard (9i/10g): Configuration and Administration.
• Configured automated Backup / Recovery processes: Oracle RMAN 10g and Export/Import.
• Configured and supported Oracle Advanced Queues, Oracle Streams replications (9i/10g).
• Performed Quarterly Disaster Recovery (DR) Testing in Oracle DataGuard 9i, 10g & 11g Physical Standby Databases
• Created and maintained UNIX Shell Scripts for database proactive monitoring
• Provided DBA support from development, testing through production implementations.
• Performed tuning of Oracle Applications and databases for optimal performance.
• Installed and configured Oracle Enterprise Manager 10g to monitor and manage databases and e-Business Suite 11i environments.
• Contacted Oracle Support for assistance on problems that were beyond internal capabilities to resolve.