We provide IT Staff Augmentation Services!

Oracle Application Dba - Lead Resume

Houston, TX

SUMMARY:

  • Over 12+ years of in - depth experience in various technologies including Oracle Apps DBA/Core, Oracle DBA/Unix Shell Scripting, Amazon AWS, SQL-Server, MYSQL, MariaDB, Control-M, Oracle OBIEE, SOA, Oracle GRC Control Suite.
  • Having experience in Oracle Apps Implementations, Upgrades, Cloning, Production Support, Platform Migration projects.
  • Experience in managing projects from concept through implementation by managing diverse teams working relationships to achieve positive results.
  • Implemented the ticketing system to support Database system 24 by 7 and track the activities for Pro-active approach solutions.
  • Experience in Database administration, Backup and recovery, Performance monitoring and tunning, security and compliance, capacity planning, installation, upgrades, migration and disaster recovery implementation.
  • Headed an offshore team of DBAs and providing 24/7 support to clients all over the US across many industries.
  • Instituted proactive performance monitoring measures to ensure SLA performance goals
  • Identified critical application issues including those relating to performance, forms and concurrent processes and solved problems
  • Administered Development, QA, Integration, UAT, Pre Prod and Production environments.
  • Implemented Oracle GRC suite (AACG, CCG, PCG, TCG, and EGRCM) for several enterprise customers across industries such as Healthcare, Communication, Oil & Gas, Public Sector and Retail.
  • Excellent communication skills and customer relations.

TECHNICAL SKILLS:

RDBMS: Oracle 12C\11G\10g\9i, Data Guard, SQL Server, MariaDB, MySQL

Application Admin: E-business suite 12.2, 12.1.3,11.5.10.2

Fusion Application: Weblogic, SOA, OBIEE

Web application: Oracle iAS,, Tomcat, Apex, ORDS.

Hardware/OS: Solaris Sparc, IBM AIX, RHEL, Oracle Linux, Microsoft Windows

Database Utility: OEM,RMAN, Data Guard, DATAPUMP,TOAD, ADOP, ADPatch,GRID,RAC,ASM

Virtualization: VMware, OVM,Xen

Cloud Apps: Amazon EC2,RDS Oracle Public Cloud.

Compliance: Oracle GRC suite (AACG, CCG, PCG, TCG, EGRCM & GRCI), User Provisioning UMX

Backup Applications: RMAN, Data guard, Datapump. Online and offline backups,cold backups logical backups,Snapshot backup, VM backup.

Performance: ADDM, AWR, Explain Plan, TKProf,Stats pack, OEM,DBMS STATS, SQL Tuning Advisor.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Application DBA - Lead

Roles & Responsibilities:

  • Working closely with BA’s across departments during the monthly closing cycle to have smooth process completion. Monitoring the loads and streamline the process helped them to complete the close on time. This results in efficiencies and, in turn, cost savings.
  • Identified and solved the issue encountering in Production server. This helped them to have the system online without any frequent crash
  • Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds.
  • Implemented Active Data Guard for maximum protection, performance and availability. This reduced performance load by 25% on Primary Production environment and stabilized the Reporting application users to work parallel.

Environment: Oracle Ebiz 12.1.3, P2 Land OEM 13C, P2 EU,Land, Splash

Confidential - Houston, TX

Oracle Application DBA - Lead

Roles & Responsibilities:

  • Refresh Ebiz and other dependent application modules on a weekly/monthly basis.
  • Implemented DMZ configuration for Isupplier portal.
  • Scheduled and managed backup policy on the Production critical application.
  • Initiated and strictly adhere to follow the process of change management controls to the environment. This effort benefited the management in evaluating the development, testing deliverables and also helped them in internal and external auditing.
  • Managed multiple applications across various environments with 99% uptime availability
  • Managing Terabyte database running on Windows.
  • Perform OBIEE installation and upgrade and managing the environment.

Environment: Oracle Ebiz 12.2.5,ADG, OBIEE, Control-M, P2-EU, P2 Land, Flowcal, TOW

