Senior Database Administrator

ZP Group; Washington (District of Columbia); On-site; USD 135,000 - 175,000; Full time

Benefits offered by this job

Cigna Medical

Dental

Vision

401K

PTO

Holidays

Job summary

Zachary Piper Solutions seeks a Senior Database Administrator to design, implement, and optimize enterprise database environments in Washington DC. You will manage PostgreSQL, AWS RDS/Aurora, and advanced high-availability solutions for critical DOJ programs.

The role requires top-secret clearance, 8+ years of experience, and strong skills in performance tuning, security, and migrations. On-site in Washington, DC with comprehensive benefits.

Qualifications

• Bachelor's degree in Information Technology or related field and 8+ years of experience.
• Extensive experience designing, implementing, and maintaining complex database environments.
• Hands-on PostgreSQL (v13+) administration with tuning, patching, and capacity planning.
• Experience with backup/recovery (pg_dump/pg_restore), WAL archiving, replication, and HA configurations.
• Experience with PostgreSQL query tuning, indexing, partitioning, and monitoring tools.
• Experience migrating PostgreSQL, Oracle, AWS RDS, and Aurora PostgreSQL environments.
• Knowledge of database security, access controls, and safeguarding enterprise data.
• Ability to establish monitoring/alerting using Prometheus, Grafana, or similar.

Responsibilities

• Design, implement, maintain, and optimize enterprise database environments for performance and reliability.
• Administer PostgreSQL databases including configuration, tuning, patching, capacity planning, backup, and high availability.
• Implement database security controls and coordinate changes with system integrations.
• Monitor database health, troubleshoot performance issues, optimize queries and indexing, and set up alerts.
• Support migrations, cloud modernization, and AWS RDS/Aurora PostgreSQL environments.

Skills

PostgreSQL

AWS

High Availability

Performance Tuning

Security Best Practices

Data Integrity

Query Optimization

Relational Databases

Education

Bachelor's Degree in IT or related field

Tools

pg_dump/pg_restore

WAL Archiving

AWS RDS

Aurora PostgreSQL

Prometheus

Grafana

Job description

Zachary Piper Solutions is seeking a Senior Database Administrator. This job is located in Washington D.C. and will be On-Site. The Senior Database Administrator will be responsible for designing, implementing, maintaining, and optimizing enterprise database environments while ensuring data integrity, security, and performance. This is an exciting opportunity to work with PostgreSQL, AWS cloud database technologies, high availability solutions, and enterprise data platforms in Washington D.C. supporting a DOJ Program.

REQUIRES TOP SECRET CLEARANCE

Responsibilities of the Senior Database Administrator include:

• Design, implement, maintain, and optimize enterprise database environments while ensuring performance, scalability, and reliability.
• Administer PostgreSQL databases, including configuration, tuning, patching, capacity planning, backup, recovery, and high availability solutions.
• Implement database security controls, coordinate database changes, and support system integration initiatives.
• Monitor database health, troubleshoot performance issues, optimize queries and indexing strategies, and establish alerting solutions.
• Support database migrations, cloud modernization efforts, and AWS RDS/Aurora PostgreSQL environments.

Qualifications for the Senior Database Administrator include:

• Bachelor's Degree in Information Technology or a related field, or equivalent experience, and 8+ years of relevant experience.
• Strong experience designing, implementing, and maintaining complex database environments and database management systems.
• Hands-on experience administering PostgreSQL (v13+) including performance tuning, patching, capacity planning, and database optimization.
• Experience implementing backup and recovery solutions using pg_dump/pg_restore, WAL archiving, replication, and high availability configurations.
• Experience with PostgreSQL query tuning, indexing, partitioning, performance analysis, and database monitoring tools.
• Experience planning and executing database migrations, including PostgreSQL, Oracle, AWS RDS, and Aurora PostgreSQL environments.
• Knowledge of database security, access controls, and security best practices for safeguarding enterprise data.
• Experience establishing monitoring and alerting solutions using Prometheus, Grafana, or similar observability platforms, with strong communication and troubleshooting skills.

Compensation for the Senior Database Administrator include:

• Salary Range: $135,000 - $175,000
• Comprehensive Benefits: Cigna Medical, Dental, Vision, 401K, PTO, Sick Leave if required by law, and Holidays

#LI-WM1

#LI-Hybrid

Database Administrator, DBA, PostgreSQL, PostgreSQL 13, PostgreSQL Administration, Database Management, Database Design, Database Optimization, Performance Tuning, Query Optimization, SQL, SQL Development, Indexing, Partitioning, EXPLAIN, ANALYZE, pg_stat_statements, pg_dump, pg_restore, WAL Archiving, Database Backup, Disaster Recovery, High Availability, Database Replication, Physical Replication, Logical Replication, Data Integrity, Database Security, Access Controls, Oracle, Oracle Migration, Database Migration, AWS, Amazon Web Services, AWS RDS, Amazon RDS, Aurora PostgreSQL, Cloud Databases, Database Monitoring, Prometheus, Grafana, Observability, Database Performance, Capacity Planning, Database Testing, Database Engineering, System Integration, Enterprise Databases, Cloud Migration, Troubleshooting, Root Cause Analysis, Relational Databases, Data Management, Database Architecture, Enterprise Applications, DOJ.