Senior Cloud Database Engineer (Redshift/PostgreSQL)

Xpect Solutions, Inc.; Washington, Northern (District of Columbia, KY); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical/Dental/Vision plan

Retirement Savings Plan

Life Insurance

AD&D Insurance

Disability Insurance

3 weeks of annual PTO

11 days of Holiday PTO

Performance Awards

Referral Bonus Plan (up to $5,000/year

Education Reimbursement/Training (up到$

Job summary

XPECT Solutions, LLC seeks a highly skilled Data Engineer/DBA to maintain and optimize cloud-based data warehouses (Redshift, PostgreSQL/Aurora) and BI query performance. You will enforce security, lead modern data architecture modernization, and partner with engineers to resolve complex data integration challenges.

Responsibilities include provisioning cloud data stores, tuning performance, migrating data, and building automation for deployments and health checks.

Qualifications

• 8+ years in database development and administration, with 4+ years on cloud platforms.
• Expert in Amazon Redshift and PostgreSQL/Aurora administration.
• Experience with ETL targets and orchestration: Airflow, AWS Glue, or similar.
• Advanced SQL, query tuning, stored procedures, and schema optimization.
• Scripting in Python or Bash for automation; knowledge of cloud security and HA/DR.

Responsibilities

• Lead provisioning and lifecycle management of cloud-native analytical data stores.
• Monitor performance, optimize database parameters, and optimize queries for BI.
• Oversee migration and synchronization of data into modern cloud repositories.
• Develop automation scripts for schema deployments, migrations, health checks.
• Collaborate with data engineers and software architects to improve data models.

Skills

Top Secret Clearance

Database Development

Cloud Databases (AWS)

Amazon Redshift

PostgreSQL / Aurora

SQL Mastery

ETL & Orchestration

Python

Bash

Automation Scripting

Tools

Apache Airflow

AWS DMS

Terraform

CloudFormation

AWS Glue

Job description

XPECT Solutions, LLC seeks a highly skilled Data Engineer/DBA to maintain and optimize cloud-based data warehouses (Redshift, PostgreSQL/Aurora) and BI query performance. You will enforce security, lead modern data architecture modernization, and partner with engineers to resolve complex data integration challenges.

Responsibilities include provisioning cloud data stores, tuning performance, migrating data, and building automation for deployments and health checks.