AWS Data DBA: Redshift/RDS, Open Data Portal

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

Job summary

Synectics for Management Decisions, Inc. is seeking a Database Administrator to operate and maintain a hybrid cloud data environment for a federal government client in the Washington, DC area.

The role focuses on AWS pipelines, Redshift, RDS, SQL, and data catalog management (CKAN), with emphasis on security, reliability, and timely publication of datasets. Hybrid options are available and clearance is a consideration.

Qualifications

• 3–7 years administering Amazon Redshift or RDS or comparable data stores.
• Experience with backup/restore, tuning, patching, and performance optimization.
• Government/regulatory environment experience with SLA-driven deliverables.

Responsibilities

• Operate and maintain AWS-based workflows (Lambda, Glue, Step Functions, Redshift, RDS).
• Perform ongoing database administration: tuning, patching, backup/restore.
• Manage an open data portal and data catalog (CKAN) for dataset publication.
• Monitor platform health, logging, and alerts; triage and respond to incidents.
• Maintain SOPs, runbooks, and operational documentation regularly.
• Provide end-user support and training on database access and data usage tools.
• Deliver SLA performance reports on pipeline success, incidents, and data availability.

Skills

AWS

SQL

Python scripting

Redshift

RDS PostgreSQL/SQL Server

Data warehousing

Tools

CKAN

Job description

Synectics for Management Decisions, Inc. is seeking a Database Administrator to operate and maintain a hybrid cloud data environment for a federal government client in the Washington, DC area.

The role focuses on AWS pipelines, Redshift, RDS, SQL, and data catalog management (CKAN), with emphasis on security, reliability, and timely publication of datasets. Hybrid options are available and clearance is a consideration.