Postgres DB Expert

Postgres DB Expert

London Temporary 43200 - 72000 £ / year (est.) Home office (partial)
W

At a Glance

  • Tasks: Manage and optimise PostgreSQL databases while supporting development teams.
  • Company: Whitehall Resources is a diverse employer focused on inclusion and equal opportunities.
  • Benefits: Enjoy a hybrid work model with flexible hours and a supportive team environment.
  • Why this job: Join a dynamic team, enhance your skills, and make a real impact in database management.
  • Qualifications: Proficiency in SQL, experience with performance tuning, and strong problem-solving skills required.
  • Other info: This is a 6-month contract role, ideal for those looking to grow in a tech-savvy environment.

The predicted salary is between 43200 - 72000 £ per year.

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 with performance tuning in data warehousing applications is preferred.
  • 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, supporting 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 needs.
  • Training: Provide training and mentorship to junior database administrators and 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
  • PostgreSQL certification or relevant database certifications

Additional Skills:

  • Experience with other database systems (e.g., Oracle, MySQL), cloud platforms (e.g., AWS, Azure), and automation tools

All applicants must be eligible to work in the specified country/location. Whitehall Resources is an equal opportunities employer committed to diversity and inclusion. All qualified applicants will receive consideration without regard to race, religion, gender identity or expression, sexual orientation, national origin, pregnancy, disability, age, veteran status, or other characteristics.

Postgres DB Expert employer: Whitehall Resources Ltd

Whitehall Resources is an exceptional employer, offering a dynamic work environment in Norwich that fosters collaboration and innovation. With a strong commitment to employee growth, we provide opportunities for training and mentorship, ensuring our team members can enhance their skills and advance their careers. Our inclusive culture values diversity and promotes a healthy work-life balance, making it a rewarding place to contribute your expertise as a Postgres DB Expert.
W

Contact Detail:

Whitehall Resources Ltd Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Postgres DB Expert

✨Tip Number 1

Network with professionals in the PostgreSQL community. Attend local meetups or online webinars to connect with others in the field, as they might have insights or even job leads that could help you land the role.

✨Tip Number 2

Showcase your expertise by contributing to open-source PostgreSQL projects or forums. This not only enhances your skills but also demonstrates your commitment and knowledge to potential employers.

✨Tip Number 3

Prepare for technical interviews by practising common PostgreSQL scenarios, such as performance tuning and backup strategies. Being able to discuss these topics confidently can set you apart from other candidates.

✨Tip Number 4

Research Whitehall Resources and their projects. Understanding their work culture and specific needs can help you tailor your discussions during interviews, showing that you're genuinely interested in the role.

We think you need these skills to ace Postgres DB Expert

Proficiency in SQL
Proficiency in PL/pgSQL
Database Administration
Performance Tuning
Query Tuning
Indexing
Schema Design
Backup and Recovery Techniques
Database Security Best Practices
Troubleshooting Skills
Documentation Skills
Collaboration Skills
Training and Mentorship
Analytical Skills
Strong Communication Skills
Teamwork Abilities
PostgreSQL Certification
Experience with Oracle
Experience with MySQL
Familiarity with Cloud Platforms (e.g., AWS, Azure)
Experience with Automation Tools

Some tips for your application 🫡

Understand the Role: Before applying, make sure you fully understand the responsibilities and key skills required for the Postgres DB Expert position. Tailor your application to highlight your relevant experience in database administration, performance tuning, and security.

Highlight Relevant Experience: In your CV and cover letter, emphasise your proficiency in SQL and PL/pgSQL, as well as any experience with performance tuning and backup strategies. Mention specific projects or achievements that demonstrate your expertise in PostgreSQL.

Showcase Soft Skills: The job requires strong communication and teamwork abilities. Include examples of how you've collaborated with developers or provided training to junior team members in your previous roles.

Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a technical role like this.

How to prepare for a job interview at Whitehall Resources Ltd

✨Showcase Your SQL Skills

Make sure to brush up on your SQL and PL/pgSQL knowledge before the interview. Be prepared to discuss specific queries you've optimised or complex problems you've solved using these languages.

✨Demonstrate Performance Tuning Experience

Since performance tuning is a key responsibility, come ready to share examples of how you've improved database performance in past roles. Discuss any experience you have with data warehousing applications as this is preferred.

✨Discuss Backup and Recovery Strategies

Be prepared to talk about your experience with backup strategies and disaster recovery plans. Highlight any specific tools or techniques you've used to ensure data integrity and security.

✨Emphasise Collaboration and Communication

This role requires working closely with various teams, so be ready to discuss how you've collaborated with developers and analysts in the past. Strong communication skills are essential, so demonstrate your ability to convey complex information clearly.

W
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>