Database Administrator (Senior

Oracle to Cloud PostgreSQL & Databricks Migration

Location: Ashburn, VA / Hybrid / Remote

Employment Type: Full-Time

Clearance: U.S. Citizenship required
; must be able to obtain and maintain a CBP Investigation (BI)

We are seeking a Database Administrator to support a federal client through a significant modernization effort. Today the environment is a production Oracle estate; over the life of this program, substantial portions of it are moving to managed cloud PostgreSQL and to Databricks for analytics. This is not a steady-state caretaker role. You will keep the existing Oracle systems healthy and performant while simultaneously planning, executing, and validating the movement of that data into the cloud.

The ideal candidate is, above all, exceptionally good with data. We care that you can reason rigorously about data structure, integrity, movement, and performance. The specific engines are learnable; that judgment is not. Deep Oracle experience is what the current environment demands, and PostgreSQL and Databricks are where it is going, so exposure to all three is ideal. Strong candidates who are missing one of them are still encouraged to apply.

This requisition is approved at the Senior level. For an exceptional candidate, we are willing to fill it at the Mid level.

• Administer production Oracle databases (19c or later): installation, configuration, patching, and upgrades
• Own backup and recovery using RMAN; design, document, and regularly test restore procedures
• Configure and maintain high-availability and disaster-recovery architectures, including Data Guard, RAC, and ASM
• Diagnose and resolve performance problems through execution plan analysis, AWR/ASH review, indexing and partitioning strategy, and SQL tuning
• Perform capacity planning, storage management, and proactive monitoring and alerting
• Plan and execute the migration of Oracle schemas and workloads to managed cloud PostgreSQL, including data type mapping, PL/SQL conversion, and cutover sequencing
• Evaluate and apply migration tooling such as Golden Gate, AWS DMS/SCT, or Ora2
  
  Pg, and recommend the right approach per workload
• Design and execute reconciliation and validation between source and target — row counts, checksums, referential integrity, and business-rule verification — so that every cutover is provably correct
• Develop rollback plans and minimize downtime windows for production cutovers
• Administer and tune PostgreSQL in the cloud post-migration: vacuum and autovacuum strategy, connection pooling, replication, and parameter tuning
• Build, support, and troubleshoot ETL/ELT pipelines moving operational data into Databricks and Delta Lake for analytics consumption
• Partner with data engineering on ingestion patterns, incremental and change-data-capture loads, and partitioning and file layout for query performance
• Monitor pipeline health, resolve data quality issues at the source, and maintain data lineage documentation
• Perform logical and physical data modeling; review and advise on schema changes proposed by application teams
• Implement database security controls: encryption at rest and in transit, role-based access control, auditing, and data masking for non-production environments
• Apply and maintain federal security hardening requirements, including applicable DISA STIGs and NIST 800-53 controls
• Produce runbooks, migration playbooks, architecture diagrams, and documentation supporting ATO and audit artifacts
• Support incident response and root cause analysis for data-related production issues

• U.S. Citizenship (required — no exceptions, per contract)
• Ability to obtain and maintain a U.S. Customs Background Investigation (BI)
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical field
• Eight (8) or more years of hands‑on database administration experience in production environments (Senior level);
  Five (5) or more years will be considered for the Mid level
• Demonstrated depth in Oracle administration — backup and recovery, performance tuning, and high availability — or equivalent depth in another enterprise RDBMS at comparable…