Summary

As an experienced Oracle Database Administrator with 13 years of expertise in system and database management, I excel in performance tuning, crisis management, and supporting high availability to enhance reliability and maximize productivity. I am proficient in Oracle GoldenGate for disaster recovery and server manageability, as well as skilled in Microsoft Azure and AWS cloud computing. My expertise includes configuring active-active replication environments and upgrading Oracle GoldenGate. I have a strong background in backup planning, user management, space management, and high-availability environments. Additionally, I possess knowledge in database design, performance monitoring, and replication techniques. Throughout my career, I have gained extensive experience in all aspects of the project lifecycle, including business requirements, technical definitions, testing, production support, documentation, training, and successful completion. Experience

AT&T Atlanta, GA

Senior Oracle DBA & GoldenGate Administrator(IBM) 08/2018 - 05/2023 Install and configure high availability Oracle GoldenGate (OGG) systems on Oracle 11gR2, 12c, and 19c RAC environments.

Carry out daily backup operations, ensuring all required file systems and system data are successfully backed up to appropriate media. Create recovery tapes or disks and manage the recycling and off-site storage of media as necessary. Develop and implement Oracle virtual private database policies (VPD). Utilize the Data Encryption API to develop applications. Control data access using Oracle Virtual Private Database. Collaborate with applications to integrate Oracle Virtual Private Database security policies and utilize Automatic Re- parsing for fine-grained access control policy functions. Provide advanced technical support to enterprise DBA team on various Oracle database technologies, including Exadata, GoldenGate, Streams, RAC, upgrades, migration, performance tuning, backup and recovery, RMAN, partitioning, Oracle Enterprise Manager, SQL, PL/SQL, code review and optimization, flashback, troubleshooting, data pump, RDBMS security, and server resource utilization optimization. Configure and maintain replication using Oracle GoldenGate. Automate tasks such as Oracle GoldenGate restart using cron. Configure lag using Oracle GoldenGate script and automate hourly email notifications in a high-volume multi-master replication environment.

Implement high availability using Oracle GoldenGate replication. Configure Oracle GoldenGate for unidirectional and bidirectional replication. Perform DDL and DML replication from test and development instances using Oracle GoldenGate. Implement Oracle GoldenGate for active-active replication between data centers for high availability. Implement multiple replication sites for Oracle migration projects using GoldenGate software to migrate large terabyte- sized Oracle 11g databases to Oracle 12c databases on Sun Solaris UNIX platforms with minimal downtime, meeting service level agreements.

Troubleshoot Oracle GoldenGate components.

Migrate large data from Exadata to RAC clustered environments. Install and configure Oracle 11gR2 and 12c on Linux and HP servers. Migrate standalone databases to RAC and ASM.

Design and plan database upgrades from 11g to 12c, including Single Instance to Multi-Tenancy conversion. Install and configure Oracle 12c Multi-Tenant Container Database and Pluggable Database format. Possess a detailed understanding of RAC, RAC One Node, Single Tenancy, and Multi-Tenancy advantages and disadvantages.

Create application context packages for VPD configuration. Create login triggers to monitor user access using VPD technology. Create synonyms, objects, and grants on security packages for users. Apply security policies to VPD tables.

Create duplicate databases for RAT testing and migrate databases from Exadata to RAC environments. Install, configure, and maintain Oracle 11g/12c Databases on Linux, UNIX, and Windows platforms. Participate in the complete software development lifecycle, including database design, system analysis, design, and development.

Install and configure 11g and 12c Grid Control.

Usen Usen

404-***-**** adx1t7@r.postjobfree.com Duluth, GA Deploy OEM Grid Agents for monitoring production databases on UNIX, LINUX, and Windows. Implement Oracle Database 11g/12c Real Application Clusters (RAC) using Oracle Clusterware for high availability on ASM.

Establish and maintain RMAN backup and recovery strategies for RAC and Single Instance Databases. Work on Oracle 11g migration projects with minimal maintenance windows and apply patches to various databases. Schedule and troubleshoot jobs using OEM Grid Control 11g and OEM Cloud Control 12c, including deploying OEM agents, scheduling backup jobs, and troubleshooting failed jobs. Implement disaster recovery solutions using physical standby databases for high availability. Provide incident and problem management, as well as change release management to meet business service level agreements.

Monitor database performance using Oracle Grid Control and utilize AWR, ADDM, and ASH features to generate reports for collecting metrics and performing health checks on databases. Perform maintenance tasks on production and development databases, including tablespace management, user creation, granting privileges and roles. Support RMAN backup and recovery, including physical and logical backups using data pump tools.

