Postgres Database Administrator

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

Overview

The Postgres Database Administrator, Senior, will support the database operations for our client to strengthen and expand the client’s production environment. This role will ensure the performance, integrity, and security of the unit’s PostgreSQL database.

This position performs all duties and responsibilities in accordance with the Mission, Vision, and Core Values of Cayuse.

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.

Qualifications

• Bachelor’s or master’s degree in computer science, Information Technology, or a related field.


• Strong expertise in PostgreSQL database administration, tuning, management, and security.


• Proficiency in SQL and experience with PL/pgSQL or similar procedural language.


• Familiarity with database design, documentation, and coding.


• Previous 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. May require additional background checks as required by projects and/or clients at any time during employment.

Minimum Skills:

• Exceptional interpersonal skills with the ability to communicate in a clear, professional, and articulate manner.


• Exceptional verbal and written communication skills.


• Excellent organizational, analytical, and problem-solving skills with high-level attention to detail.


• Proven ability to multitask and prioritize in a fast past environment with changing priorities; adaptable to change and a quick learner.


• Must be self-motivated and able to work well independently as well as on a multi-functional team.


• Ability to handle sensitive and confidential information appropriately


• Proficient in MS Office, Word, Outlook, PowerPoint, and Excel.

Desired Qualifications:

• PostgreSQL certification (e.g., PostgreSQL Certified Engineer).


• Experience with cloud services (AWS, Azure, OCI) and containerization technologies (Docker, Kubernetes).


• Familiarity with other database systems (e.g. Oracle and MSSQL

Our Commitment to you / overview of benefits

• Medical, Dental and Vision Insurance; Wellness Program


• Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)


• Short-Term and Long-Term Disability options


• Basic Life and AD&D Insurance (Company Provided)


• Voluntary Life and AD&D options


• 401(k) Retirement Savings Plan with matching after one year


• Paid Time Off

Reports to: Program Manager

Working Conditions

• Professional office environment.


• Ability to work on-site at client’s facility in the National Capitol Region.


• Must be physically and mentally able to perform duties extended periods of time.


• Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.


• Must be able to establish a productive and professional workspace.


• Must be able to sit for long periods of time looking at computer screen.


• May be asked to work a flexible schedule which may include holidays.


• May be asked to travel for business or professional development purposes.


• May be asked to work hours outside of normal business hours.

Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Cayuse is an Equal Opportunity Employer. All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.

Pay Range

USD $140,000.00 - USD $142,085.00 /Yr.