PostgreSQL Database Administrator

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