Senior PostgreSQL DBA — AWS & High Availability Expert

Akaasa Technologies; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Leidos is seeking a Sr. DBA (PostgreSQL) to support database operations and drive design improvements for a portfolio of on-line and batch applications. You will manage PostgreSQL on AWS RDS, write scripts, and lead deployment automation using Python, Shell, Ansible, and CloudFormation.

The role requires deep DBA experience in PostgreSQL, strong scripting skills, and a proven ability to optimize data models and performance in a cloud environment.

Qualifications

• Bachelor's degree or equivalent experience with 6–8 years in DB operations or 4–6 years with an advanced degree.
• Advanced scripting including bash and Python for database administration.
• Experience building logical and physical data models in PostgreSQL on AWS RDS.
• Extensive PostgreSQL DBA experience on AWS RDS; experience with MySQL, SQL Server, or Oracle is a plus.

Responsibilities

• Analyze requirements to develop database solutions for online and batch Java-based and AWS Glue/Spark systems.
• Coordinate with teams to define system requirements and support testing for database components.
• Design and deploy scalable, high-performance PostgreSQL/MySQL solutions on AWS RDS; optimize schemas and data models.
• Create and maintain scripts, procedures, tables, triggers, and views; automate deployment with Python, Shell, Ansible, CloudFormation.
• Manage database operations including upgrades, restores, schema changes, and failovers with minimal oversight.
• Communicate database changes with management, developers, and system users.
• Monitor capacity and performance; perform capacity planning and resource forecasting.

Skills

PostgreSQL

AWS

Python

Shell

Ansible

CloudFormation

Linux

CI/CD

Git

Performance tuning

Education

Bachelor's degree or equivalent

Master's degree

Tools

Liquibase

Flyway

Jenkins

GitHub Actions

GitLab CI

AWS CodePipeline

Job description

Leidos is seeking a Sr. DBA (PostgreSQL) to support database operations and drive design improvements for a portfolio of on-line and batch applications. You will manage PostgreSQL on AWS RDS, write scripts, and lead deployment automation using Python, Shell, Ansible, and CloudFormation.

The role requires deep DBA experience in PostgreSQL, strong scripting skills, and a proven ability to optimize data models and performance in a cloud environment.