Lead Oracle Database Architecture Engineer

Description

On-site in the Taylor, TX area during the Proof of Concept (POC) and core migration phases. Hybrid remote during interim planning and steady-state project phases.

Contract / Contract-to-Hire

100% on-site during the initial 3-month Proof of Concept (POC). Additional on-site presence will be required throughout the project for hardware and platform validation, testing, and cutover activities.

Must successfully pass required background checks and complete NERC CIP compliance onboarding before starting.

This position is initially scoped for the 3-month POC. Upon successful completion of the POC and achievement of the defined pass/fail criteria, the project is expected to continue for an additional 12-18 months in a hybrid remote/on-site capacity.

U.S. Citizens only. This position is subject to client and regulatory requirements.

We are seeking a senior, hands-on Oracle Database Architecture Engineer to lead the technical validation, architecture design, Proof of Concept (POC), and migration execution for Data Modernization and Platform Refresh program.

In this role, you will be physically on-site at primary facilities to benchmark high-availability architectures, configure 2-node RAC with ASM and Active Data Guard across multi-site data centers, and execute near-zero downtime database migrations. The ideal candidate has deep expertise in Oracle 19c and converged infrastructure, Advanced Security and NERC CIP security controls, and cross-site disaster recovery benchmarking.

This is not a management position. This is a highly hands-on role where you will serve as the lead field engineer responsible for implementing the solution and executing all migrations, supported by a team of Oracle DBAs.

• Lead and implement the physical and logical configuration of the target Oracle Database platform (RAC, ASM, Data Guard) during the initial Proof of Concept (POC) phase.
• Conduct workload characterization, workload stress testing, and failover validation across Primary and Disaster Recovery (DR) data centers meeting migration objectives.
• Evaluate storage throughput, inter-node latency, and network interconnect performance to validate platform SLAs.

• Design and execute data migration strategies (e.g., RMAN Active Duplication, Oracle Golden Gate, or Data Guard) to migrate mission-critical databases with minimal maintenance windows.
• Develop granular runbooks, rollback procedures, and cutover checklists for the production migration phase.
• Implement Ansible automation where possible, such as Oracle installs/Rac/ASM/DG/DG Broker,ect.
• High Availability & Disaster Recovery (HA/DR):
• Architect, build, and test 2-node Real Application Clusters (RAC) utilizing Automatic Storage Management (ASM) and Oracle Grid Infrastructure.
• Mastery of synchronous/asynchronous redo transport (Maximum Performance mode), broker configuration, automated health validation, and executing zero-data-loss database switchovers under a strict 5-minute SLA window.
• Implement and validate Oracle Active Data Guard (FSFO/Far Sync) connecting primary and secondary data center sites.

• Enforce NERC CIP database security standards, TDE (Transparent Data Encryption), Unified Auditing, and strict access controls across test, staging, and production environments.
• Experience with CIS benchmark health checks/DBSAT and remediation efforts for Oracle 19c environments on Linux.
  
  Author technical design documents, architectural diagrams, and operational handoff playbooks for permanent Operations team enablement.

• Construct detailed runbooks for RAC/ASM , Data Guard setup and DG Broker architected solutions.
• Construct detailed runbooks for TDE and Database Vault solutions for enhanced security features.
• Create documentation evidencing the security features enabled and configured in accordance with CIS Benchmark Level 1 and NERC CIP requirements.
• Transfer knowledge of the solutions to Oracle DBA teams at XTIVIA and client DBAs.
• Ability to provide on-site client knowledge transfer sessions covering Oracle Enterprise Manager (OEM) 24ai and Oracle Data Guard failover and switchover scenarios.

• 15+ years of enterprise Oracle Database Administration and Architecture experience, preferably within mission-critical utility, energy, or grid-operator environments.

• Oracle Database 19c Oracle Certified Professional (OCP) certification.

• Expert-level mastery of multi-tenant Oracle Database 19c (Oracle 26ai exposure preferred).
• Deep experience with Oracle Grid Infrastructure, 2-node RAC, ASM disk group configuration and tuning, Active Data Guard, Data Guard Broker, Fast-Start Failover (FSFO), and…