We are seeking an experienced PostgreSQL Senior Database Administrator to help 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 architectures that support business requirements and achieve 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 database best practices to 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.
Basic 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/SQL or similar procedural language
- Experience in Oracle to Postgres conversion/migration (metadata & data)
- Experience in Oracle 19C/21C and Postgres 16/17 database administration, support, implementation, configuration and upgrade.
- 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
- Active TS clearance required with ability to obtain SCI
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
#LI-PublicSafety