Senior PostgreSQL DBA: HA, Security & Migrations

Gridiron IT; Washington (District of Columbia); On-site; USD 120,000 - 175,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k)

Job summary

Gridiron IT in Washington, DC is seeking a seasoned Database Administrator to design, implement, and maintain PostgreSQL databases. You will manage dictionaries, ensure system integration, and administer security and testing of databases to safeguard data integrity.

You will coordinate changes, optimize performance, implement backups and replication, and plan migrations across on‑premises and cloud environments such as AWS RDS/Aurora. Strong communication is essential.

Qualifications

• 8+ years of experience in database management and administration.
• Ability to design and maintain complex databases.
• Experience with database administration and testing.
• Knowledge of security measures to safeguard databases.
• Excellent coordination and communication skills to manage changes and integration.

Responsibilities

• Design, implement, and maintain moderately complex databases.
• Maintain database dictionaries and ensure system integration through design.
• Administer and test databases with strong DBMS knowledge.
• Coordinate changes to ensure data integrity and system efficiency.
• Plan, implement security measures to protect databases.
• Administer and optimize PostgreSQL (v13+) including tuning and capacity planning.
• Configure backups using pg_dump/pg_restore and WAL archiving.
• Configure and monitor PostgreSQL replication and high availability.
• Perform query tuning and indexing using EXPLAIN/ANALYZE and partitioning.
• Plan migrations to/from PostgreSQL including AWS RDS/Aurora and Oracle.
• Establish monitoring and alerting using observability tools.

Skills

Database management

System design

Database testing

Security measures

Coordination & communication

Tools

PostgreSQL

pg_dump/pg_restore

WAL archiving

AWS RDS/Aurora PostgreSQL

Prometheus/Grafana

Job description

Gridiron IT in Washington, DC is seeking a seasoned Database Administrator to design, implement, and maintain PostgreSQL databases. You will manage dictionaries, ensure system integration, and administer security and testing of databases to safeguard data integrity.

You will coordinate changes, optimize performance, implement backups and replication, and plan migrations across on‑premises and cloud environments such as AWS RDS/Aurora. Strong communication is essential.