Apply on Employer Site

SAIC · 10 hours ago

PostgreSQL Database Administrator

Ashburn, VA

Full-time

Hybrid

Senior Level

5+ years exp

SAIC is seeking a highly skilled and experienced Database Subject Matter Expert (SME) to join their team. The ideal candidate will specialize in PostgreSQL, managing database operations, optimizing performance, and supporting application development teams.

Information TechnologySecurityService IndustrySoftware

Work & Life Balance

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

Configure and administer managed PostgreSQL instances in the AWS environment

Maintain database security policies, including role-based access control and data encryption

Analyze and optimize SQL queries for performance improvement, particularly on large tables

Work with development teams to review and enhance database-related code

Set up and monitor Dynatrace alerts to ensure database reliability and availability

Investigate and resolve performance issues identified through monitoring tools or reported by users

Develop and implement database automation scripts for routine tasks such as deployments, scaling, and maintenance

Assist in Continuous Integration/Continuous Deployment (CI/CD) processes for database updates

Proactively monitor database health and resolve capacity or connectivity issues

Conduct root-cause analysis for database incidents and implement preventive measures

Provide input on data modeling and schema design for new and existing applications

Collaborate with developers and data engineers to ensure efficient data access patterns

Create and maintain detailed documentation of database environments, procedures, and standards

Enforce database best practices and policies

Act as a technical mentor to junior team members

Provide training to application developers and other stakeholders on database-related topics

Qualification

PostgreSQL DBA experienceDatabase tuningQuery optimizationAWS RDSPostGIS queriesDynatrace monitoringScripting languagesCI/CD pipelinesTroubleshooting skillsCommunication skillsCollaboration skillsAttention to detail

Required

DBA experience in PostgreSQL, including deployment, maintenance, and optimization

Strong knowledge of database tuning, query optimization, and indexing strategies

Experience with Postgres GIS queries using the PostGIS addon

Experience with database monitoring tools, particularly Dynatrace or similar platforms

Proficiency in scripting languages (e.g., Python, Bash) for database automation

Understanding of cloud database architectures and services, such as AWS RDS

Familiarity with CI/CD pipelines and database version control

Excellent troubleshooting and problem-solving skills

Bachelor's degree in computer science, Information Technology, or a related field (or equivalent experience). Five (5) years or more experience; master's degree and three (3) years or more experience

Must be a U.S. Citizen and current holder of a DHS Public Trust clearance or the ability to obtain one

Certifications such as AWS Certified Database - Specialty, PostgreSQL DBA Certification, or similar are a plus