Conduct performance tuning and optimization for Oracle applications and databases, utilizing techniques such as DB cache tuning, library cache tuning, dictionary cache tuning, AWR reports, SQL Trace, and explain plan. Identify and resolve performance issues to ensure optimal speed and efficiency of the database. Install new servers or rebuild existing ones, configuring hardware, peripherals, services, settings, directories, and storage according to standards and project/operational requirements. Regularly apply operating system patches and upgrades, as well as upgrade administrative tools and utilities. Configure and add new services as needed.

Perform daily system monitoring, ensuring the integrity and availability of hardware, server resources, systems, and critical processes. Review system and application logs, and verify the completion of scheduled jobs, such as backups. Provide Tier III support and assistance to various stakeholders, investigating and troubleshooting issues that arise within the Oracle environment.

Implement physical standby databases using Oracle Data Guard for high availability configurations. Verizon Atlanta, GA

Database Administrator 08/2015 - 06/2018

Created databases to meet evolving company and client requirements. Configured Oracle Network environment, including Oracle Net Services and Listeners, and managed Oracle network. Optimized SQL statements using Oracle Optimizer hints. Installed and configured Oracle Enterprise Manager (OEM) / Grid Control. Utilized RMAN for database backup and recovery, as well as Data Pump, Import, and Export utilities. Modified database object structures as per business and application requirements. Performed cloning and replication of production environments for testing purposes. Installed, configured, troubleshoot, and maintained Oracle GoldenGate in production environments. Designed extraction and replication strategies for Oracle GoldenGate. Proposed and implemented initial load strategies for GoldenGate. Utilized GoldenGate for maintaining Live Standby Databases. Implemented Active-Active Synchronization (Bi-Directional Replication) using Oracle GoldenGate. Configured Oracle GoldenGate Security.

Configured Oracle GoldenGate in heterogeneous environments (different operating systems and databases). Developed solutions to handle high transaction loads using Oracle GoldenGate. Executed data migration without downtime using Oracle GoldenGate. Troubleshot GoldenGate extract processes and replication-related issues during code deployment and data refresh activities.

Supported and maintained Oracle GoldenGate for data replication and high availability databases. Debugged GoldenGate replication issues.

Provided daily or weekly operational reports to management, highlighting concerns or issues related to the system. Identified and resolved performance issues at the database and I/O levels. Managed database security, including creating users, roles, profiles, and granting privileges based on business requirements.

Provided reliable assistance within a 24/7 rotational shift schedule. Administered and maintained databases, performing daily monitoring and performance analysis using ADDM, AWR reports, etc.

Collaborated within a team environment to achieve business goals, designs, and reviews. Maintained database integrity through troubleshooting, patching, updating, and performance enhancements. Demonstrated expertise in managing high availability solution centers with Oracle Real Application Clusters (RAC) and multiple nodes.

Developed SQL scripts for routine database checks, such as verifying Listener status, optimal database functioning, handling Unix error messages, and monitoring disk space availability. Lowes Atlanta, GA

Database Administrator 04/2014 - 07/2015

Created end-user accounts via Active Directory under the guidance of the System Administrator. Responded to customer inquiries, diagnosing their needs through qualifying questions over the phone and in person. Contributed to defect fixing, delivery of database patches, creation of database upgrade documents, and release notes for database releases.

Troubleshoot software applications such as Lotus Notes, Lexis Nexis, SharePoint, MS Office Suite, QuickTime, and Adobe Acrobat Reader.

Participated in the development of backup scripts using shell scripts and deployed them on Unix servers. Assisted in the performance tuning of the database. Maintained offshore database environments.

Worked on backups using DataPump and RMAN.

Configured and set up networks and servers.

Installed and maintained firewalls.

Installed and troubleshooted switches.

Collaborated with Tier I support to resolve escalated technical issues promptly and effectively. Ensured network security through Active Directory and antivirus server management. Resolved network connectivity issues.

Converted physical servers to virtual servers using VMware. Managed virtual servers containing backup, antivirus, and file server components. Proficient in operating systems such as Windows 10 and XP Professional. Installed, configured, troubleshooted, and maintained PC hardware and peripherals, including desktop computers, laptops, modems, etc.

Synchronized Lotus Notes with Windows.

Conducted hardware troubleshooting on Dell and HP systems. Assisted the System Administrator in managing portals through SharePoint. Assisted the System Administrator in configuring new servers. Provided training to new employees.

Acted as a team lead.

SunTrust Atlanta, GA

Database Administrator 02/2013 - 03/2014

Project: Online Positive Balance File (Online PBF) Client: SunTrust Bank

