External Job Posting Title PostgreSQL Database Administrator/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 Overview

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can’t be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we’re keeping people around the world safe and secure.

Responsibilities

We are looking for a mid-level PostgreSQL Database Administrator/Developer to join our team and work closely with our Senior DBA, developers, and operations staff. Together, we’ll support daily database operations and move to cloud-native practices. You’ll help manage PostgreSQL databases on AWS, contribute to our SQL Server to PostgreSQL migration, and share ideas for improving how we work. The ideal candidate has hands-on PostgreSQL and AWS experience, enjoys solving problems as part of a team, and wants to grow in cloud database engineering.

Responsibilities:

• Work with the Senior DBA to manage and maintain PostgreSQL databases in AWS, including monitoring, backups, upgrades, routine maintenance, and disaster recovery planning and testing.
• Contribute to the migration from SQL Server to PostgreSQL by working with senior staff and developers to convert and test database objects and processes.
• Partner with developers to write, review, and improve database code and to keep databases running efficiently.
• Work with development and operations teams to plan, manage, and perform database deployments and releases across environments.
• Monitor database health and work with the DBA, development, operations, help desk, and reporting teams to troubleshoot and resolve issues.
• Help keep databases secure and data accurate by following and improving security standards, access controls, and data quality checks.
• Work with the team to automate routine tasks, improve how we work, and keep shared documentation and procedures up to date.

Qualifications

Required Qualifications:

• Bachelor’s degree and 5 years of experience or 9 years with a HS diploma/equivalent
• Hands-on PostgreSQL administration and database development experience.
• Hands-on experience running PostgreSQL in AWS, including Amazon RDS for PostgreSQL and self-managed databases on EC2.
• Strong SQL and PL/pgSQL skills, including query tuning and troubleshooting.
• Working knowledge of backup and recovery, replication, and database security practices.
• Scripting experience in Python, PowerShell, or similar.
• Experience with Microsoft SQL Server.
• Strong communication skills and a history of working well with developers, operations, and business users.
• Must be a US Citizen.
• Must be able to obtain and maintain the required agency clearance.

Preferred Qualifications:

• Hands-on experience migrating from SQL Server to PostgreSQL, and familiarity with how T-SQL and PL/pgSQL differ.
• Experience with Git, CI/CD pipelines, and automated deployment of infrastructure and database changes.
• Experience with common PostgreSQL administration tools, such as psql, pgAdmin, pgBouncer, pgBackRest, Patroni, and pgBadger.
• Experience with database IDEs and schema and data comparison tools, such as DBeaver, DataGrip, Visual Studio Code, and dbForge Schema Compare and Data Compare for PostgreSQL.
• Experience with pgaudit, IAM database authentication, and KMS encryption.
• AWS certification (for example, AWS Certified Solutions Architect – Associate or AWS Certified Database – Specialty).

Target Salary Range

$86,000 - $138,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual’s experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.

Benefits Statement

Peraton offers eligible employees a variety of benefits including medical, dental, vision, life, health savings account, short/long term disability, EAP, parental leave, 401(k), paid time off (PTO) for vacation, and company paid holidays. A full listing of available benefits can be viewed athttps://www.careers.peraton.com/benefits.

EEO

EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.