Confidential

Oracle Application DBA - Lead

Roles & Responsibilities:

  • Performed Database Reorg and reclaimed over 1.5(TB) space in a Database Reorg in one of the most critical databases
  • Implemented Server migration of all the environments to new hardware, which helped the IT users with the fast response time and eliminated the frequent performance issues.
  • Managing the DEV, PROD environment
  • Implemented Data Guard with high availability and performance configurations.

Environment: Oracle Ebiz 11.5.10.2, Oracle 11.2.0.4, Apex, ORDS,Tomcat

Confidential

Oracle Application DBA - Lead

Roles & Responsibilities:

  • Managing TEST, DEV, PATCH, UAT, QA and PROD environments across multiple platforms.
  • Proactively identify issues and make sure services are meeting SLA’s with 5mins response time.
  • Managed database administrators on Oracle, MariaDB, SOA & SQL server environments across multiple sites and offshore teams and provide pro-active 24/7 support.
  • Managed in provisioning and setup of servers in AWS for the new business operations.
  • Managing the application running on AWS EC2.
  • Configured the Cloudwatch Alarms metric’s AWS RDS.
  • Ensured adherence to key regulatory demands through the design and deployment of SOX compliant database and OS security structure audited and resolved all issues.
  • Actively participate with the project management team in strategic planning, goal setting, and monitoring, providing status updates on a regular basis.
  • Performed 12.1.3 upgrade from R12.
  • Schedule and monitor jobs through Control-M
  • Installation of Oracle APEX and Listener configuration through Apache or tomcat web servers with EBS integration.
  • Configured the monitoring scripts for maintaining database administration tasks
  • Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested. This effort reduced the number of outages by over 20%

Environment: Oracle Ebiz 12.1.3, SOA 12c, SQLServer 2008/2012/2014 , AWS EC2, RDS, MariaDB, MYSQL Control-M

Confidential -Dallas, TX

Oracle Application DBA - Lead/GRC DBA

Roles & Responsibilities:

  • Implementation of Oracle GRC Control Suite (Oracle Advanced Controls) products -Access Controls Governor AACG, User Provisioning, Preventive Controls Governor, Configuration Controls Governor, GRC Platform suite & Transaction Controls Governor)
  • Installation/Upgradation of GRC Suite to multiple customers.
  • Executed assessments on designs and operational effectiveness of ERP application controls
  • Conducted Conference Room Pilot (CRP) sessions for business process fit-gap
  • Managed clients with the remediation process including report generation, incident analysis, and clean-ups. Performed end-user training and documenting procedures for all related Oracle GRC processes and controls
  • Implemented snapshots to document current ERP setups and performed comparisons across various components. Configured change tracking objects on Oracle for ongoing monitoring.

Environment: Linux, EBS R12, Windows, OBIEE, Weblogic

Confidential

Oracle DBA Manager

Roles & Responsibilities:

  • Managed the team of 20 members and providing 24/7 support and maintain the critical databases and Ebiz 11i application.
  • Migrated EBS 11i from AIX to Linux with Application running on 4 node RAC
  • Managed refresh of instance on requested basis
  • Identified critical application issues including those relating to performance, Work Flow, forms, reports, and concurrent processes and solved problems
  • Managed set up of Data Guard- Physical Standby instance in Production Instance
  • Managed Installing Application Management Pack (AMP) in OEM 11G to monitor the E-Business Suite of Production and Test Environments
  • Well versed in DBA Activities and Administration of Oracle Applications and was involved in the success of various teams across multiple projects globally
  • Applied Database and Application Patches (Opatch, AD patch, RUP), HR Global, CPU Patch, and Data Install, HRMS legislative patches in Production and Development instance
  • Upgrade EBS applications from 11. .1.3
  • Supported on cloning and patching the environment on regular basis

Environment: Linux, Oracle Apps 11.5.10.CU2, Linux, EBS R12, Windows, EBS R12

Hire Now