Senior PostgreSQL DBA – Performance, HA & Security

Cayuse Holdings; Washington (District of Columbia); On-site; USD 140,000 - 142,000; Full time

Benefits offered by this job

Medical, Dental and Vision Insurance

Flexible Spending Accounts

Disability options

Life Insurance (Company Provided)

401(k) Retirement Savings Plan

Paid Time Off

Job summary

Cayuse is seeking a Senior PostgreSQL Database Administrator to support client production environments, ensuring the performance, integrity, and security of PostgreSQL databases. This role will design architecture, oversee installation, configuration, and tuning to meet business needs.

The ideal candidate will have strong PostgreSQL expertise, SQL/PL/pgSQL, Linux/Unix experience, and knowledge of HA/DR and security patches. On-site in the National Capitol Region is required.

Qualifications

• Bachelor’s or master’s degree in computer science, IT, or related field.
• Strong expertise in PostgreSQL database administration, tuning, management and security.
• Proficiency in SQL and PL/pgSQL or similar procedural language.
• Familiarity with database design, documentation, and coding.
• Experience with Linux/Unix and scripting languages such as Bash, Python or Perl.
• Knowledge of high availability and disaster recovery options for PostgreSQL.
• Good understanding of hardware performance, memory and I/O.
• Top Secret Clearance is required.
• Must be able to pass a background check.

Responsibilities

• Design and implement database architecture that supports business requirements and achieves high performance, availability, and security.
• Oversee the installation, configuration, and maintenance of PostgreSQL databases.
• Conduct performance tuning of database systems, including queries, stored procedures, and indexing strategies.
• Develop and implement database backup, recovery, and failover procedures.
• Assist in the design and development of data models and database solutions.
• Collaborate with development teams to optimize database code in application layers.
• Provide guidance on databases of the best practices for IT staff and other stakeholders.
• Ensure database infrastructure is up to date with the latest technology trends and security patches.
• Develop and maintain documentation regarding database configurations, architectures, and procedures.
• Serve as the point of contact for database-related queries and technical support.
• Other duties as assigned.

Skills

PostgreSQL administration

SQL proficiency

Linux/Unix scripting

High availability & DR

Performance tuning

Database security

Documentation skills

Education

Bachelor’s or Master’s degree in computer science, Information Technology, or a related field

Tools

PL/pgSQL

Shell scripting (Bash)

Docker

Kubernetes

Job description

Cayuse is seeking a Senior PostgreSQL Database Administrator to support client production environments, ensuring the performance, integrity, and security of PostgreSQL databases. This role will design architecture, oversee installation, configuration, and tuning to meet business needs.

The ideal candidate will have strong PostgreSQL expertise, SQL/PL/pgSQL, Linux/Unix experience, and knowledge of HA/DR and security patches. On-site in the National Capitol Region is required.