Database Administrator

Synectics for Management Decisions Inc; Washington (District of Columbia); Hybrid; USD 150,000 - 165,000; Full time

Benefits offered by this job

Hybrid work options

Job summary

Synectics for Management Decisions Inc in the Washington, DC area is seeking a Database Administrator to operate and maintain a hybrid cloud data environment for a federal government client, focusing on AWS pipelines, Redshift, and an open data portal.

The role entails hands-on DBA work, performance tuning, incident response, and collaboration with cross-functional teams to publish datasets and support new visualizations while ensuring security and SLA adherence.

Qualifications

• 3–7 years of experience administering data stores like Redshift or RDS
• Proficient SQL and scripting (Python) for automation
• Experience with data warehouses and performance tuning
• Experience in government or regulated environments with SLA deliverables

Responsibilities

• Operate and maintain AWS workflows (Lambda, Glue, Step Functions, Redshift, RDS Postgres, SQL, S3)
• Perform ongoing database administration: tuning, patching, backup/restore, and general maintenance
• Manage open data portal/CKAN; publish datasets and support new visualizations
• Monitor platform health, logging, and alerts; incident triage and response
• Maintain and update SOPs, runbooks, and operational documentation
• Provide end-user support and training on database access and data tools
• Deliver SLA performance reports on pipeline success, incidents, data availability

Skills

Amazon Redshift administration

RDS PostgreSQL/SQL Server admin

SQL proficiency

Python scripting for automation

Gov/regulatory environment experience

Tools

CKAN

AWS

Job description

Position Summary

We're hiring a Database Administrator to operate and maintain a hybrid cloud data environment for a federal government client - AWS pipelines, relational databases, and a public-facing open data portal - ensuring stability, reliability, and security of production systems. Job location is the Washington, DC Metro Area. Hybrid options can be considered. Position is contingent upon contract award.

Key Responsibilities

• Operate and maintain established AWS-based workflows (Lambda, Glue, Step Functions, Redshift, RDS Postgres, SQL, S3, and related data services)


• Perform ongoing database administration: tuning, patching, backup/restore, and general maintenance


• Manage an open data portal and data catalog (e.g., CKAN); ensure accurate, timely dataset publication and support new visualizations


• Monitor platform health, logging, and alerts; perform initial incident triage and response


• Maintain and update SOPs, runbooks, and operational documentation on a regular cadence


• Provide end-user support and training on database access, credentials, and data usage tools


• Deliver regular SLA performance reports covering pipeline success rates, incident summaries, data availability, and operational metrics

Required Qualifications

• 3–7 years administering Amazon Redshift, RDS (PostgreSQL or SQL Server), or comparable managed data stores


• Experience with routine DBA tasks: backup/restore, tuning, patching, and performance optimization


• Experience supporting production data warehouses and resolving performance issues


• Experience designing or maintaining relational schemas, indexes, and partition strategies


• Proficiency in SQL; familiarity with Python or similar scripting for operational automation


• Experience in a government or regulated environment with SLA-driven deliverables

Preferred Experience

• Experience with federal government data projects.

Preferred Certifications

• AWS Certified SysOps Administrator – Associate


• AWS Certified Data Engineer – Associate


• AWS Certified Security – Specialty

Additional Requirements

• Must be able to pass a federal background investigation prior to starting work and maintain eligibility throughout the engagement.


• Salary range for this position is $150,000.00 - $165,000.00.


• Work Authorization: At this time, we are unable to sponsor new H-1B visas or other employment-based visa petitions for this position. Candidates must be authorized to work in the United States without current or future employer sponsorship.

Why Join Us?

Join a collaborative team supporting high-impact federal programs that incorporate innovative technology solutions. You\'ll have the opportunity to lead complex modernization initiatives, work alongside talented technical professionals, and help shape the future of government IT and data management.

Synectics is an equal opportunity employer.