Postgres DB Expert

Postgres DB Expert

Whitehall Resources are currently looking for a Postgres DB Expert on a Hybrid basis in Norwich for an initial 6 month contract.

*INSIDE IR35.*

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.

Main 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 database-related issues, providing support to development teams and end-users.
• Documentation: Create and maintain documentation for database configurations, procedures, and policies.
• Collaboration: Work closely with developers, system administrators, and business analysts to support database-related needs.
• Training: Provide training and mentorship to junior database administrators and other team members.

Key Skills:

• 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 (eg, Oracle, MySQL), cloud platforms (eg, AWS, Azure), and automation tools.

All of our opportunities require that applicants are eligible to work in the specified country/location, unless otherwise stated in the job description.

Whitehall Resources are an equal opportunities employer who value a diverse and inclusive working environment. All qualified applicants will receive consideration for employment without regard to race, religion, gender identity or expression, sexual orientation, national origin, pregnancy, disability, age, veteran status, or other characteristics.