Remote Senior DBA - PostgreSQL & MySQL on AWS RDS

Eliassen Group; United States; Remote; USD 83,000 - 90,000; Full time

Benefits offered by this job

Medical, Dental, Vision benefits

401k with company matching

Life insurance

Job summary

Eliassen Group is seeking a Senior DBA to support database operations and design improvements for online and batch applications serving a Federal Office of Child Support Enforcement program. You will optimize PostgreSQL/MySQL on Amazon RDS, automate deployments, manage upgrades and recovery, and drive performance enhancements while coordinating with cross-functional teams.

The role requires US citizenship or permanent residency with active Public Trust clearance.

Qualifications

• Experience with PostgreSQL/MySQL on AWS RDS.
• Experience with AWS services including Lambda, Lake Formation, QuickSight, DynamoDB, Redshift, MSK/Kafka, Kinesis, ElastiCache, OpenSearch.
• Containerization experience with Docker/Kubernetes for PostgreSQL/MySQL workloads on ECS/EKS or via RDS Proxy.
• Experience supporting Java and PySpark applications.
• Experience developing and executing Ansible scripts.

Responsibilities

• Analyze requirements to propose database solutions for online and batch systems.
• Coordinate with cross-functional teams to define system requirements and data flows.
• Design and deploy scalable PostgreSQL and MySQL solutions on Amazon RDS.
• Create, deploy and maintain database scripts, stored procedures, and views using Python, Shell, Ansible, and CloudFormation.
• Manage database operations including upgrades, restores, schema changes, and failover.
• Communicate database changes with management, developers and users.
• Assess capacity and performance, including right-sizing RDS and storage autoscaling.
• Maintain data architecture artifacts and security controls.
• Maintain and test backup and recovery strategies.
• Perform troubleshooting and root cause analysis.
• Monitor health and resources with CloudWatch Database Insights.

Skills

SQL

Performance tuning

Java

PySpark

Team collaboration

Tools

PostgreSQL

MySQL

Amazon RDS

Docker

Kubernetes

Ansible

Python

Job description

Eliassen Group is seeking a Senior DBA to support database operations and design improvements for online and batch applications serving a Federal Office of Child Support Enforcement program. You will optimize PostgreSQL/MySQL on Amazon RDS, automate deployments, manage upgrades and recovery, and drive performance enhancements while coordinating with cross-functional teams.

The role requires US citizenship or permanent residency with active Public Trust clearance.