Bachelor's or master's degree in computer science, IT, or related field.
Strong expertise in PostgreSQL administration, tuning, and security.
Proficiency in SQL and experience with PL/pgSQL or similar languages.
Familiarity with database design, documentation, and coding.
Experience with Linux/Unix and scripting languages like Bash, Python, or Perl.
Knowledge of high availability and disaster recovery for PostgreSQL.
Strong analytical, problem-solving, and communication skills.
Responsibilities
Design and implement database architecture for performance, availability, and security.
Oversee installation, configuration, and maintenance of PostgreSQL databases.
Conduct performance tuning of database systems, including queries and indexing.
Develop and implement database backup, recovery, and failover procedures.
Assist in designing data models and database solutions.
Collaborate with development teams to optimize database code.
Provide guidance on database best practices to IT staff and stakeholders.
Benefits
Opportunity to lead a database team in a critical federal agency.
Work on advanced technology trends in the security sector.
Access to professional development and continuous learning.
Collaboration with multidisciplinary teams and stakeholders.
Full 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.