Project Details: The project aimed to update customer balances in the ATM switch database in near real-time. Previously, customer balances were updated by a batch process with a 24-hour delay, causing discrepancies in offline ATM transactions. The solution involved deploying Oracle GoldenGate and PL/SQL logic to update the ATM switch database from the production database, reducing the delay to 300 seconds. Job Profile:

Played a key role in designing the solution for online balance updates at the ATM switch-end using Oracle GoldenGate and PL/SQL logic, replacing the traditional batch process. Configured Oracle GoldenGate components, including EXTRACT, REPLICATE, and PUMPS, for the Online PBF Solution. Configured Oracle GoldenGate to read data from the production database's redo logs without impacting its performance. Troubleshot GoldenGate components and resolved queries related to customer account data. Managed critical activities such as year-end transaction loads and disaster recovery drills for the Online PBF Solution. Provided daily health check monitoring reports to the application owner. Activities:

Successfully handled year-end loads by extracting change data for all bank customers and delivering it to the ATM switches.

Validated balance and customer data through testing using DataPump. Deployed the solution for associate banks of Regions Bank. Implemented a strategy for zero data loss.

Ensured the functionality of Online PBF during all DR drills. Fine-tuned the solution, particularly in relation to GoldenGate. Accommodated table partition activities at the source production end by making necessary changes to Oracle GoldenGate components.

Project: Integration Accelerator Framework - Payments (IAF-P) Client: SunTrust Bank Atlanta

Role: Database Team Lead

Description: The Integration Accelerator Framework - Payments (IAF-P) is a framework designed to expedite the implementation of Payments Middleware integration. It consists of technology and domain components that facilitate the integration process.

Responsibilities:

Created low-level design documents for the project. Developed coding standards, naming conventions, program specifications, unit test plans (UTPs), and low-level designs. Responsible for module design and object creation, including packages, procedures, functions, indexes, sequences, etc. Also involved in schema creation and database deployment. Designed the database and created entity relationship diagrams (ERDs). Assisted in environment setup and installation of Oracle database and Oracle GoldenGate. Conducted unit and integration testing for IAFP services. Implemented data replication between operational and analytical systems using Oracle GoldenGate. Technologies used: Oracle 11g, GoldenGate Java, ADF Uni-Tech Drilling Company Portarcourt, Rivers

Application Support Specialist 06/2010 - 01/2012 Responding to user inquiries and addressing application issues in a timely manner. Providing technical support for software applications, including installation, configuration, and troubleshooting. Collaborating with cross-functional teams to diagnose and resolve complex technical issues. Documenting and maintaining knowledge base articles and user guides to facilitate support processes. Conducting training sessions and creating user documentation to enhance application utilization. Performing proactive monitoring and maintenance to identify and resolve potential issues. Testing and deploying application updates, patches, and releases. Ensuring compliance with service level agreements and delivering high-quality support services. Staying updated on industry trends and suggesting process improvements for enhanced efficiency and user satisfaction. Collaborating with vendors and support providers to resolve escalated issues and implement solutions effectively. Skills

DATABASE: • Oracle Database 9i, 10g, 11g and 12c, 19c, 21c, OPERATING SYSTEM: • Unix/Linux/Windows, LANGUAGES: • SQL, PL/SQL, JAVA, Visual Basic., STORAGE: • ASM (Automatic Storage Management), SOFTWARE APPS: • SQL Plus• PL/SQL Developer• Toad• Rapid SQL, •RMAN• Data Modeler• Data Pump• AWR• OEM/Grid Control, DATA REPLICATION: • Oracle GoldenGate 11gR2/12c,19c, • Oracle RAC Administration, • SQL Tuning in Oracle Environment, • Performance Tuning & capacity Monitoring, • Oracle Virtual Private Database, • AWS • Azure • Exadata • Patching • Storage• Oracle VPD, • Backup and Recovery Education

Kennesaw State University Kennesaw, GA

Graduate Certificate in Information Security & Assurance 07/2022 By earning a graduate certificate in Information Security & Assurance, I have demonstrated my commitment to advancing my knowledge and skills in this critical field. These academic achievements showcase my expertise in information security principles, hands-on experience with security technologies, and ability to contribute to the protection of digital assets in today's interconnected world.

Kennesaw State University Kennesaw, GA

Master's of Science Healthcare Management & Informatics. 07/2022 High Academic Performance: Throughout my Master's degree program, I consistently maintained a high level of academic performance, earning excellent grades in courses related to healthcare management, informatics, and other relevant subjects. This demonstrates my strong commitment to academic excellence and my ability to grasp complex concepts effectively.

Contact this candidate