PostgreSQL Database Administrator Remote / Telecommute Jobs

Functional Title – PostgreSQL Database Administrator

Location: Hybrid/Remote - Ashburn, VA

Clearance Level Must Be Able to Obtain: Public Trust

Onsite: Must be in Ashburn office twice a week.

JOB DESCRIPTION:

We are seeking a skilled PostgreSQL Database Administrator 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.

Responsibilities:

• Database Administration:

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

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

• Query Tuning and Optimization:

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

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

• Monitoring and Alerts:

◦ 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.

• Automation and Deployment:

◦ 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.

• System Health and Troubleshooting:

◦ Proactively monitor database health and resolve capacity or connectivity issues.

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

• Database Design and Support:

◦ 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.

• Documentation and Best Practices:

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

◦ Enforce database best practices and policies.

• Training and Guidance:

◦ Act as a technical mentor to junior team members.

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

Qualifications:

Required Skills:

• Extensive experience with PostgreSQL, including deployment, maintenance, and optimization.

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

• 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.

Preferred Skills:

• Experience with Postgres GIS queries using the PostGIS addon.

• 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.

Soft Skills:

• Strong communication and collaboration skills for working with cross-functional teams.

• Ability to manage multiple priorities in a fast-paced environment.

• Attention to detail and a commitment to delivering high-quality results.

EDUCATION AND EXPERIENCE:

• Bachelors and five (5) years or more experience; Masters and three (3) years or more experience; PhD and 0 years related experience

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

BI Requirement

• Current holder of a DHS Public Trust clearance or the ability to obtain one.

• Note: Employment will be contingent upon having/obtaining a DHS Public Trust clearance prior to starting.

• TS clearance would expedite hiring process.

Apply tot his job