We provide IT Staff Augmentation Services!

Lead Database Administrator Resume

4.00/5 (Submit Your Rating)

Quincy, MA

PROFESSIONAL SUMMARY

  • Talented Oracle DBA/Oracle E - business Suite Applications DBA with 9+ years of expertise and extensive knowledge in architectural design, Installation, configuration, performance tuning, upgrades, disaster recovery techniques
  • Patching and Cloning of multi-terabyte standalone and RAC on multiple platforms like Sun-Solaris, Linux. Expert in automating day-to-day processes, improve efficiency of existing processes using the unix shell scripting, java coding skills that I possess.
  • Excellent communicator, efficient team player as well as an effective team leader. Extensive knowledge on database and application Hot/Cold backup, disaster recovery strategies and high availability using tools/technologies such as Oracle Real Application Clusters
  • Oracle Data Guard, Oracle Golden Gate, RMAN, Import/Export & Datapump, Dataguard Physical Standby database. Possess excellent troubleshooting and research skills which has helped me fix all the issues that came to my attention.

SKILLS

  • Oracle E-Business Suite
  • Oracle Database
  • Oracle Fusion Middleware 11g
  • Oracle Real Application Clusters
  • Oracle E-Business Suite Installation/Upgrade/Administration
  • Linux and Sun Solaris operating system
  • Dataguard, Goldengate
  • Backup/Restore using RMAN, Export/Import
  • SQL, PL/SQL, Unix Shell scripting, Java
  • Workflow, TLS, Punchouts, DMZ
  • Performance tuning, patching, cloning
  • Troubleshooting, Security, Auditing
  • OEM 12c, 13c, Servicenow, Autosys

PROFESSIONAL EXPERIENCE

Lead Database Administrator

Confidential, Quincy, MA

Responsibilities:

  • Lead Oracle Applications DBA for a production 6TB Finance & Procurement instance.
  • Upgraded E-Business Suite application from 12.1.3 to 12.2.6 single-handedly with the minimum possible downtime.
  • Upgraded various EBS/Non-EBS databases from 11g to 12c.
  • Upgraded EBS 12.2.8 database from 12c to 19c on Oracle Cloud Infrastructure.
  • Handled performance monitoring and troubleshooting of Production Oracle E-Business Suite, Databases, Oracle Application Server, Concurrent Manager, Forms Server, and Report Server.
  • Established new databases and provided support for production and development databases.
  • Configured RAC, dataguard on versions 11g, 12c as well as 19c.
  • Performed application installation, performance and memory tuning, server and database monitoring, configuration, and troubleshooting.
  • Evaluated server and instance architecture, hardware, system specifications, and capacity planning.
  • Supported multiple clients with various oracle Application releases, RAC and Non RAC Databases on 11g with Application releases 12.1 and 12.2
  • Implemented the Shared APPL TOP on the Application Tier, Load Balancing, Failover, Parallel Concurrent Processing (PCP), DMZ and external access to the self-service nodes.
  • Prepared an efficient cloning strategy to clone EBS database/application based on the server capacity and client needs.
  • Configured TDE for EBS databases using tablespace encryption method.
  • Involved in DR Exercise for multiple accounts, also in real time DR scenarios. Met the RTO and RPO in every DR exercise so far.
  • Improved the efficiency of cloning by more than 50% by parallelizing possible things such as FTP, rman restore. Created scripts to automate the FTP and cloning.
  • Automated various process that are frequent, day-to-day tasks and that are standard in nature.
  • Configured Workflow IMAP and SMTP for Procurement.
  • Setup TLS configuration for the EBS application, configured punchouts for procurement from external vendors.
  • Setup DMZ for iSupplier.

We'd love your feedback!