Chima Uko

Accomplished Oracle Database Administrator with 9 years of experience supporting enterprise environments across government and private sectors. Expert in Oracle 11g/12c/19c RAC, Data Guard, GoldenGate, and AWS cloud migration. Proven success in managing high-availability clusters, automating backup and recovery, and implementing security patches for mission-critical databases.

Oracle DBA - Landis+Gyr - Atlanta, GA

(2024-02)

• Installed and maintained Oracle RDBMS (11g, 12c, 19c), ensuring optimal database performance and system reliability across multiple environments.
• Enhanced database security by implementing security patches, including patch sets, critical patch updates (CPU), and patch set updates (PSU), reducing vulnerabilities.
• Executed database upgrades from 11g to 12c and 12c to 19c, minimizing downtime and ensuring seamless transitions for business-critical applications.
• Set up and configured Oracle Enterprise Manager (OEM), improving monitoring capabilities and streamlining database administration tasks.
• Installed and configured a two-node Oracle cluster RAC database with GRID infrastructure using ASM storage, increasing system availability and scalability.
• Executed database cloning using RMAN active duplicate or gold copy backup, supporting development and testing environments with accurate data copies.
• Utilized shell and bash scripting to automate routine DBA tasks, increasing operational efficiency and reducing manual intervention.
• Developed intricate queries using statistics, indexing, and profiling tools to optimize SQL execution plans, improving query performance.
• Implemented effective backup and recovery strategies and protocols using RMAN, ensuring data integrity and rapid disaster recovery.
• Established user access, rights, and privileges, assigning roles and profiles to maintain database security and compliance.
• Conducted data refreshes at schema, table, and database levels to ensure applications were prepared for testing or data readiness.
• Built Postgres databases and performed post-build steps, including Kerberos authentication and monitoring setup via Postgres Enterprise Manager.
• Scheduled and maintained daily backup strategies, ensuring consistent data protection and minimizing risk of data loss.
• Set up database user accounts, supporting secure access and proper user management.
• Maintained database partitions to optimize storage and improve query performance for large datasets.
• Built and maintained a physical standby database to replicate the primary database in asynchronous mode, enhancing disaster recovery capabilities.

Oracle DBA - TCS - Marietta, GA

(2019-01 - 2023-12)

• Maintained Oracle 11g, 12c, and 19c Real Application Cluster (RAC) databases for high availability and performance by optimizing cluster architecture and hardware configuration.
• Configured ASM disks and disk groups for RAC and standalone/two-node environments, establishing TAF policies to enhance failover and reliability.
• Migrated Oracle databases to AWS, leveraging cloud scalability and elasticity to improve infrastructure flexibility.
• Scheduled backups and monitored alerts on AWS, increasing scalability and ensuring robust disaster recovery protocols.
• Configured Oracle GoldenGate for unidirectional and bidirectional replication, supporting real-time data integration across platforms.
• Set up Active DataGuard configuration for reporting, enabling near real-time data access and improved reporting capabilities.
• Performed cross-platform migration from on-premises database servers to cloud, ensuring minimal downtime and data integrity.
• Executed switch over and failover of Oracle DataGuard databases for disaster recovery testing using Oracle DataGuard broker DGMGRL.
• Implemented high availability mechanisms such as RAC, Data Guard, and clustering technologies to minimize downtime and maintain business continuity.
• Performed data refreshes on schema, table, and database levels to prepare applications for testing or ensure data readiness.
• Executed health checks on platforms, proactively identifying and resolving performance or reliability issues.
• Applied security patches (patch sets, CPU, PSU) to databases, reducing vulnerabilities and ensuring compliance with security standards.
• Applied patches to OMS/Agent, maintaining up-to-date monitoring and management tools.
• Performed database upgrades from 11g to 12c and 12c to 19c, ensuring seamless transitions and minimal service disruption.
• Installed and configured Oracle Enterprise Manager (OEM), including out-of-place OEM upgrades to enhance monitoring capabilities.
• Installed and set up two-node/three-node cluster RAC Oracle 19c databases with GRID infrastructure on ASM storage, increasing system scalability.
• Cloned databases via RMAN using active duplicate, supporting development and testing environments with accurate data copies.
• Automated monitoring of database performance, backup, and recovery activities by running CRON jobs and customizing Unix shell scripts for alerts and reports.
• Planned, tested, and implemented backup strategies using RMAN, Oracle utilities (expdp/impdp), and OS methods to ensure data protection.
• Maintained sound backup and recovery policies using RMAN, monitoring scheduled backups daily with CRONTAB for reliability.
• Used import/export utilities and data pump to clone, migrate, and move data between 11g, 12c, and 19c environments.
• Created and granted user access, rights, and privileges, managing roles and profiles to maintain database security.
• Developed PL/SQL packages, DML, DDL, tables, stored procedures, functions, cursors, triggers, and UNIX shell scripts to support business requirements.
• Tuned complex queries using statistics, indexes, and profiling tools to optimize SQL execution plans and improve performance.
• Implemented database auditing to track activities and ensure compliance with security policies.

