Database Administrator

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

The Database Administrator designs, implements, and maintains moderately complex databases. This role is responsible for maintaining database dictionaries, ensuring the integration of systems through effective database design, and administering and testing computer databases by applying a deep knowledge of database management systems. Additionally, the Database Administrator coordinates changes to computer databases and may plan, coordinate, and implement security measures to safeguard computer databases.

Key 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).

Qualifications

8+ years of 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.

Clearance

Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; Top Secret clearance required

Compensation and Benefits

Salary Range: $120,000 - $175,000 (Compensation is determined by various factors, including but not limited to location, work experience, skills, education, certifications, seniority, and business needs. This range may be modified in the future.)

Benefits: Gridiron offers a comprehensive benefits package including medical, dental, vision insurance, HSA, FSA, 401(k), disability & ADD insurance, life and pet insurance to eligible employees. Full-time and part-time employees working at least 30 hours per week on a regular basis are eligible to participate in Gridiron's benefits programs.

Gridiron IT Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status or disability status.

Gridiron IT is a Women Owned Small Business (WOSB) headquartered in the Washington, D.C. area that supports our clients' missions throughout the United States. Gridiron IT specializes in providing comprehensive IT services tailored to meet the needs of federal agencies. Our capabilities include IT Infrastructure & Cloud Services, Cyber Security, Software Integration & Development, Data Solution & AI, and Enterprise Applications. These capabilities are backed by Gridiron IT's experienced workforce and our commitment to ensuring we meet and exceed our clients' expectations.