PostgreSQL Database Administrator

SAIC

. Configure and administer managed PostgreSQL instances in the AWS environment .

Posted 9/22/2026full-timeAshburn • Virginia • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in managing PostgreSQL databases within AWS, focusing on performance optimization, security policies, and automation. Proficient in collaborating with development teams to enhance database functionality and ensure efficient data access.

Highest-signal resume keywords

RDS PostgreSQL ManagementDatabase Tuning and OptimizationDynatrace MonitoringScripting in Python or BashCI/CD Pipeline Familiarity

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

PostgreSQLSQL Query OptimizationDatabase AutomationPostGISPerformance TuningIndexing StrategiesData ModelingStored ProceduresPartitioningAWS RDS

Soft Skills

Troubleshooting SkillsProblem-Solving SkillsCommunication SkillsCollaboration SkillsAttention to Detail

Tools & Technologies

DynatraceAWSCI/CD ToolsDatabase Monitoring Tools

Certifications & Qualifications

DHS Public Trust Clearance

Industry Keywords

Database Security PoliciesRole-Based Access ControlData EncryptionETL PipelinesData Warehouse ArchitectureGovernment Regulatory Compliance

Tech Stack

Tools & technologies

AWSCloudETLPostGISPostgresPythonSQL

About the role

Key responsibilities & impact

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, 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 deployments, scaling, and maintenance
Assist in 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
Collaborate with developers and data engineers to ensure efficient data access patterns
Create and maintain documentation of database environments, procedures, and standards
Enforce database best practices and policies
Mentor junior team members
Train application developers and other stakeholders on database-related topics

Requirements

What you’ll need

Bachelor's degree and 5+ years of relevant experience
Extensive experience with RDS 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 such as Python or 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
Experience designing tables
Experience writing functions and stored procedures
Experience with performance tuning and optimization
Experience checking indexes
Experience with partitioning
Experience working in an AWS environment
Must be a U.S. Citizen
Current holder of a DHS Public Trust clearance or ability to obtain one; employment is contingent upon having or obtaining clearance prior to starting
Preferred: knowledge of ETL pipelines and data warehouse architecture
Preferred: familiarity with analytics/modeling tools
Preferred: exposure to data replication and sharding strategies
Preferred: knowledge of government regulatory compliance standards
Strong communication and collaboration skills
Ability to manage multiple priorities in a fast-paced environment
Attention to detail and commitment to delivering high-quality results