Note: The job is a remote job and is open to candidates in USA. Systems Development and Analysis, Inc. (SDA) is seeking a Database Administrator to support a federal client through a significant modernization effort. The role involves maintaining existing Oracle systems while planning and executing the migration of data to managed cloud PostgreSQL and Databricks for analytics.
Responsibilities
• 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 GoldenGate, AWS DMS/SCT, or Ora2Pg, 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
Skills
• 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 scale
• Advanced SQL, including the ability to read and interpret execution plans
• Working proficiency in PL/SQL or an equivalent procedural database language
• Demonstrated experience migrating, replicating, or synchronizing large datasets between systems
• Scripting proficiency for automation (Python, Bash, or equivalent)
• Clear written and verbal communication, including the ability to explain technical tradeoffs to non-technical stakeholders
• PostgreSQL administration, particularly managed cloud offerings (Amazon RDS/Aurora, Azure Database for PostgreSQL, or Cloud SQL)
• Databricks, Apache Spark, and Delta Lake; familiarity with medallion (bronze/silver/gold) architecture
• Hands-on experience with Oracle-to-PostgreSQL migration tooling (GoldenGate, AWS DMS/SCT, Ora2Pg)
• Orchestration and transformation tooling: Airflow, dbt, AWS Glue, Azure Data Factory, Informatica, or NiFi
• Database change management and CI/CD (Liquibase or Flyway) and infrastructure as code (Terraform, Ansible)
• Prior work in a FedRAMP, GovCloud, or other federal cloud environment
• Experience supporting DHS, CBP, or comparable federal customers
• Familiarity with data warehousing and dimensional modeling concepts
• Relevant certifications: Oracle Certified Professional (OCP), AWS/Azure database specialty, or Databricks Certified Data Engineer
Company Overview
• Systems Development and Analysis provide big data and analytics services. It was founded in 1985, and is headquartered in Purcellville, Virginia, USA, with a workforce of 51-200 employees. Its website is https://www.systemsdev.com.
Apply To This Job