Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the migration of databases for critical applications to PostgreSQL with minimal downtime.
- Company: Join a dynamic team focused on modernising data infrastructure in a high-impact project.
- Benefits: Enjoy a flexible 6-month contract with potential extensions and opportunities for growth.
- Why this job: Be part of a transformative project that enhances your skills and impacts the future of technology.
- Qualifications: Experience as a PostgreSQL DBA, especially in large-scale migrations, is essential.
- Other info: Work in vibrant Edinburgh or London, collaborating with diverse teams on exciting challenges.
The predicted salary is between 48000 - 72000 £ per year.
Location: Edinburgh or London
Type: 6 month contract with extensions up to a further 12 months
About the Role:
We are seeking a highly skilled PostgreSQL Database Administrator (DBA) to join our team and lead critical migration initiatives involving a high volume number of applications, including complex payments systems. This is a key role in a high-impact project aimed at modernising our data infrastructure and ensuring seamless transition from legacy platforms to PostgreSQL.
Key Responsibilities:
- Lead the end-to-end migration of databases for 34 business-critical applications to PostgreSQL.
- Plan, coordinate, and execute migration strategies with minimal downtime and risk.
- Ensure the integrity, security, and performance of databases throughout the migration lifecycle.
- Collaborate with development, infrastructure, and payments teams to align data models and application requirements.
- Troubleshoot and resolve database issues, performance bottlenecks, and replication challenges.
- Develop documentation, migration runbooks, and operational procedures.
- Contribute to the long-term optimisation, automation, and scalability of our PostgreSQL environments.
Required Skills & Experience:
- Proven experience as a PostgreSQL DBA, particularly in large-scale migration projects.
- Deep understanding of PostgreSQL architecture, configuration, tuning, and security best practices.
- Experience with payment systems, transactional data, and high-availability requirements.
- Familiarity with legacy-to-PostgreSQL migration tools and processes (e.g., AWS DMS, pg_dump/pg_restore, logical replication).
- Strong scripting skills (e.g., Bash, Python) and familiarity with CI/CD pipelines.
- Ability to manage complex dependencies and stakeholder communication across multiple applications.
Desirable:
- Experience with cloud-based PostgreSQL (e.g., AWS RDS, Azure Database for PostgreSQL).
- Knowledge of PCI-DSS compliance or other financial services regulations.
- Exposure to DevOps or Infrastructure-as-Code (IaC) environments.
postgresSQL DBA - Migration Specialist employer: Lorien
Contact Detail:
Lorien Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land postgresSQL DBA - Migration Specialist
✨Tip Number 1
Make sure to showcase your experience with large-scale migration projects in PostgreSQL. Highlight specific examples where you successfully led migrations, as this will demonstrate your capability to handle the responsibilities of the role.
✨Tip Number 2
Familiarise yourself with the tools and processes mentioned in the job description, such as AWS DMS and logical replication. Being able to discuss these tools confidently during an interview will show that you're prepared and knowledgeable about the migration landscape.
✨Tip Number 3
Network with professionals in the PostgreSQL community or join relevant forums. Engaging with others in the field can provide insights into best practices and may even lead to referrals for the position.
✨Tip Number 4
Prepare to discuss your scripting skills and how they relate to CI/CD pipelines. Be ready to explain how you've used scripting to automate tasks or improve database performance in past roles, as this is a key aspect of the job.
We think you need these skills to ace postgresSQL DBA - Migration Specialist
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience as a PostgreSQL DBA, especially focusing on any large-scale migration projects you've worked on. Use specific examples that demonstrate your skills in database architecture, configuration, and security best practices.
Craft a Compelling Cover Letter: In your cover letter, explain why you're interested in the role and how your background aligns with the key responsibilities listed in the job description. Mention your experience with payment systems and any relevant tools or processes you’ve used for migrations.
Showcase Relevant Skills: Emphasise your scripting skills and familiarity with CI/CD pipelines in your application. If you have experience with cloud-based PostgreSQL or compliance regulations like PCI-DSS, make sure to include that as well.
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 role involving database management.
How to prepare for a job interview at Lorien
✨Showcase Your Migration Experience
Be prepared to discuss your previous experiences with database migrations, especially involving PostgreSQL. Highlight specific projects where you led the migration process, detailing the challenges faced and how you overcame them.
✨Demonstrate Technical Proficiency
Make sure to brush up on your knowledge of PostgreSQL architecture, configuration, and tuning. Be ready to answer technical questions and possibly solve problems on the spot to showcase your expertise.
✨Understand the Business Context
Familiarise yourself with the company's business-critical applications and how they relate to payment systems. This will help you articulate how your role as a DBA can directly impact their operations and success.
✨Prepare for Collaboration Questions
Since this role involves working closely with various teams, be ready to discuss your experience in cross-functional collaboration. Share examples of how you've effectively communicated and coordinated with development and infrastructure teams in past projects.
