[Hiring] PostgreSQL Database Administrator/Developer @Peraton

Role Description

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.

• 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

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

Requirements

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

Benefits

• Medical, dental, vision, and life insurance
• Health savings account
• Short/long term disability
• Employee Assistance Program (EAP)
• Parental leave
• 401(k)
• Paid time off (PTO) for vacation
• Company paid holidays