Senior PostgreSQL DBA - Secure, High Availability

Talentify; Washington (District of Columbia); On-site; USD 116,000 - 150,000; Full time

Job summary

Technica Corporation in Washington, DC is seeking a skilled Database Administrator to design, implement, and maintain moderately complex PostgreSQL databases across DoD-related environments. This role focuses on data integrity, security, backup/recovery, replication, and performance tuning, with on-site work at a government facility in Washington, D.C.

A TS/SCI eligibility is required. The position also involves coordinating changes and ensuring seamless integration with enterprise systems.

Qualifications

• Active Top-Secret with SCI and CI Poly eligibility.
• Bachelor’s degree in Information Technology or related field or equivalent education and/or experience.
• Minimum 8 years of database administration experience.
• Strong knowledge and experience in database management systems.
• Ability to design and maintain complex databases.
• Experience with database administration and testing.
• Knowledge of security measures and techniques to safeguard computer databases.
• Excellent coordination and communication skills to manage database changes and integration.

Responsibilities

• Design, implement, and maintain moderately complex databases.
• Maintain database dictionaries and ensure the integration of various systems through effective database design.
• Administer and test computer databases, utilizing knowledge of database management systems.
• Coordinate changes to computer databases to ensure data integrity and system efficiency.
• Plan, coordinate, and implement security measures to protect computer databases from unauthorized access or data breaches.
• Administer and optimize PostgreSQL (v13+) including configuration, performance tuning, patching, and capacity planning.
• Implement and validate backup and recovery for PostgreSQL using pg_dump/pg_restore and WAL archiving.
• Configure and monitor PostgreSQL replication and high availability (physical/logical replication).
• Perform query tuning and indexing for PostgreSQL using EXPLAIN/ANALYZE, partitioning, and pg_stat_statements.
• Plan and execute migrations to/from PostgreSQL, including cloud-managed services such as AWS RDS or Aurora PostgreSQL and from Oracle.
• Establish monitoring and alerting for PostgreSQL using standard observability tooling (e.g., Prometheus/Grafana or equivalent).

Skills

Database administration

PostgreSQL

Performance tuning

Security & compliance

Data integrity

System integration

Monitoring & observability

Education

Bachelor's degree in IT or related field

Tools

PostgreSQL tooling

pg_dump/pg_restore

AWS RDS/Aurora PostgreSQL

Prometheus

Grafana

Job description

Technica Corporation in Washington, DC is seeking a skilled Database Administrator to design, implement, and maintain moderately complex PostgreSQL databases across DoD-related environments. This role focuses on data integrity, security, backup/recovery, replication, and performance tuning, with on-site work at a government facility in Washington, D.C.

A TS/SCI eligibility is required. The position also involves coordinating changes and ensuring seamless integration with enterprise systems.