SUMMARY

• 10+ years expertise as a Oracle DBA which includes Installation, Configuration, Performance Tuning, Backup/Recovery, Disaster Recovery, up - gradation, cloning, patching, RAC, ASM, Golden Gate, 24X7 On-Call production support and on different HP-UX, Redhat, Linux, AIX, and Windows machines.
• Proficient in DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• Installed and configured of GoldenGate on 11g/12c database for data replication.
• Extensive knowledge on database administration for Oracle 12c, 11g, 10gwith experience in very large scale database environment (VLDB) and mission critical large OLTP and OLAP systems.
• Exposure to Real Application Cluster (RAC) environment with Auto Storage Management (ASM) for Oracle 12c, 11g and 10g rdbms ranging from few GB to 80 TB on Oracle Linux 5.x, 6.x IBM AIX 5.3, HP-UX 11, Solaris 2.8/9/10, LINUX SUSE & Windows.
• Implemented TAF, FAN and Load balancing for cluster databases (RAC) to achieve high availability for applications thus meeting required SLA’s.
• Experience with 12c, 11g RAC Grid infrastructure and standalone new features.
• Experience with SUN ORACLE DATABASE MACHINE (EXADATA) Full, Half and Quarter Racks.
• Experience in managing SUN ORACLE EXADATA FLASH CACHE, GRID DISK, CELL DISK, ILOM.
• Successfully implemented and managed Physical Standby Database using Oracle DATAGUARD feature for High availability configuration.
• Good Experience in GoldenGate setup and troubleshooting and well experienced in planning, designing and maintenance of the GoldenGate environments.
• Design, development and testing of the ELT/ETL Process for loading the Judicial Data warehouse from various source systems.
• Experience in setting up/Installation and configuration of release 11g R2 and 12c RAC with ASM and Raw Devices and CRS. Experienced in configuring & Managing the ASM.
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Experience in designing and capacity planning of databases up to terabytes of data.
• Experience in maintaining large Production, UAT, QA and DEV environments.
• Creating new Oracle databases using DBCA or database scripts. Installing creating new ASM disk group or raw devices for RAC databases.
• Very good experience in installing, configuring and administering 10g and 11g 2/3/4 node RAC databases.
• Experienced in using 10g and 11g features like Data pump & Flashback Recovery.
• Upgrading the databases from various versions to 11g release 2 and 12c.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Tuned the database at various levels such as Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK proof, Explain Plan, Stats Pack, AWR and ADDM.
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental and cumulative backups.
• Good Written and verbal Communication skills with a customer service oriented attitude.
• Manage access control lists for middleware software.
• Experience in working with the architect team to model the structure of the database through Entity-Relationship diagram models (E-R diagrams).
• Migration of the user schema using traditional exp/imp and Oracle Data pump utilities.

TECHNICAL SKILLS

• Oralce Database 11g,12c administration
• Advanced, Recovery Manager (RMAN)
• Advanced, Oracle Enterprise Manager (OEM) 12c, 13c
• Advanced, Oracle Real Applications Cluster (RAC)
• Advanced, Oracle Data Pump Export & Import
• Advanced, Oracle Goldengate
• Advanced,Redhat, Linux, Unix, AIX, Windows Operating systems
• Advanced, Automation with shell scripting: Advanced.

PROFESSIONAL EXPERIENCE

Confidential, North Charleston, SC

Sr Oracle DBA/ Exadata Admin

Responsibilities:

