AWS PostgreSQL DBA & Dev: Cloud Migrations & Automation

Peraton; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

Peraton is seeking a mid-level PostgreSQL Database Administrator/Developer to join our team in the United States. You will manage PostgreSQL databases on AWS, support migrations from SQL Server, and work with developers and operations to keep databases healthy and secure.

You will partner with the Senior DBA to monitor, backup, upgrade, and test disaster recovery plans while driving cloud-native practices and automation to improve how we work.

Qualifications

• Bachelor’s degree and 5+ years of PostgreSQL experience.
• PostgreSQL on AWS (RDS and EC2) experience.
• Strong SQL/PL/pgSQL with tuning.
• Backup, recovery, replication, and security practices.
• Python or PowerShell scripting experience.
• Experience with MS SQL Server.
• Must be a US citizen and able to obtain clearance.

Responsibilities

• Manage PostgreSQL databases in AWS with monitoring, backups, upgrades, maintenance, and DR testing.
• Assist in SQL Server to PostgreSQL migration with senior staff and developers.
• Collaborate with developers to optimize database code and keep systems efficient.
• Plan, manage, and perform database deployments and releases across environments.
• Monitor health, troubleshoot issues with teams, and ensure data quality and security.
• Document procedures and help automate routine tasks.

Skills

PostgreSQL administration

AWS PostgreSQL (RDS/EC2)

SQL/PLpgSQL

Backup and recovery

Scripting (Python/PowerShell)

MS SQL Server

Communication

Security clearance readiness

Education

Bachelor's degree

High School diploma or equivalent

Tools

psql

pgAdmin

pgBouncer

pgBackRest

Patroni

dbForge Schema/Data Compare (PostgreSQL)

DataGrip

DBeaver

Job description

Peraton is seeking a mid-level PostgreSQL Database Administrator/Developer to join our team in the United States. You will manage PostgreSQL databases on AWS, support migrations from SQL Server, and work with developers and operations to keep databases healthy and secure.

You will partner with the Senior DBA to monitor, backup, upgrade, and test disaster recovery plans while driving cloud-native practices and automation to improve how we work.