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. The ideal candidate is, above all, exceptionally good with data, able to reason rigorously about data structure, integrity, movement, and performance.
What You’ll Do / Key Responsibilities
- Oracle Database Administration: Administer production Oracle databases (19c or later) including installation, configuration, patching, and upgrades; own backup and recovery using RMAN; configure high-availability architectures like Data Guard, RAC, and ASM.
- Performance Tuning: Diagnose and resolve performance problems through execution plan analysis, AWR/ASH review, indexing/partitioning strategies, 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, cutover sequencing, and utilizing migration tooling such as GoldenGate, AWS DMS/SCT, or Ora2Pg.
- 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, data masking), and apply federal security hardening requirements (DISA STIGs and NIST 800-53 controls).
- PostgreSQL Administration: Administer and tune PostgreSQL in the cloud post-migration, including vacuum and autovacuum strategy, connection pooling, replication, and parameter tuning.
Requirements & Qualifications
- U.S. Citizenship required (no exceptions, per contract) with the 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 (or equivalent experience via degree substitutions).
- Eight (8) or more years of hands-on database administration experience in production environments (Senior level); five (5) or more years considered for the Mid level.
- Demonstrated depth in Oracle administration (backup/recovery, performance tuning, high availability) or equivalent depth in another enterprise RDBMS at scale.
- Advanced SQL skills, including the ability to read and interpret execution plans, with working proficiency in PL/SQL.
- 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.
- Orchestration and transformation tooling: Airflow, dbt, AWS Glue, Azure Data Factory, Informatica, or NiFi.
- Database change management and CI/CD tools like Liquibase or Flyway, plus infrastructure as code (Terraform, Ansible).
- Prior work in a FedRAMP, GovCloud, or other federal cloud environment.
- Relevant certifications such as Oracle Certified Professional (OCP), AWS/Azure database specialty, or Databricks Certified Data Engineer.
Benefits & Perks (if applicable)
- Competitive compensation and professional growth opportunities within federal IT modernization initiatives.
Systems Development and Analysis 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.