Senior Cloud Data Architect — Redshift & PostgreSQL

SMX; Washington (District of Columbia); On-site; USD 96,000 - 161,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement

Job summary

SMX in Washington, DC on site, seeks a Senior Cloud Database Developer to lead health, performance, security of the FFD Data Warehouse and cloud DB ecosystems (Redshift, Aurora). You will drive architectures and ensure mission-critical availability for BI workloads.

This role requires active Top Secret clearance and 8+ years in database development; 4+ years on AWS. You will collaborate with Data Engineers and Analysts to optimize queries and enforce security.

Qualifications

• 8+ years in database development and administration.
• 4+ years on cloud DB platforms (AWS preferred).
• Expertise in Redshift and PostgreSQL/Aurora administration.
• Experience migrating to cloud data stores and using DMS/Airflow.
• Active Top Secret clearance.

Responsibilities

• Lead provisioning, performance tuning, and lifecycle management of cloud analytical data stores (Redshift, Aurora).
• Refactor SQL, optimize queries, and design partitioning/distribution strategies for BI reporting tools like WebFOCUS.
• Oversee migration, replication, and synchronization of legacy data assets using AWS DMS and Airflow.
• Write automation scripts (Python/Bash, IaC with Terraform/CloudFormation) for deployments and maintenance.
• Collaborate with Data Engineers and Analysts to review schemas and enforce data modeling best practices.

Skills

AWS Redshift

PostgreSQL / Aurora

SQL Mastery

Python / Bash

DevSecOps

Data architecture

Tools

Apache Airflow

Terraform/CloudFormation

AWS DMS

WebFOCUS

Job description

SMX in Washington, DC on site, seeks a Senior Cloud Database Developer to lead health, performance, security of the FFD Data Warehouse and cloud DB ecosystems (Redshift, Aurora). You will drive architectures and ensure mission-critical availability for BI workloads.

This role requires active Top Secret clearance and 8+ years in database development; 4+ years on AWS. You will collaborate with Data Engineers and Analysts to optimize queries and enforce security.