At a Glance
- Tasks: Manage PostgreSQL databases and collaborate on exciting projects in a remote setting.
- Company: Join a dynamic tech company focused on operational excellence and teamwork.
- Benefits: Competitive salary, remote work flexibility, and opportunities for professional growth.
- Other info: Be part of a supportive team that values integrity, growth, and innovation.
- Why this job: Make a real impact by optimising database performance and ensuring high availability.
- Qualifications: Experience with PostgreSQL administration and a passion for problem-solving.
The predicted salary is between 51750 - 63250 £ per year.
Remote Full-time Not specified Operations
Job Description
We are looking for a hands-on Postgre SQL DBA to help manage database services across our on-premises infrastructure and GCP.
The role combines production operations with project work, including migration from Community Postgre SQL to EDB Postgres, high-availability standardization, database consolidation, and operational automation.
You will work closely with DBAs, SRE, infrastructure, application, and security teams.
We need someone who can assess the current environment, identify risks and improvements, recommend practical solutions, and follow them through to stable production operations.
- Here are the core functions, responsibilities, and expectations for this role:
- Postgre SQL and EDB administration.
Administer the full database lifecycle, including installation, configuration, patching, upgrades, capacity planning, security, monitoring, incident response, and decommissioning.
- High availability with EFM.
Configure, operate, monitor, and troubleshoot EDB Failover Manager clusters; perform planned switchovers and failover tests; validate application connectivity; and safely reintegrate failed or former primary nodes.
- Backup and recovery with Barman.
Configure and monitor base backups and WAL archiving or streaming, manage retention, execute point-in-time recovery, and conduct documented restore and disaster-recovery tests against agreed RPO and RTO targets.
- Monitoring and alerting with PEM.
Register and manage servers and agents, configure meaningful metrics and alert thresholds, investigate alerts and performance trends using graphs, and maintain notification and escalation integrations.
- Automation and version control.
Use TPA and Ansible/Spacelift to build repeatable Postgre SQL/EDB environments and maintain playbooks and configuration in Git and Git Hub using branches, pull requests, and peer review.
- Replication and recovery.
Configure and troubleshoot physical streaming and logical replication, replication slots, WAL retention, lag, and timeline issues; use pg_rewind when appropriate to resynchronize a node after timelines diverge.
- Performance engineering.
Analyze execution plans and wait or lock behavior, tune SQL and indexes, and optimize Postgre SQL and operating-system settings, including autovacuum, memory, storage, and checkpoint or WAL behavior.
- Connectivity and security.
Operate Pg Bouncer and manage roles, privileges, authentication, pg_hba. conf, TLS, secrets, and least-privilege access in line with organizational standards.
- Migrations and consolidation.
Plan and execute major and minor version upgrades, Community Postgre SQL-to-EDB migrations, and database consolidation with validated rollback, testing, and minimal downtime.
- Operational ownership.
Create runbooks and architecture documentation, participate in change and incident processes, collaborate with engineering teams, and join an on-call rotation for production emergencies.
- Additional tasks associated with this position may be assigned in response to company initiatives and business needs.
More information about this role
This is a full-time and remote position based in the U.
The target compensation package for this role is between GBP 50,000 and 54,000, subject upon internal equity and years of experience.
We may make further adjustments through an approval process if the targeted compensation range needs to be modified based on business needs and market trends.
Simplicity at Scale.
How we show up with each other and our customers every day is just as important, and we win as #One Sectigo by living out our core values - Support, Excellence, Communication, Teamwork, Integrity, Growth and Openness.
We are committed to investing in our diverse teams where everyone understands their role and how they support our strategic goals, we drive operational excellence through scale and efficiency, and we strive to delight our customers and become the market leader in our industry.
If you aspire to join a driven team that holds each other accountable to meeting our lofty goals and you’d like to be part of…
PostgreSQL Database Administrator in Manchester employer: Webhosting
Fasthosts is an exceptional employer, offering a dynamic work environment in Gloucester where you can thrive as a Hybrid Technical Support Specialist. With a strong focus on employee development, comprehensive benefits, and a vibrant team culture, we ensure that our staff feel valued and supported while providing top-notch service to our customers. Join us for a rewarding career that not only enhances your skills but also allows for meaningful contributions to our innovative product range.
StudySmarter Expert Advice🤫
We think this is how you could land PostgreSQL Database Administrator in Manchester
✨Tap into Local Tech Meetups
Get yourself to local tech meetups or database management conferences. It's a really great way to meet industry professionals and potentially uncover unadvertised full-time roles. When chatting with people, mention your skills and interests in database management; you never know who might be looking for someone just like you!
✨Contribute to Open Source Projects
Diving into open-source projects can not only sharpen your database skills but also get you noticed by employers. Many companies look for candidates who actively contribute to projects – it shows initiative and a real passion for the field. Plus, it's a perfect excuse to connect with other developers and expand your professional network.
✨Utilise Professional Bodies
Sign up for professional bodies related to database management, like the British Computer Society. They often host events and networking opportunities that can lead directly to job openings in the full-time market. Plus, it adds a nice touch to your professional profile!
✨Showcase Your Skills in a Public Portfolio
As you’re on the hunt for that full-time role, make sure to have a public portfolio that displays your best database projects. This can easily set you apart from the competition. And when you apply for roles, definitely mention it – it shows employers you mean business and are proud of your work!
We think you need these skills to ace PostgreSQL Database Administrator in Manchester
Some tips for your application 🫡
Show off your database skills:When applying for a full-time role in database management, it’s super important to highlight your skills with specific database technologies like SQL, NoSQL, or any relevant data visualisation tools. We want to see how you've used these tools in real projects, so don't shy away from detailing your hands-on experience!
Tailor your CV for data:Make sure your CV is structured clearly, focusing on your previous experience in database management. Use specific metrics to demonstrate your impact, like how you improved data retrieval times or reduced errors. This isn't just about what you've done; it’s about what you’ve achieved with your skills!
Craft a compelling cover letter:In your cover letter, share what excites you about database management and how you can contribute to Webhosting. Mention any relevant projects where you tackled challenges or implemented new solutions. Let us know why you want to join our team and how your passion aligns with our goals.
Document your projects:If you've worked on interesting database projects—maybe during your studies or in previous roles—be sure to include those in your application. If you can, link to a portfolio or GitHub repo where we can see examples of your work. Having a tangible showcase of your skills will really make your application stand out!
How to prepare for a job interview at Webhosting
✨Brush Up on Database Tools
Make sure you're well-versed with popular database management systems like MySQL, PostgreSQL, or MongoDB. Incorporating real-world examples of how you've used these tools in past projects will show that you can put theory into practice, which is something Webhosting will definitely appreciate.
✨Know Your SQL Inside Out
Get ready for some technical questions focused on SQL queries and database design. We should anticipate coding challenges where you might need to optimise queries or design a database schema on the spot. Practising these problems will build our confidence to impress in the interview.
✨Demonstrate Problem-Solving Skills
Besides just technical know-how, be prepared to answer scenario-based questions that test your critical thinking and problem-solving abilities. Think about how you would approach data integrity issues or handle performance bottlenecks — Webhosting will want to see your analytical side!
✨Show Your Collaboration Spirit
Since this is a full-time role, it's crucial to highlight how you've collaborated with cross-functional teams or contributed to team projects in the past. Emphasising our interpersonal skills will demonstrate that you’re not just a tech wizard, but also a team player who fits well with Webhosting's culture.