Remote Senior DBA: PostgreSQL/MySQL on AWS (Contract)

Eliassen Group; Phoenix (AZ); Remote; USD 83,000 - 90,000; Full time

Job summary

Eliassen Group is seeking a Senior DBA to support database operations for a federal program. You will design and optimize PostgreSQL and MySQL on Amazon RDS, automate deployments, and coordinate with cross-functional teams to improve performance and capacity. The role requires U.S.

citizenship or permanent residency with an active Public Trust clearance. W2 and corp-to-corp options are available; benefits include medical, dental, vision, 401k with match, and life insurance.

Qualifications

• Experience creating and administering AWS Glue databases and Athena tables.
• Experience with AWS services such as Lambda, Lake Formation, QuickSight, DynamoDB, Redshift, MSK/Kafka, Kinesis, ElastiCache, and OpenSearch.
• Experience with containerization such as Docker or Kubernetes, including PostgreSQL and MySQL workloads on Amazon ECS or Amazon EKS, or via RDS Proxy.
• Experience supporting Java and PySpark applications.
• Experience developing and executing Ansible scripts.

Responsibilities

• Analyze business and technical requirements to propose database solutions for online and batch Java-based and AWS Glue/Apache Spark-based systems, including troubleshooting deadlocks, long-running transactions, and connection pool or isolation level issues.
• Coordinate with business and technology teams to define system requirements, data flows, and testing support for database components.
• Design and deploy scalable, high-performance PostgreSQL and MySQL solutions on Amazon RDS, and recommend schema and data model improvements.
• Create, deploy, and maintain database scripts, stored procedures, tables, triggers, and materialized views, using automation and scripting with Python, Shell, Ansible, and AWS CloudFormation.
• Manage database operations with minimal oversight including configuration, upgrades including blue/green, restores with pg_dump and pg_restore, schema changes, user and password management, failover, disaster recovery, and replication.
• Communicate and coordinate database changes and operations with management, developers, and users.
• Assess and improve capacity and performance, including capacity planning, right-sizing RDS instances, storage autoscaling, and resource forecasting.
• Maintain a central repository of data architecture artifacts including data dictionaries, procedures, scripts, and security controls.
• Maintain and test backup and recovery strategies for applications and databases.
• Perform troubleshooting, root cause analysis, and issue resolution.
• Monitor database health, transactions, and resource utilization using tools such as Amazon CloudWatch Database Insights.

Skills

Java

PySpark

Ansible

Docker/Kubernetes

AWS Glue/Athena

Tools

AWS ECS/EKS

Amazon RDS

CloudWatch

Lambda/Lake Formation/QuickSight

OpenSearch

Job description

Eliassen Group is seeking a Senior DBA to support database operations for a federal program. You will design and optimize PostgreSQL and MySQL on Amazon RDS, automate deployments, and coordinate with cross-functional teams to improve performance and capacity. The role requires U.S.

citizenship or permanent residency with an active Public Trust clearance. W2 and corp-to-corp options are available; benefits include medical, dental, vision, 401k with match, and life insurance.