Job Title: Postgres DB Expert
Work Location: Norwich UK (Hybrid 2 to 3days)
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:
-
Database Administration: Manage and maintain PostgreSQL databases including installation configuration and upgrades
-
Performance Tuning: Optimize database performance through query tuning indexing and schema design
-
Experience of performance tuning in a data warehousing application
-
Backup and Recovery: Implement and manage backup strategies and disaster recovery plans
-
Security: Ensure database security by implementing best practices and monitoring for vulnerabilities
-
Troubleshooting: Diagnose and resolve databaserelated issues providing support to development teams and endusers
-
Documentation: Create and maintain documentation for database configurations procedures and policies
-
Collaboration: Work closely with developers system administrators and business analysts to support databaserelated needs
-
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 problemsolving 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: