Job Overview
We are seeking a highly skilled Database Subject Matter Expert (SME) with strong Database Administrator (DBA) experience to support PostgreSQL (RDS) in a hybrid-remote environment. This role focuses on deployment, administration, query tuning, performance optimization, and database monitoring in AWS. The ideal candidate will be proactive, detail-oriented, and capable of collaborating with cross-functional teams to ensure database security, availability, and efficiency.
Key Responsibilities
Database Administration
-
Configure and manage PostgreSQL (RDS) and Amazon Redshift in AWS.
-
Maintain security policies including role-based access and data encryption.
Query Tuning & Optimization
-
Analyze and optimize SQL queries on large tables.
-
Collaborate with developers to improve database code efficiency.
Monitoring & Troubleshooting
-
Implement monitoring and alerting with Dynatrace.
-
Investigate and resolve performance and capacity issues.
Automation & CI/CD
-
Develop automation scripts (Python, Bash) for deployments and scaling.
-
Support CI/CD pipelines for database updates.
Database Design & Support
-
Provide input on data modeling, schema design, and access patterns.
-
Support application teams with database best practices.
Documentation & Training
-
Maintain documentation of environments, procedures, and standards.
-
Mentor junior DBAs and provide training to developers.
Required Qualifications
-
Education/Experience:
-
Bachelor’s degree in Computer Science, IT, or related field + 9 years experience, OR
-
Master’s degree + 7 years experience, OR
-
PhD/JD + 4 years experience.
-
-
U.S. Citizenship and ability to obtain a Public Trust clearance.
-
Deep expertise in PostgreSQL deployment, tuning, and optimization.
-
Experience with PostGIS, Dynatrace, AWS RDS, and automation scripting (Python/Bash).
-
Familiarity with CI/CD pipelines and database version control.
-
Strong troubleshooting, problem-solving, and communication skills.
Preferred Skills
-
Knowledge of ETL pipelines and data warehouse architecture.
-
Experience with analytics/modeling tools.
-
Exposure to data replication and sharding strategies.
-
Familiarity with government compliance standards.
Clearance Requirement
-
Must obtain and maintain a DHS Public Trust clearance.
-
Employment is contingent upon clearance approval.
APPLY