AWS PostgreSQL DB Admin & Developer

Peraton; Idaho; On-site; USD 86,000 - 138,000; Full time

Benefits offered by this job

Discretionary bonus

Job summary

Peraton is seeking a mid-level PostgreSQL Database Administrator/Developer to manage PostgreSQL in AWS and support migrations from SQL Server. You will work with the Senior DBA, developers, and operations staff on daily database operations and cloud-native practices.

The role emphasizes hands-on PostgreSQL experience in AWS, collaboration with teams, and growth in cloud database engineering, with potential for discretionary bonus and OT considerations.

Qualifications

• Bachelor’s degree with 5 years of experience or HS diploma/equivalent with 9 years
• Hands-on PostgreSQL administration and database development
• PostgreSQL on AWS including Amazon RDS for PostgreSQL and self-managed databases on EC2
• Strong SQL and PL/pgSQL skills, including query tuning and troubleshooting
• Backup and recovery, replication, and database security practices
• Scripting experience in Python, PowerShell, or similar
• Experience with Microsoft SQL Server
• Strong communication skills and ability to collaborate with developers, operations, and business users
• US citizen and ability to obtain clearance

Responsibilities

• Manage and maintain PostgreSQL databases in AWS, including backups, upgrades, and DR testing
• Assist migration from SQL Server to PostgreSQL and test objects
• Collaborate with developers to optimize database code and performance
• Plan deployments and releases across environments with the team
• Monitor database health and troubleshoot with cross-functional teams
• Enforce security standards and data quality controls
• Automate routine tasks and maintain up-to-date documentation

Skills

PostgreSQL administration

AWS experience

SQL tuning

Scripting (Python/PowerShell)

Communication skills

US citizenship

Education

Bachelor’s degree (5+ years)

HS diploma/equivalent (9 years)

Tools

Amazon RDS for PostgreSQL

EC2

pgAdmin

pgBackRest

Patroni

pgBadger

DBeaver

DataGrip

VS Code

dbForge PostgreSQL

pgaudit

IAM database authentication

KMS encryption

Git

CI/CD pipelines

Job description

Peraton is seeking a mid-level PostgreSQL Database Administrator/Developer to manage PostgreSQL in AWS and support migrations from SQL Server. You will work with the Senior DBA, developers, and operations staff on daily database operations and cloud-native practices.

The role emphasizes hands-on PostgreSQL experience in AWS, collaboration with teams, and growth in cloud database engineering, with potential for discretionary bonus and OT considerations.