Job Description
Company: Systems Development and Analysis
Location: Ashburn, VA / Hybrid / Remote
Workplace Type: Hybrid
Employment Type: Full-time
About the Role
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.
What You’ll Do / Key Responsibilities
- Oracle Database Administration: Administer production Oracle databases (19c or later) including installation, configuration, patching, upgrades, and RMAN backup and recovery.
- High-Availability & Performance: Configure and maintain high-availability and disaster-recovery architectures (Data Guard, RAC, ASM) and diagnose/resolve performance issues through execution plan analysis and SQL tuning.
- Cloud Migration: Plan and execute the migration of Oracle schemas and workloads to managed cloud PostgreSQL, including data type mapping, PL/SQL conversion, and cutover sequencing using tools like GoldenGate, AWS DMS/SCT, or Ora2Pg.
- Postgres Tuning & Support: Administer and tune PostgreSQL in the cloud post-migration, optimizing vacuum/autovacuum strategy, connection pooling, replication, and parameters.
- ETL & Data Pipelines: Build, support, and troubleshoot ETL/ELT pipelines moving operational data into Databricks and Delta Lake for analytics consumption.
- Data Architecture & Governance: Perform logical and physical data modeling, implement database security controls (encryption, RBAC, auditing), and apply federal security hardening requirements (DISA STIGs, NIST 800-53).
Requirements & Qualifications
- U.S. Citizenship required; must be able 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 (or equivalent experience substitution).
- Eight (8) or more years of hands-on database administration experience in production environments (Senior level); five years considered for Mid level.
- Demonstrated depth in Oracle administration (backup/recovery, tuning, HA) or equivalent depth in another enterprise RDBMS at comparable scale.
- Advanced SQL proficiency and working knowledge of PL/SQL or equivalent procedural language.
- Demonstrated experience migrating, replicating, or synchronizing large datasets between systems.
- Scripting proficiency for automation using Python, Bash, or equivalent.
Preferred / Bonus Qualifications (if applicable)
- PostgreSQL administration, particularly managed cloud offerings (Amazon RDS/Aurora, Azure Database for PostgreSQL, or Cloud SQL).
- Experience with Databricks, Apache Spark, and Delta Lake.
- Hands-on experience with Oracle-to-PostgreSQL migration tooling (GoldenGate, AWS DMS/SCT, Ora2Pg).
- Experience with CI/CD tools (Liquibase, Flyway) and infrastructure as code (Terraform, Ansible).
- Prior work in a FedRAMP, GovCloud, or federal cloud environment supporting agencies like DHS or CBP.
Systems Development and Analysis, Inc. (SDA) is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.