PostgreSQL Database Administrator/Developer

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

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).

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.