• Worked in an environment with Very Large databases on various flavors of UNIX operating systems which include both clustered (RAC) and standalone databases using various versions of oracle rdbms.
• Provided Primary architectural and administrative support for new projects.
• Experience with business process models for IT support such as ITIL, Change Control and Change Advisory Board (CAB).
• Actively Participated in coordinating with Line of Business (LOB) and application team in moving the project “Go Live”.
• Exposure with cellinit.ora, cellip.ora, /etc/sysconfig/network-scripts, /opt/oracle.support, /opt/oracle.cellosfiles and scripts.
• Experience in Patching / Upgrading SUN ORACLE EXADATA MACHINE (RDBMS / Grid infrastructure & Storage cells).
• Upgraded Exadata Storage Image version from 12.2.2.4.2 to 19.2.5.0.0 and Linux to UEK Kernel using YUM Repository.
• Applied BP6, BP11, BP17 bundle patches and LISTENER CVE Patches and Wallet Configuration for Exadata X2 Box.
• Oracle Enterprise Linux 6.x x86 64 bit, Infiniband for storage connectivity, Gigabit/10gb Ethernet, cluster connectivity, ASM file system for database files and oracle 12.2, 12.1, 11gr2 rdbms version.
• Experience in handling large database up to 80TB in size with 4 nodes and largest table of size 215 gb with 3 billion records.
• Experience in Installing oracle 19c/ 12c/11g RAC databases using ASM file system and managing using server control utility (SRVCTL) and CRSCTL to achieve high availability.
• Configured high availability services TAF, FAN, Load balancing and SCAN features for clustered databases.
• Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.
• Experience in Reviewing the Cluster Logs for troubleshooting and Implementing Cluster Health Check.
• Implemented LINUX HUGE PAGES on OEL 5.x, 6.x for Clustered Environments.
• Experience in patching RAC databases in rolling fashion to maintain high availability.
• Experience with Various System Development Life Cycle (SDLC) models such as waterfall and Agile methods.
• Exposure to SOX, PCI and HIPAA security compliances.
• 24x7 Production database and applications support.
• Partitioned large tables in Range, List, Interval for better performance and manageability.
• Responsible for moving data from Production to lower environments for various testing cycles usingOracle data pump and also refresh the UAT and Test environments with Prod data.
• Implemented database security using Oracle's Transparent Data Encryption based on Database Security Technical Implementation Guide (STIG).
• Provides guidance and troubleshooting for complex technical issues.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysisetc.
• Performance Tuning OGGin extremely high data volume environments. Installing and configuring OGGheterogeneous environments.
• Monitor and fully analyze performance issues in production Oracle databases by usingAWR/ADDM/OEM 12c.
• Firsthand experiences in setting up Oracle GoldenGateone-way, two-way/bi-directional
• Deep understanding Oracle GoldenGate internal mechanism, OGG new features such as Integratedcapture, native DDL capture, coordinate apply mode, multi-threaded replicate.
• Developedhome-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (OracleEnterprise Manager) 12c.
• Monitoring the health of a database and ensuring that it performs optimally is an important task for adatabase administrator with OEM (Oracle Enterprise Manager) 11g/12c.
• Mainly work on Performance tuning. Working with primary DBAs in the DB support team, support themission critical OLTP and Data Warehouse production databases. Working as one key member of the technical resources pool to support the Front Line Support On-Call team according emergence requirements and issues.

Confidential, Stone Mountain, Georgia

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle databases (single instance) as well as 3 node RAC instances in 11g.
• Active duplicate cloning of the databases using RMAN.
• Cloning from cold backup using RMAN.
• Upgrading test and production environments to 11g.
• Responsible for Data Center Relocation for migration of standalone databases on Windows and UNIX to Linux.
• Monitored the Oracle databases through the Oracle Enterprise Manager and configured alerts.
• Incident and ticketing management including working on authorized heat calls, work requests and project work.
• Perform problem trend analysis to prevent problem recurrence and to improve service levels.
• Incident and ticketing management including working on authorized heat calls, work requests and project work.
• Plan Golden Gate setup to achieve Unidirectional replication.
• SetupGoldenGate Database User with necessary privileges.
• Involved in database troubleshooting and maintenance activities and solve some GoldenGate issues such like abended, lagging, long transaction issues.
• Resolved the issues in conflicts between the target and source database in GoldenGate.
• Responsible for moving data from Production to lower environments for various testing cycles using Oracle data pump and also refresh the UAT and Test environments with Prod data.
• Generated AWR and ADDM reports for Performance and Tuning .
• Security Administration including the management of profiles, roles, users and their privileges.
• Configure and manage RMAN backups.
• Administrate RAC service with SRVCTL.
• Configure and manage RMAN backups.
• Restorations of databases using RMAN at different incremental levels.
• Experience in opening, managing, and resolving Oracle Service Requests.
• Generating AWR reports on regular basis to identify the database performance at peak load.
• Tuning the SQL statement by analyzing the explain plan and ADDM reports.
• Worked on HP UX platform and logically migrated data from UNIX to Linux RHEL through Data Pump.

Confidential, Pittsburgh, Pennsylvania

Oracle DBA

Responsibilities:

• Installation and maintenance of Oracle 11g Data Guard (Active).
• Plan Golden Gate setup to achieve Unidirectional replication
• Data Guard using physical standby database, implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Setup GoldenGate Database User with necessary privileges
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
• Installed Oracle 10g, 11g RAC database on Red Hat Linux.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Coordinate with UNIX administrators for space management on various servers.
• Setting up new environments (Development, Production etc.).
• Database backup and recoveries using RMAN.
• Cloned database from production to Test using RMAN.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Setup backup and recovery procedures using RMAN.
• Involved in I/O tuning by moving data files and redo log files to faster disks.

Confidential, Chicago, Illinois

Oracle DBA

Responsibilities:

• 24x7 Production database and applications support.
• Installed, configured, and maintainedOracle 10g and 11gR2.
• Upgraded databases from Oracle 9i, 10g to 11g.
• Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Applied CPU patches.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN.
• Moving data between databases using Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Partitioned large tables for better performance and manageability.
• Installed and configured GoldenGate for replication.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups andLogical backups .
• Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Worked with Data Pump to take the logical backups of databases.