Database Administrator, Senior, PostgreSQL

Cayuse Holdings•Washington, DC

52d•$125,000 - $139,800•Onsite

About The Position

The Database Administrator, Senior, PostgreSQL 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.

Requirements

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

Nice To Haves

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

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.