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)
