SUMMARY

• Offers over twelve years of hands - on Oracle DBA working experience on Exadata, Linux/Solaris/AIX systems. Worked on quick growth, leading edge and heavy-duty Oracle environment with heavy transaction volumes and large data. Holds solid education and displays self-motivation and hardworking professionalism.
• Excellent working experience in OLTP, VLDB, RAC, ASM, RMAN backup and recovery, Data Guard, Golden Gate, Grid Control, production support, performance tuning, high availability, and disaster/recovery. Possesses strong communication and organization skills.

TECHNICAL SKILLS

• Oracle Enterprise Edition 9.2.0.x 10.2.x 11.2.0.4 12.1.0.2 12.2.0.1 19 c
• Exadata
• RAC
• ASM
• RMAN
• Data Guard
• Golden Gate
• OEM data pump
• AWR
• Unix shell scripting
• PL/SQL
• Linux
• Solaris
• AIX
• Windows.

PROFESSIONAL EXPERIENCE

Sr. Lead Oracle DBA/DMA

Confidential

Responsibilities:

• Leadership in Exadata x-7 installations and configuration.
• Upgraded grid infrastructure and databases from 12c to 19c
• Setup Autonomous database (19c) on Oracle Cloud Infrastructure.
• Worked with network engineers in assigning IPs to computer nodes, cell nodes, iloms, IBs, UPDs in management, client, private and backup subnets.
• Worked on OEDA (Oracle Exadata Deployment Assistant) to create the Oracle Exadata Rack configuration files. The files automated the installation process.
• Run IPcheck to verify that all IPs are dedicated to RACK components.
• Worked with Oracle engineers in Exadata hardware and software configurations.
• Worked with Oracle engineers in cell server expansions.
• Identified disk/memory failures and to have Oracle FE to replace them.
• Run Exachk and sundiag to check and analyze Exadata health and fix issues.
• Worked with Oracle in Exadata platinum quarterly patching.
• Worked on Exadata features query offload and hybrid columnar compression.
• Worked on infrastructure and project designs, managed project progresses.
• Worked on Golden Gate upgrade from 12.1 to 12.3.
• Worked on Oracle multitenant CDB/PDB database setup and implementations.
• Worked on RAC PSU/PBP patching and TLS patching.
• Worked with AD team on performance tuning and trouble shooting.
• Setup and maintained Oracle active data guard.
• Worked on data warehouse and partitions.
• Worked on RMAN backup/recovery/duplication.
• Oracle database migration from on premise to oracle cloud.
• Created a logical volume using ACFS used for backup on a two node RAC environment
• Upgrade both single instance and RAC environments to 12c release 2
• Deployed application codes to DEV, Test and Production environments
• Setup dataguard environment in 12c using the Far Sync instance option to limit performance impact.
• Highly experienced with oracle multitenant setup and administration.
• Setup monitoring using Oracle Enterprise Manager 13c and highly experienced setting up oracle cloud services and oracle chargeback.
• Setup and Configured oracle APEX rest data services through oracle WebLogic.
• OEM cloud self-service Implementation.
• Migration to Oracle Exadata from commodity hardware.
• Over 3+ years of extensive experience as Oracle Application DBA in implementation, upgrade and customization of Oracle e-Business Suite Application(R12,11i). This includes system study, design, development, post implementation maintenance and support ofOracle EBS.

Sr, Oracle DBA

Confidential

Responsibilities:

• Leading team in infrastructure design, project design and implementation.
• Created implementation runbooks/checklists including detailed steps, scripts, commands and roll back plans.
• Worked on OEDA design and worked with Oracle engineers on exadata HW/SW configurations.
• Worked on configuration and implementation of Exadata ASR and ORT.
• Worked on management for Exadata through ILOM.
• Monitored hardware and software components via OEM, Gateway and ASR.
• Worked on implementation of IORM and Hybrid Columnar Compression.
• Worked on Exadata quarterly patching.
• Migrated/upgraded databases to Exadata using Golden Gate replication to synchronize.
• Upgraded RAC databases from 11.1.0.7 to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2.
• Worked with AD team on performance tuning and trouble shooting.
• Setup and supported Golden Gate replication including error fix and performance tuning using multiple extract/replicat groups, parallel processing, memory adjusting and batch sql extensively.
• Participated in the modeling, tuning and supporting of data warehouse.
• Worked on partitions.
• Setup and maintained Oracle active data guard.
• Participated in the DR test with application teams.
• Worked on RMAN backup/recovery/flashback.
• Duplicated databases to refresh lower environments.
• Worked on incremental stats gathering.
• Worked on on-call rotations.
• Worked with Oracle Support on various issues.
• Performed database health check and analysis using exachk, OEM, scripts and vendor tools.
• Implemented RAC consolidation project node addition and removal.
• Completed the project removing data file block corruptions.
• Coded PL/SQL and shell scripts.
• Worked with application teams on deploys, new releases, migrations, and development life cycle.
• Worked with application teams on database performance tuning. Tuning efforts include identifying bad queries, sql plan management, AWR analysis, sql tuning, session trace, reducing waits and concurrencies, optimizing stats gathering, gold parameters implementation, parallel processing, and indexing.

Oracle DBA

Confidential

Responsibilities:

• Installed Oracle 11gR2 grid Infrastructure and created RAC databases.
• Worked with application team to build applications on the new databases.
• Setup and supported Oracle data guard.
• Supported production in a 24x7 coverage.
• Worked with application teams on performance tuning and developments.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Designed, developed, and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.
• Administered (10g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Documented the Standard Processes for peers to follow.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Oracle DBA

Confidential

Responsibilities:

• Translated business requirements into database implementation tasks.
• Set up and supported Golden Gate replication.
• In charge of RMAN backup and recovery.
• Set up Oracle data guard.
• Installed Oracle OMS and agents.
• Worked with development teams in database design, refresh, performance tuning, code review, application development, test, new release, and migrations from DEV, QA, UAT to production.
• Leading team in implementation of 10g RAC and ASM in a large environment on Linux.
• Extensively worked on RAC/ASM setup, configuration, upgrade, and database creation.
• Applied various patches.
• Supported production on a 24x7 coverage.
• Setup and maintained Oracle Oid with failover settings.
• Built Oracle multi-master replications with startup triggers.
• Worked on Veritas vcs and SRDF on Solaris servers.
• Extensively worked with application teams on performance monitoring and tuning with huge OLTP volumes and large data warehouse.