Senior DBA - Remote AWS RDS PostgreSQL/MySQL Expert

Eliassen Group; Lincoln (NE); Remote; USD 83,000 - 90,000; Full time

Benefits offered by this job

Medical, dental, and vision benefits

401k with company match

Life insurance

Job summary

Eliassen Group is seeking a Senior DBA for a remote contract role serving a Federal Office of Child Support Enforcement program. You will design and optimize PostgreSQL and MySQL on Amazon RDS, automate deployments with Python, Shell, Ansible, and CloudFormation, and coordinate with cross-functional teams to ensure reliable database operations.

Candidates must have US citizenship or permanent residency with an active Public Trust clearance.

Qualifications

• AWS Glue
• Athena
• Lambda
• Lake Formation
• QuickSight
• DynamoDB
• Redshift
• Kafka
• Kinesis
• OpenSearch
• Docker
• Kubernetes
• ECS
• EKS
• RDS Proxy
• Java
• PySpark
• Python
• Shell
• Ansible

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 and long-running transactions.
• Coordinate with business and technology teams to define system requirements, data flows, and testing support for database components.
• Design and deploy scalable 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 Python, Shell, Ansible, and AWS CloudFormation.
• Manage database operations with upgrades (blue/green), restores with pg_dump/pg_restore, schema changes, user management, failover, disaster recovery, and replication.
• Communicate database changes with management, developers, and users.
• Assess and improve capacity and performance, including right-sizing RDS instances, storage autoscaling, and resource forecasting.
• Maintain a central repository of data architecture artifacts and security controls.
• Maintain and test backup and recovery strategies for applications and databases.
• Perform troubleshooting and root cause analysis.
• Monitor database health and resource utilization using Amazon CloudWatch Database Insights.

Job description

Eliassen Group is seeking a Senior DBA for a remote contract role serving a Federal Office of Child Support Enforcement program. You will design and optimize PostgreSQL and MySQL on Amazon RDS, automate deployments with Python, Shell, Ansible, and CloudFormation, and coordinate with cross-functional teams to ensure reliable database operations.

Candidates must have US citizenship or permanent residency with an active Public Trust clearance.