SUMMARY

• Oracle Database Administrator with over eight years of work experience, and expert level proficiency in handling technologies such as: Oracle 10g, 11g, 12c,18 & 19c, XML, Windows, Linux, Unix, AIX, Sun Solaris.
• Experienced in managing Oracle databases to enhance database performance (performance tuning), migrate data, perform patching and upgrades, implement backup and recovery procedures, and provide high availability solutions by configuring Data guard, Goldengate, and RAC.
• Installed, configured, and maintained Physical, Logical, and Active standby databases supported by Dataguard on Oracle 11g, 12c, 18c, and 19c RAC servers for the purpose of disaster recovery procedures.
• Proficient with installing, patching, and maintaining an Oracle E - Business Suite Release 12.0 or 12.1 system.
• Worked with development and operations staff in resolving problems quickly and efficiently
• Extensive experience with RMAN Backup & Recovery, Hot Backups, and Logical Backups.
• Experience in Logical backup using full/ partial export/import and Data Pump.
• Monitored and managed various database components (logical & physical) like tablespaces and segments.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, and TOAD.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing.
• Worked on Shell scripting for backup, recovery, and maintenance for databases.
• Experience in Implementing FLASHBACK technology and its various features in Oracle 12c, 18c, 19c
• Talented communicator and analytical thinker, adept at working in both individual and team settings, and creating strong collaborative relationships with coworkers.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/2006/NT/2000.

RDBMS: Oracle 10g, 11g, 12c, 18c, 19c

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM Toad, Putty, NX client, WinSCP.

Database Utilities: SQL*Plus, Oracle Enterprise Manager 12 and 13c, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

TWS Scheduler: ADF

APPLICATIONS: HR, FIN, PEOPLESOFT

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential, Jacksonville, FL

Responsibilities:

• Experience in supporting Oracle databases 10g/11g/12c,18c & 19c in different environments on UNIX and Linux, AIX, and Sun Solaris platforms.
• Created Oracle Wallets and implemented Tablespace level TDE & Data redaction.
• Experience with installation, configuration & administration of Oracle Golden Gate replication for real-time data replication, both Uni, and Bi-directional Goldengate.
• Experience troubleshooting installation issues, stress testing, performance tuning, and resolving any issues as part of database upgrade/migration activities.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required
• Configured and administered RAC databases for high availability, load balancing, and scalability.
• Experience in Oracle -PeopleSoft, PLSQL, ETL, Informatica, and cloud deployment and services.
• Experienced with installing, patching, and maintaining an Oracle E-Business Suite Release 12.0 or 12.1 system.
• Configuration and Administration of data guard for Disaster recovery (Active, Physical, Logical, and Snapshot standby databases).
• Experience with 24×7 support of production database environments - complex query performance tuning (of existing applications), Hardware and Software specification, and design.
• Ensure database security by performing database audits such as standard-based, Value-based, fine-grained, and Unified audits.
• Performed Transparent data encryption (TDE) at tablespace and column level to secure sensitive data and Data redaction/masking to protect data in motion.
• Experience in working on Linux O.S and installation of Oracle software using OUI and creating and upgrading databases across different versions from 10g to 19c using DBCA and DBUA respectively.
• Experience with Oracle Grid control (cloud) & multitenant architecture (container and pluggable databases).
• Perform database backups using Datapump for logical backups and RMAN for physical backups.
• Wide experience managing RAC databases and storage on ASM and non-ASM storage.
• Wide experience in configuring and administering Oracle Enterprise Manager (OEM) to monitor databases.
• Extensive experience with Database Migration, Installation, Database patching, and Upgrade from 11g, 12c, 18c and 19c both manually and automatically.
• Perform database tuning by identifying and tuning problems from the network to slow-running queries using tools such as AWR, ADDM, Explain Plan, SQL Trace, TKPROF, TOAD, and Oracle Enterprise Manager.
• Experience handling Peoplesoft applications.
• Generated and automated Statspack/AWR reports from the Oracle database and analyzed the reports for Oracle wait events, time-consuming SQL queries, table space growth, and database growth.
• Extensively used Data Pump, conventional export/import utilities for loading data to & from databases, logical backups, and migration of databases.
• Knowledge and experience in Unix shell scripting & scheduling of tasks e.g., backups using CRONTAB.
• Performed patches and Upgrades including CPU, and PSU both manually and automatically using tools like the Opatch utility, DBUA, and manual upgrades.
• Hands-on experience in Database cloning using RMAN, and strong backup and recovery experience using RMAN and flashback technologies using flashback recovery features and recovery queries.
• Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler, and SQL Optimizer.
• Expertise in setting up Data Guard Fail-Over/Switch-Over/Read-Only scenarios. Fabricated multiple CLONING databases using the traditional method and RMAN utility for High availability configuration.
• Good exposure of Oracle DBA tasks like: Extensive knowledge of database backup/recovery strategy using RMAN and configuration of Recovery catalog for multiple databases.
• Performed periodical backups of both full and incremental, Hot/Cold backups and restoration, recovery of database using RMAN utility.
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines. Installed Oracle 11g, 10g, 12c, 18c and 19c RAC software.
• Experience in migration of Non RAC database to RAC, RAC to NON RAC using RMAN, RCONFIG and DBCA.
• Experienced with Adding and Deletion of Nodes in RAC.
• Experienced with upgrading databases from 10g and 11g to 12c to 18c and to 19c
• Worked with Oracle Advanced Technologies like Oracle Enterprise Manager Grid Control, Oracle Golden Gate, Data Guard and Real Application Clusters.
• Implemented and configured replication technology using Data Guard installation, configuration and troubleshooting on Linux and Unix Platforms.

