Database Administrator

Peraton; United States; On-site; USD 112,000 - 179,000; Full time

Job summary

Peraton is seeking a Postgres DBA/Developer in the United States to maintain and optimize PostgreSQL databases. This role involves collaborating with development teams to ensure database performance and integrity, with a focus on high-volume applications.

The ideal candidate will have at least 8 years of experience in database administration, along with a solid understanding of AWS RDS Aurora. The target salary range for this position is $112,000 - $179,000, depending on qualifications.

Qualifications

• 8+ years of experience required with a BS/BA.
• Strong MySQL, PL/PGSQL, or PL/SQL experience is a plus.
• Hands-on experience with Postgres DB administration.

Responsibilities

• Maintain production, testing, and development databases.
• Support development team from a database design perspective.
• Ensure optimal performance on PostgreSQL environments.

Skills

PostgreSQL

AWS RDS Aurora

MySQL

Performance tuning

Data Modeling in ErWin

Education

BS/BA

MS/MA

PhD

Tools

ErWin

SNOWFLAKE

Job description

Responsibilities

Peraton is looking for a strong Postgres DBA/ Developer with expertise in data modeling and maintaining production, testing and development databases. This role is part of a collaborative and agile team that supports and builds modern, standards-based responsive web applications for mission-critical health IT solutions.

Role and Responsibilities:

• Responsible for the maintenance of production, testing and development databases.
• Brings solid understanding of database administration.
• Supports development team from a database design and development perspective.
• Responsible for database administration or engineering activities, ensure optimal performance on PostgreSQL environments.
• Responsible for the installation, maintenance, configuration, and integrity of PostgreSQL architecture.
• Performance tuning of the queries.
• Provide support to the application developers, including, but not limited to data refresh, SQL, MySQL and PL/pgSQL performance tuning and best practice recommendations.
• Conduct code reviews with application developers.
• Ensure the long-term requirements of systems operations and administration are included in the organization's overall database systems planning.
• Perform many related database functions across one or more teams, including designing, implementing, and maintaining new databases, backup/recovery, and configuration management.
• Knowledge of SNOWFLAKE

Qualifications

Required Qualifications:

• Minimum of 8 years with BS/BA; Minimum of 6 years with MS/MA; Minimum of 3 years with PhD
• Strong MySQL, PL/PGSQL or PL/SQL experience is a plus.
• Performance turning of the queries.
• Experience in AWS RDS Aurora PostgreSQL.
• Experience in Complex and high-volume data warehouse projects.
• Hands‑on experience with Postgres database administration, performance tuning and production support in a high volume, customer‑facing apps/environment.
• Data Modeling Experience in ErWin
• Experience working in Agile/ Scrum large scale programs
• Excellent written, verbal, and interpersonal communication skills
• Manages time extremely well, can quickly sense when an issue needs to be discussed or triaged
• Strong attention to detail and focus on task completion is critical
• Must be able to obtain a Public Trust clearance
• US citizenship or Green Card holder and been in the USA for 3 of the last 5 years.

Preferred Qualifications:

• AWS certification

Target Salary Range

$112,000 - $179,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.

EEO

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