Senior PostgreSQL Database Engineer

• Design, implement, and maintain scalable and available PostgreSQL database systems.
• Optimize performance, fine-tune queries, and design schemas for efficient data storage and retrieval.
• Develop and enforce database policies, standards, and procedures to ensure secure and efficient operations.
• Lead database migrations, upgrades, and patch management efforts without disrupting business operations.
• Collaborate with development teams to integrate databases with applications, advising on data access strategies and transaction management.
• Monitor database performance, implement changes, and apply patches and updates as needed.
• Provide expert guidance on PostgreSQL features and best practices to both technical and non-technical team members.
• Manage backup and disaster recovery processes to ensure data integrity and availability.
• Troubleshoot and resolve complex database issues, conducting root cause analysis and implementing preventive measures.
• Stay updated on industry trends and advancements in database technologies, recommending new tools and techniques to enhance our systems.

• Participate in strategic planning sessions to enhance database operations and initiatives.
• Conduct capacity planning to manage database growth and resource allocation effectively.
• Develop and maintain robust database security protocols to safeguard sensitive data.
• Collaborate with cross-functional teams to ensure database solutions meet business objectives.
• Implement automation tools to streamline database administration tasks and minimize errors.
• Create and maintain comprehensive documentation for database environments.
• Mentor junior database engineers and promote a culture of continuous learning within the team.
• Manage relationships with software and service vendors, ensuring compliance with service level agreements.
• Lead incident management for any database-related issues, minimizing impact on operations.

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• Minimum of 5 years of experience in database administration, design, and management, with a focus on PostgreSQL.
• Expert knowledge of PostgreSQL architecture, configuration, and administration.
• Strong proficiency in SQL and database programming languages.
• Experience with cloud-based database solutions (AWS RDS, Google Cloud SQL, Azure PostgreSQL, EDB) is desirable.
• Excellent problem-solving skills and ability to communicate technical concepts effectively.
• Experience in leading and mentoring junior engineers.

Michael Page