Postgres DB Expert

TN United Kingdom; Norwich; Hybrid; GBP 50,000 - 80,000; Full time

Job summary

An established industry player is seeking a Postgres Senior SME to enhance their database management capabilities. This hybrid role combines remote work with in-office collaboration, allowing you to optimize PostgreSQL databases while ensuring security and reliability. You will lead database administration, performance tuning, and provide expert guidance to development teams. Your ability to communicate effectively and mentor junior staff will be key to success in this position. Join a forward-thinking organization that values innovation and teamwork, and make a significant impact on their database systems.

Qualifications

• Proven experience in managing PostgreSQL databases with a focus on performance and security.
• Strong client-facing skills and ability to provide mentorship to junior team members.

Responsibilities

• Manage and maintain PostgreSQL databases, ensuring performance and reliability.
• Optimize database performance through query tuning and indexing.

Skills

SQL

PL/pgSQL

Database Design Principles

Performance Tuning

Backup and Recovery Techniques

Database Security Best Practices

Problem-Solving Skills

Communication Skills

Teamwork Abilities

PostgreSQL Certification

Tools

AWS

Azure

Oracle

MySQL

Automation Tools

Job description

Social network you want to login/join with:

Work Location: Norwich, UK (Hybrid 2 to 3 days)

Role Description:

The Postgres Senior SME is responsible for the administration, optimization, and support of PostgreSQL databases within the organization. This role involves ensuring the performance, security, and reliability of database systems, as well as providing expert guidance to development teams and business users.

Key Responsibilities:

1. Database Administration: Manage and maintain PostgreSQL databases, including installation, configuration, and upgrades.
2. Performance Tuning: Optimize database performance through query tuning, indexing, and schema design.
3. Experience of performance tuning in a data warehousing application.
4. Backup and Recovery: Implement and manage backup strategies and disaster recovery plans.
5. Security: Ensure database security by implementing best practices and monitoring for vulnerabilities.
6. Troubleshooting: Diagnose and resolve database-related issues, providing support to development teams and end-users.
7. Documentation: Create and maintain documentation for database configurations, procedures, and policies.
8. Collaboration: Work closely with developers, system administrators, and business analysts to support database-related needs.
9. Training: Provide training and mentorship to junior database administrators and other team members.

Key Skills / Knowledge / Experience:

• Proficiency in SQL and PL/pgSQL.
• Strong understanding of database design principles.
• Experience with performance tuning and optimization.
• Knowledge of backup and recovery techniques.
• Familiarity with database security best practices.
• Excellent problem-solving and analytical skills.
• Strong communication and teamwork abilities.
• Certifications: PostgreSQL certification or other relevant database certifications.
• Additional Skills: Experience with other database systems (e.g., Oracle, MySQL), cloud platforms (e.g., AWS, Azure), and automation tools.

Person Specification:

Client-facing role with excellent communication skills is essential.