PostgreSQL Database Administrator/Developer

Peraton • ,

3d • $86,000 - $138,000

About The Position

Peraton is seeking a mid-level PostgreSQL Database Administrator/Developer to work closely with a Senior DBA, developers, and operations staff. The role supports daily database operations and the transition to cloud-native practices, including managing PostgreSQL databases on AWS and contributing to a migration from Microsoft SQL Server to PostgreSQL. The successful candidate will bring hands-on PostgreSQL and AWS experience, collaborate effectively, and be interested in developing cloud database engineering skills.

Requirements

• Bachelor’s degree and 5 years of experience, or 9 years of experience with a high school diploma or 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 U.S. citizen.
• Must be able to obtain and maintain the required agency clearance.

Nice To Haves

• Hands-on experience migrating from SQL Server to PostgreSQL and familiarity with differences between T-SQL and PL/pgSQL.
• Experience with Git, CI/CD pipelines, and automated deployment of infrastructure and database changes.
• Experience with 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, such as AWS Certified Solutions Architect – Associate or AWS Certified Database – Specialty.

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 SQL Server to PostgreSQL migration by converting and testing database objects and processes with senior staff and developers.
• Partner with developers to write, review, and improve database code and maintain database efficiency.
• Plan, manage, and perform database deployments and releases across environments with development and operations teams.
• Monitor database health and troubleshoot and resolve issues with DBA, development, operations, help desk, and reporting teams.
• Help maintain database security and data accuracy by following and improving security standards, access controls, and data quality checks.
• Help automate routine tasks, improve team processes, and maintain shared documentation and procedures.

Benefits

• Medical benefits
• Dental insurance
• Vision insurance
• Life insurance
• Health savings account
• Short- and long-term disability
• Employee assistance program (EAP)
• Parental leave
• 401(k)
• Paid time off (PTO) for vacation
• Company-paid holidays

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level