> Markdown version of [/jobs/ext/1957060-lead-oracle-database-architecture-engineer](https://www.wearedevelopers.com/jobs/ext/1957060-lead-oracle-database-architecture-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Oracle Database Architecture Engineer - **Company:** XTIVIA, Inc. - **Location:** Taylor, TX, United States - **Experience:** Expert - **Salary:** $249,600.0 - **Contract:** Contract - **Skills:** Backup Devices, Databases, Data Centers, Data Transformation, Data Migration, Data Recovery, Database Security, Oracle Data Guard, Linux, Disaster Recovery, Failover, Node.Js, Oracle Databases, Oracle (Applications), Oracle Rac, Performance Tuning, Red Hat Enterprise Linux, Migration Manager, Ansible, Recovery Manager (RMAN), Runbook, Shell Script, Data Storage Management, Performance Testing, Oracle Enterprise Manager, Microservices - **Published:** August 6, 2026 - **Apply:** https://www.ultimatejobs.com/jobs/582590315/apply ## About the Role What you bring to your new team Experience: * 15+ years of enterprise Oracle Database Administration and Architecture experience, preferably within mission-critical utility, energy, or grid-operator environments. Certification: * Oracle Database 19c Oracle Certified Professional (OCP) certification. Core Oracle Stack: * 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 geographically dispersed data centers. * Experience orchestrating live Data Guard switchover drills to validate replication integrity and synchronization safety. * Advanced hands-on experience with Oracle GoldenGate 21c Microservices, including Hub configuration, unidirectional Extract and Replicat processes, and trail file/transport encryption. * Advanced Oracle performance tuning experience utilizing Diagnostics and Tuning Packs. Migration Expertise: * Demonstrated success leading large-scale Oracle database migrations using RMAN, GoldenGate, and Data Guard. * Proven hands-on experience writing migration runbooks and executing production go-live migrations with maintenance windows of 5 minutes or less. Operating Systems & Infrastructure: * Proficiency with Linux (RHEL/OEL 8/9), shell scripting, UDEV/ASMFD storage mapping, Jumbo Frames/interconnect network tuning, and kernel/HugePages optimization. Backup & Recovery: * Expert-level RMAN knowledge and advanced experience with Rubrik backup management. * Understanding of backup storage capacity planning to meet SLAs, including the impact of TDE and compression on storage requirements. On-Site Availability: * Ability to work 100% on-site at the client facility in Taylor, TX during the initial POC deployment, performance testing, and production go-live cutover events How you add even MORE value * Experience with high-performance SAN storage architectures. * Oracle Certified Master (OCM) or Oracle Certified Professional (OCP) - RAC/Grid Infrastructure/Data Guard. * Advanced experience integrating database automation using Ansible. * Experience with near-zero downtime Oracle 26ai upgrades in a 2-node RAC with Data Guard environment for mission-critical database instances. * Advanced database security skillset with hands-on experience with Oracle TDE and other security features. ## Description 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, 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. Compliance & Security: * 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. Knowledge Transfer: * 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. ## Related Videos - [Dev & Test in the Cloud? Deploy your cloud environments with Ansible & Terraform](https://www.wearedevelopers.com/videos/1607-dev-test-in-the-cloud-deploy-your-cloud-environments-with-ansible-terraform) - [Technical Documentation - How Can I Write Them Better and Why Should I Care?](https://www.wearedevelopers.com/videos/681-technical-documentation-how-can-i-write-them-better-and-why-should-i-care) - [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Eclipse Che for Infrastructure Automation](https://www.wearedevelopers.com/videos/1611-eclipse-che-for-infrastructure-automation) - [Bridging AI and Nomad: a Go-based MCP Server for Cluster Control](https://www.wearedevelopers.com/videos/2063-bridging-ai-and-nomad-a-go-based-mcp-server-for-cluster-control) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated)