Database Administrator

Cayuse Holdings • Washington, DC

18d • Onsite

About The Position

The Database Administrator designs, implements, and maintains moderately complex databases, ensuring their optimization, security, and integration with organizational systems. The role requires strong database management expertise, particularly in PostgreSQL, and responsibility for data integrity, performance optimization, coordinated database changes, and robust security measures. The position supports technical solutions that meet customer needs and emphasizes teamwork and quality.

The administrator manages PostgreSQL environments (version 13 or higher), including setup, configuration, patching, performance tuning, and capacity planning. The role also covers backup and recovery, replication and high availability, query and index optimization, database migrations—including cloud-managed PostgreSQL services and Oracle migrations—and database monitoring and troubleshooting. Employment in this role is conditional upon successful execution of the contract by the client. The position may involve evolving client-specific responsibilities after award of the task order.

Requirements

• Bachelor’s degree in Information Technology, Computer Science, or a related field, or equivalent experience.
• At least 8 years of professional experience in database administration and management.
• Expertise with PostgreSQL version 13 or higher in medium-to-large-scale deployments.
• Strong hands-on knowledge of database design, administration, and optimization.
• Ability to implement scalable, efficient, and secure database solutions for enterprise needs.
• Deep understanding of PostgreSQL backup and recovery processes and high-availability configurations.
• Experience with database migration projects to and from PostgreSQL, with exposure to AWS RDS or Aurora PostgreSQL.
• Proficiency in query optimization, indexing, and performance tuning.
• Experience setting up observability and monitoring tools, such as Prometheus/Grafana or custom dashboards.
• Active Top Secret Security Clearance.
• Must be able to pass a background check and may be required to complete additional project- or client-specific background checks during employment.
• Strong interpersonal, verbal communication, and written communication skills.
• Strong organizational, analytical, and problem-solving skills, with attention to detail.
• Ability to multitask, prioritize in a fast-paced environment with changing priorities, adapt to change, and learn quickly.
• Self-motivated, with the ability to work independently and as part of a multifunctional team.
• Ability to handle sensitive and confidential information appropriately.
• Proficiency in MS Office, including Word, Outlook, PowerPoint, and Excel.

Responsibilities

• Design, implement, and maintain moderately complex databases for business and operational needs.
• Configure databases efficiently and maintain current database dictionaries.
• Integrate systems through reliable database designs.
• Administer and test computer databases, including PostgreSQL environments.
• Plan and implement security measures to protect databases from unauthorized access and data breaches.
• Set up, configure, patch, tune, and capacity-plan PostgreSQL environments (version 13 or higher).
• Implement and validate backup and recovery procedures using tools such as pg_dump/pg_restore and WAL archiving.
• Configure, monitor, and manage PostgreSQL replication and high availability using physical and logical replication.
• Optimize queries and indexes using techniques and tools such as EXPLAIN/ANALYZE, partitioning, and pg_stat_statements.
• Plan and execute migrations to and from PostgreSQL, including migrations involving AWS RDS, Aurora PostgreSQL, and Oracle databases.
• Integrate PostgreSQL with existing IT infrastructures.
• Develop, configure, and deploy monitoring and alerting systems using tools such as Prometheus and Grafana or similar platforms.
• Monitor and troubleshoot database performance metrics to proactively address potential bottlenecks.
• Perform other duties as assigned.

Benefits

• Medical, dental, and vision insurance
• Wellness Program
• Flexible Spending Accounts for healthcare, dependent care, and commuter expenses
• Short-term and long-term disability options
• Company-provided basic life and AD&D insurance
• Voluntary life and AD&D options
• 401(k) Retirement Savings Plan with matching after one year
• Paid Time Off

What This Job Offers

• Job Type: Full-time
• Career Level: Senior