HiringCafe
Posted 6mo ago

PostgreSQL Senior Database Administrator - TS required to apply - Wash DC

@ Bow Wave
View All Jobs
Washington, District of Columbia, United States
$145k-$155k/yrOnsiteFull Time
Responsibilities:Design database architecture, Oversee installation, Tune performance
Requirements Summary:Experience administering PostgreSQL, performance tuning, backup/recovery, security; strong SQL/PL/pgSQL; Linux scripting; BA/BS in CS/IT.
Technical Tools Mentioned:PostgreSQL, Linux, Bash, Python, Perl, PL/pgSQL, Docker, Kubernetes, Oracle, MSSQL, AWS, Azure, OCI
Save
Mark Applied
Hide Job
Report & Hide
Job Description

A part of the FBI is seeking an experienced PostgreSQL Senior Database Administrator to lead our database team. The ideal candidate will have a robust background in database administration, architecture, and PostgreSQL development. The DBA will be responsible for ensuring the performance, integrity, and security of the unit's PostgreSQL databases. 

 

Responsibilities and Duties:

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

 

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.
  • Strong analytical and problem-solving skills.
  • Excellent communication and mentoring skills. 

 

Preferred 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)

Health, Retirement, other