PostgreSQL Database Administrator (DBA)

Company Overview

Not specified.

Job Summary

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.

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 database-related 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

• Educational Requirement: Bachelor’s 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.
• Solid understanding of AWS Cloud and concepts, including AWS RDS/Aurora experience.
• Familiarity with database monitoring tools and performance tuning utilities.
• Experience with database security principles and best practices.
• Strong analytical and problem-solving 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.

Preferred Skills

• Familiarity with a variety of database monitoring tools and performance tuning utilities.

Experience

Proven experience as a PostgreSQL Database Administrator or in a similar role is required.

Environment

Typical work setting is not specified. Additional details regarding location (remote, in-office, hybrid) are not provided.

Salary

Not specified.

Growth Opportunities

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.

Benefits

Not specified.