PostgreSQL Database Administrator - Senior

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 Postgre

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

Qualifications:

* Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.

* Strong expertise in Postgre

SQL 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 Postgre

SQL.

* Good understanding of hardware performance, memory and I/O.

* Strong analytical and problem-solving skills.

* Excellent communication and mentoring skills.

Preferred Qualifications:

* Postgre

SQL certification (e.g., Postgre

SQL Certified Engineer).

* Experience with cloud services (AWS, Azure, OCI) and containerization technologies (Docker, Kubernetes).

* Familiarity with other database systems (e.g. Oracle and MSSQL