Oracle Database Administrator

Confidential, Atlanta, GA

Responsibilities:

• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Ability to design, develop, test, and deploy web applications.
• Strong experience in web development technologies like HTML.
• Wide experience in data warehousing & Data modeling.
• Strong skills in applying security patches like CPU, PSU, and One-off Patch
• Successfully upgraded the databases from 11g to non-CDB 12c, to 18c, and to 19c.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation, etc.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover, and switchback with Physical standby setup.
• Configured Goldengate for real-time data replication
• Migrated data using data pump, and transportable tablespaces both between Oracle platforms and across other platforms.
• Expert in tuning database performance using the AWR report, ASH report, ADDM, Explain Plan, and seeking recommendations from the Tuning advisors.

Oracle Database Administrator

Confidential, Atlanta, GA

Responsibilities:

• Supporting multiple databases for production, development, test, and staging purposes on Sun Solaris and Windows environments.
• Applying upgrade patch, maintenance, and interim (opatch) patches on all the databases.
• Implemented oracle 12c active standby database for test database environment.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Providing database administrative support and 24x7 on-call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5
• Experience with large databases (1.5 Tb) for OLTP and OLAP applications.
• Performed installation, configuration, and maintenance of oracle 11g/12c, 11g RAC databases.
• Experience in configuring oracle 10g, 11g Real application cluster (RAC) (2 and 3 nodes) using cluster ware and automatic storage management(ASM).
• Performed migration of oracle 10g/11g non-RAC single instance to RAC database instances.
• Experience with 11g cluster maintenance using the CRSCTL command.
• Experience in using SRVCTL command for Oracle 11g RAC database.
• Implemented Disaster Recovery database 10g/11gData Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Knowledge in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
• Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth, and file system space, in adherence to the Optimal Flex Architecture
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO, and Memory Usage.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
• Extensively worked with ASMCMD for managing the ASM environment.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, Weekly Backup, etc.)
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing, and use of Hints, Stored outlines, and Statistics.
• Resolved data integration issues.
• Performed version upgrades and patch installs.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.
• ASM implementation & maintenance. Migrating and upgrading the Oracle 10g database to Oracle 10g and incorporating the changes in the database design.
• Implemented oracle 12c flex asm for pre-prod environment.
• Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.
• Installed, and Configured Oracle 12c Goldengate on Oracle 12c Database.
• Implemented OEM 12c Repository database, OEM 12c Agent, and golden gate plugin Installations.
• Proactive performance monitoring, and capacity planning for future database and server growth using OEM.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Responsible for the smooth functioning of all ecommerce activities of the organization.
• Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC