Lead Oracle Database Architecture Engineer

Socket.dev; Taylor (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

XTIVIA is seeking a senior, hands-on Oracle Database Architecture Engineer to lead POC and migration efforts in the Taylor, TX area. You will drive technical validation, architecture design, and near-zero downtime migrations for a Data Modernization program, with on-site work during POC and hybrid later.

The role requires deep Oracle 19c expertise, converged infrastructure, and experience with NERC CIP security controls.

Responsibilities

• 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 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 (RMAN Active Duplication, Oracle GoldenGate, Data Guard) to migrate mission-critical databases with minimal maintenance windows.
• Develop granular runbooks, rollback procedures, and cutover checklists for production migration.
• Implement Ansible automation for Oracle installs/RAC/ASM/DG, etc.
• Architect, HA/DR planning and disaster recovery benchmarking.

Job description

Description

XTIVIA - Lead Oracle Database Architecture Engineer (POC & Migration Specialist)

Work Location: 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.

Employment Type: Contract / Contract-to-Hire

Travel & On-site Requirements: 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.

Clearance / Compliance: Must successfully pass required background checks and complete NERC CIP compliance onboarding before starting.

Contract Length: 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.

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

How you will make a difference
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.

Responsibilities:

Architecture & POC Leadership:

• 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.

Migration Planning & Execution:

• Design and execute data migration strategies (e.g., RMAN Active Duplication, Oracle GoldenGate, 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,