Senior DBA — Remote AWS PostgreSQL/MySQL on RDS

Eliassen Group; Carson City (NV); Remote; USD 83,000 - 90,000; Part time

Benefits offered by this job

Medical, Dental, Vision benefits

401(k) with company matching

Life insurance

Job summary

Our client, Eliassen Group, seeks a Senior DBA for a remote contract role to support database operations for a Federal Office program. You will design and optimize PostgreSQL and MySQL on Amazon RDS, automate deployments, and lead performance improvements while coordinating with cross-functional teams.

The role requires US citizenship or permanent residency with an active Public Trust clearance. W2 consulting options are available with comprehensive benefits and a strong focus on security and

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 using Docker or Kubernetes for PostgreSQL and MySQL workloads on AWS 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 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 automation and scripting with Python, Shell, Ansible, and AWS CloudFormation.
• Manage database operations including configuration, upgrades (blue/green), restores with pg_dump/pg_restore, schema changes, user management, failover, and disaster recovery.
• Communicate and coordinate database changes with management, developers, and users.
• Assess capacity and performance, including 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

AWS services knowledge

Java/PySpark experience

Database design & optimization

Tools

Docker

Kubernetes

AWS Glue

Athena

CloudFormation

Job description

Our client, Eliassen Group, seeks a Senior DBA for a remote contract role to support database operations for a Federal Office program. You will design and optimize PostgreSQL and MySQL on Amazon RDS, automate deployments, and lead performance improvements while coordinating with cross-functional teams.

The role requires US citizenship or permanent residency with an active Public Trust clearance. W2 consulting options are available with comprehensive benefits and a strong focus on security and