Chinemerem Dennis Okpajieagu

Marietta,MI

Summary

Oracle-focused Database Administrator with 8 years of experience designing, administering, and tuning enterprise Oracle environments, including Oracle 12c/19c, Exadata, RAC, ASM, Data Guard, RMAN, GoldenGate, and OEM/Cloud Control. Deep expertise in PL/SQL development and optimization, AWR/ADDM performance diagnostics, schema design, and ETL orchestration using ODI and Informatica. Extensive background supporting Oracle ERP and specialty platforms, including Ellucian Banner 9, Oracle EPM (Essbase), Epic Clarity, and AthenaIDX. Complementary experience administering SQL Server 2016-2022 with AlwaysOn Availability Groups, T-SQL tuning, and SSIS pipelines, along with PostgreSQL replication and high availability configurations. Operates across Azure, AWS, and Oracle Cloud environments. Holds Oracle Certified Professional (OCP) and CompTIA Security+ certifications

Overview

years of professional experience

Certification

Work History

Staff Database Administrator

RENESAS

SAN JOSE, CA

12.2021 - Current

Administered Oracle 19c RAC environments on Linux including ASM disk group management, cluster interconnect health monitoring, and OEM Cloud Control alerting across production and non-production tiers.
Maintained Oracle Data Guard physical standby configurations with Data Guard Broker, performing planned switchovers and failover drills to validate DR readiness against defined RTO and RPO targets.
Designed and executed RMAN backup strategies covering full, incremental-level 1, and archivelog backups with automated catalog maintenance; performed regular point-in-time recovery testing across critical schemas.
Tuned Oracle workloads using AWR, ADDM, and ASH to isolate top SQL, segment contention, and wait event bottlenecks; resolved latch contention and I/O hot spots improving batch job completion windows.
Built and maintained ODI and Informatica ETL pipelines orchestrating Change Data Capture and incremental loads from Oracle source systems into operational data stores and reporting environments.
Applied Oracle PSU/DBRU patches and Exadata storage cell firmware updates following documented rollback plans and change management procedures across all database tiers.
Enforced Oracle security using TDE tablespace encryption, Fine-Grained Auditing, Oracle Label Security, and RBAC privilege models aligned with HIPAA, SOX, and SOC 2 requirements.
Supported Oracle Banner 9 ERP environments including installation, patch application via Ellucian Solution Manager, DegreeWorks upgrades, and SSO configuration for higher-education clients.
Managed SQL Server 2019/2022 environments as a secondary platform, administering AlwaysOn Availability Groups, T-SQL query tuning, and SSIS packages for cross-platform data integration.
Administered PostgreSQL instances including role management, autovacuum tuning, WAL archiving, and logical replication setup for data synchronization across reporting environments.
Led Oracle incident response during on-call rotation using OEM diagnostics, alert log analysis, and trace file review to resolve production issues and document root cause findings.
Maintained data dictionaries, patching runbooks, DR procedures, and Oracle schema change logs supporting compliance audits and team knowledge continuity.

Oracle Database Administrator

ACCENTURE

ARLINGTON, VA

02.2018 - 12.2021

Managed 100-plus Oracle 12c/19c instances across development, test, and production using OEM Cloud Control, handling tablespace growth, segment advisory, and proactive health monitoring for enterprise clients.
Designed Oracle GoldenGate replication topologies for bidirectional synchronization between Oracle source and target systems, supporting zero-downtime migrations and continuous availability across data centers.
Performed deep PL/SQL tuning of stored procedures, packages, triggers, and functions using SQL Trace, tkprof, and 10053 event traces to reduce parse overhead and I/O load on high-volume OLTP environments.
Administered Oracle Exadata X7/X8 infrastructure including Smart Scan offloading, Hybrid Columnar Compression, storage server cell management, and InfiniBand network monitoring via OEM.
Maintained Oracle Data Guard Fast-Start Failover configurations across geographically distributed data centers, enabling automated switchover for mission-critical Oracle workloads with minimal manual intervention.
Supported Oracle EPM (Essbase) and AthenaIDX environments, performing schema tuning, cube backup configuration, and user security management for financial planning and clinical analytics teams.
Administered Epic Clarity data warehouse structures including performance tuning of clinical ETL jobs, schema management, and data extraction support for operational reporting workloads.
Built ODI integration workflows connecting Oracle EBS, Banner ERP, and downstream analytical databases, supporting institutional reporting pipelines and scheduled data delivery requirements.
Applied NIST SP 800-53, FISMA, and DoD STIG security controls across Oracle environments for federal and defense clients, producing and maintaining audit-ready compliance documentation.
Administered SQL Server AlwaysOn Availability Groups and SSIS packages as a secondary platform for clients running mixed Oracle and SQL Server environments requiring cross-platform data workflows.
Developed PowerShell and Shell scripts automating Oracle backup alerting, tablespace threshold notifications, and scheduled maintenance task execution across all managed Oracle instances.
Maintained ITIL-aligned change records, Oracle environment documentation, and rollback validation procedures in Jira and Confluence for all client engagements.

Education

Bachelor’s degree - computer science

University of Lagos

Nigeria

09.2018

Skills

Oracle Database and Performance: Oracle 12c/19c, RAC, ASM, Data Guard, RMAN, GoldenGate, OEM/Cloud Control, Exadata, Opatch, Oracle Vault, AWR, ADDM, ASH, SQL Trace, tkprof, Execution Plans, Index Partitioning, Optimizer Stats, Statspack, OEM Diagnostics
Oracle Applications and Specialty Platforms: Oracle APEX, EBS, Banner, Ellucian ESM, DegreeWorks, Oracle EPM (Essbase), Epic Clarity, AthenaIDX, Workday Adaptive Planning
ETL and Integration / Middleware: GoldenGate, Datapump, ODI, Informatica, SSIS, Azure Data Factory, CDC, Boomi, RESTful APIs, WebLogic, WebSphere, Kafka, IBM MQ
High Availability and Backup: Oracle Data Guard, RMAN, GoldenGate, Fast-Start Failover, AlwaysOn AG, Log Shipping, repmgr, PITR, Dataguard Broker

SQL Server and PostgreSQL: SQL Server 2016-2022, T-SQL, SSMS, SSIS, SSRS, AlwaysOn, PostgreSQL WAL, MVCC, Logical Replication, pgAdmin
Scripting and Automation / CI-CD: PL/SQL, T-SQL, PowerShell, Python, Shell, SQL Agent, Ansible, Terraform, Jenkins, GitLab CI, Git
Cloud and Infrastructure: Azure SQL, Azure VMs, AWS RDS, Oracle Cloud, Google Cloud, Linux, Windows Server, Active Directory, Virtualization
Security and Compliance: TDE, Oracle Label Security, Fine-Grained Auditing, RBAC, HIPAA, SOX, FERPA, NIST SP 800-53, FISMA, DoD STIGs, OCP