PostgreSQL DBA

Job Description: PostgreSQL Database Administrator (DBA)

Position Overview:
We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) to join our team. As a PostgreSQL DBA you will be responsible for the administration maintenance and optimization of our PostgreSQL database systems. You will play a critical role in ensuring the performance availability and security of our databases while supporting the needs of our applications and users.

Key Responsibilities:
Install configure and maintain PostgreSQL database instances across multiple environments (development testing production) following best practices.
Monitor the performance and health of PostgreSQL databases proactively identifying and resolving any issues or bottlenecks to ensure optimal performance.
Design and implement efficient database schemas tables and indexes to support application requirements.
Collaborate with development teams to optimize SQL queries database access patterns and overall system performance.
Implement and maintain database backup and recovery strategies to ensure data integrity and minimize downtime.
Configure and maintain database security measures including user access controls authentication and encryption.
Perform database tuning and optimization including query optimization index tuning and configuration tuning.
Troubleshoot and resolve databaserelated incidents such as database errors performance issues and data integrity problems.
Conduct capacity planning to ensure database scalability and accommodate future growth.
Stay updated with the latest PostgreSQL features releases and security patches and apply them as appropriate.
Document and maintain database standards procedures and configurations.
Collaborate with other infrastructure teams to ensure smooth integration and operation of databases with related systems.

Qualifications:
Bachelors degree in Computer Science Information Technology or a related field. Equivalent work experience may be accepted.
Proven experience as a PostgreSQL Database Administrator or similar role with a strong understanding of PostgreSQL architecture administration and performance tuning.
Proficiency in PostgreSQL database administration including installation configuration monitoring backup and recovery and security management.
Solid understanding of relational database concepts and SQL query optimization techniques.
Experience with database design and schema optimization for performance and scalability.
Knowledge of High Availability (HA) and Disaster Recovery (DR) concepts and implementations for PostgreSQL.
Familiarity with database monitoring tools and performance tuning utilities.
Experience with database security principles and best practices.
Strong analytical and problemsolving skills with the ability to diagnose and resolve complex database issues.
Good understanding of Linux/Unix environments and scripting languages (e.g. Bash Python).
Excellent communication and collaboration skills with the ability to work effectively in a team environment.
Relevant certifications such as PostgreSQL Certified Professional are a plus.

As a PostgreSQL DBA you will play a crucial role in maintaining the stability and performance of our database infrastructure. You will have the opportunity to work with a talented team and contribute to the success of our applications and systems. If you are a detailoriented and motivated individual with a strong background in PostgreSQL database administration we would love to hear from you.

Note: This job description serves as a general overview outlining the typical responsibilities and qualifications of the PostgreSQL DBA role. Actual job duties may vary depending on the specific needs and priorities of the or

Remote Work :

No