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 at https://www.careers.peraton.com/benefits.
Application Statements The application period for the job is estimated to be 30 days from the job posting date. However, this timeline may be shortened or extended depending on business needs and the availability of qualified candidates. By applying to this job, you are expressing interest in the role and the Company. During the review of your application, you may be required to participate in an on-camera interview, as well as participate in a process to verify your identity. Use of artificial intelligence (AI) tools of any kind during Peraton interviews is strictly prohibited unless the candidate has obtained prior written authorization. All interview responses must be the candidate’s own.
- EEO
- EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.
