PostgreSQL Database Administrator

SAIC-posted 6 days ago

Full-time • Mid Level

Hybrid • Ashburn, VA

11-50 employees

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

We are seeking a highly skilled and experienced Database Subject Matter Expert (SME) with strong Database Administrator (DBA) capabilities to join our team. The ideal candidate will specialize in PostgreSQL (RDS), bringing expertise in deployment, administration, query tuning, and database monitoring. This role requires a proactive professional capable of managing database operations, optimizing performance, and supporting application development teams. This role is hybrid-remote and requires 2 days on-site in Ashburn, VA per week.

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.

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.

Knowledge of ETL pipelines and data warehouse architecture.
Familiarity with analytics/modeling tools.
Exposure to data replication and sharding strategies.
Knowledge of government regulatory compliance standards.
Certifications such as AWS Certified Database - Specialty, PostgreSQL DBA Certification, or similar are a plus.

Track Jobs with Teal

Job Search Resources

•

Resume Builder

•

Resume Examples

•

Cover Letter Examples

PostgreSQL Database Administrator

Job Search Resources

Tools

Career Hubs

Guides

Company