Oracle DBA - Cobb County Commissioner (Govt) - Marietta, GA

(2018-01 - 2018-12)

• Demonstrated and applied knowledge of data warehousing architectural approaches, including virtual data warehousing, to support analytics initiatives.
• Installed, patched, and upgraded Oracle databases to support internal production and test environments, ensuring system stability and security.
• Designed and implemented incremental level 1 and 0 backup policies and procedures, improving data protection and recovery capabilities.
• Designed data dictionaries and physical/logical database models, supporting efficient data management and system documentation.
• Performed performance tuning and logical administration of application objects, enhancing system responsiveness and reliability.
• Provided business and data requirements for storage capacity planning, ensuring scalability and future growth.
• Installed, set up, and created two-node cluster RAC Oracle 11g/12c databases using GRID infrastructure with ASM file systems on RHEL 6 and 7, increasing availability.
• Installed, patched, and upgraded Oracle 10g, 11g, and 12c databases to support production and test environments, maintaining up-to-date systems.
• Created physical standby databases using RMAN with zero downtime, performing failover and switchover using Data Guard broker and manual methods.
• Installed Oracle GoldenGate on RHEL and set up table-level and DDL replication, supporting real-time data integration.
• Configured physical standby databases with Oracle 11g/12c RAC, enhancing disaster recovery and business continuity.
• Installed and configured Oracle GoldenGate in development environments, enabling robust data replication solutions.
• Installed and configured Oracle GoldenGate Director, Client, and Monitor, improving management and monitoring of replication processes.
• Collaborated with developers to set up SQL translation and conflict resolution in Oracle GoldenGate, ensuring data consistency.
• Provided database support to project teams, ensuring databases were updated for new applications and requirements.
• Automated data replication processes using materialized views for reporting databases, increasing efficiency and data accuracy.
• Replicated data with materialized views using complete and fast refresh methods, supporting timely reporting and analytics.

Oracle DBA - NCR

(2017-04 - 2017-12)

• Configured ASM disks and disk groups for RAC and standalone/two-node databases, establishing TAF policies to enhance reliability and failover capabilities.
• Demonstrated thorough knowledge in setting up infrastructure for databases in large data centers, ensuring scalability and high availability.
• Installed, set up, and created two-node cluster RAC Oracle 11g/12c databases using GRID infrastructure with ASM file systems on RHEL, improving system performance.
• Installed, patched, and upgraded Oracle 10g, 11g, and 12c databases to support production and test environments, maintaining system security and stability.
• Created physical standby databases using RMAN with zero downtime, performing failover and switchover using Data Guard broker and manual methods.
• Installed Oracle GoldenGate on RHEL and set up table-level and DDL replication, enabling real-time data synchronization.
• Configured physical standby database environments for Oracle 11g/12c RAC systems, enhancing disaster recovery capabilities.
• Researched and recommended Oracle GoldenGate for migration and replication, supporting strategic technology decisions.
• Installed and configured Oracle GoldenGate in development environments, enabling robust data replication solutions.
• Installed and configured Oracle GoldenGate Director, Client, and Monitor, improving management and monitoring of replication processes.
• Authored installation and usage documentation for Oracle GoldenGate and utilities, supporting knowledge transfer and operational consistency.
• Collaborated with developers to set up SQL translation and conflict resolution in Oracle GoldenGate, ensuring data consistency.
• Worked with Oracle support for technical tickets, application research, and licensing, resolving issues and maintaining compliance.
• Performed database refreshes using export/import and data pump, supporting development and testing with up-to-date data.
• Utilized ASH, ADDM, and AWR reports to monitor and optimize database performance, identifying and resolving bottlenecks.
• Implemented automatic shared memory management (ASMM) and automatic segment space management (ASSM) for performance diagnosis and tuning.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, STASPAACK, SQL Trace, and EXPLAIN PLAN to optimize performance.
• Supported development efforts by tuning SQL statements, procedures, and removing performance bottlenecks using tools like TOAD and Oracle Enterprise Manager (OEM).
• Maintained Oracle 12c Real Application Cluster (RAC) databases for high availability, scalability, and performance by optimizing cluster architecture and hardware configuration.

Bachelor's degree - Computer Science - Abia State University