At a Glance
- Tasks: Manage and optimise PostgreSQL databases on AWS, collaborating with developers for performance improvements.
- Company: Join SoSafe, a leading human risk management provider in Europe.
- Benefits: Wellbeing support, corporate discounts, virtual events, and tech equipment.
- Other info: Remote role available for candidates in the UK, Portugal, or Ireland.
- Why this job: Be part of the solution to combat cybercrime while working with cutting-edge technology.
- Qualifications: 5+ years of PostgreSQL experience, strong SQL skills, and AWS knowledge.
The predicted salary is between 60000 - 80000 £ per year.
SoSafe has the ambition to become the leading human risk management provider in Europe. Our award-winning awareness platform triggers behavioural change by providing effective and engaging training and simulations on cybersecurity and data protection. Cybercrime is predicted to cost the world $10.5 trillion annually by 2025 - we invite you to be part of the solution!
Location Requirement: This role is open to candidates currently based in and legally authorized to work in the UK, Portugal, or Ireland. We are unable to consider applicants outside these locations.
Your Mission: We are seeking a qualified and proactive Senior PostgreSQL Database Engineer with hands-on experience in AWS RDS and Aurora, and a collaborative mindset for assisting development teams. In this role, you will manage PostgreSQL infrastructure, tune performance, and contribute to database design and code reviews to ensure scalable, efficient, and maintainable data solutions.
The ideal candidate combines hands-on operational database administration experience with the knowledge to understand application-level requirements, effective communication to facilitate dialogue with developers, and the capacity to actively assist them in optimizing SQL and database usage.
Here’s how you'll make a difference:
- Administer, monitor, and optimize PostgreSQL databases running on Amazon RDS and Aurora.
- Perform regular database maintenance tasks, including backup validation, replication checks, patching, and upgrades.
- Collaborate with developers to optimize SQL and database objects, maintain PL/pgSQL routines, and contribute to data modeling initiatives to enhance performance.
- Set up and fine-tune database performance metrics, logs, and alerts using AWS CloudWatch, pg_stat_statements, and other tools.
- Identify and improve slow-running queries.
- Implement and manage access control, auditing, and security policies in line with organizational standards.
- Create and maintain database documentation and deployment scripts.
- Contribute to and follow best practices for schema changes, migrations, and version control of database objects (GitHub experience is a plus).
- Contribute to DevOps processes, including database CI/CD and automation of schema deployment automation.
What makes you a great fit:
- 5+ years of hands-on experience operating and scaling PostgreSQL in high-availability production environments.
- Advanced expertise in SQL and PL/pgSQL, including complex query optimization and partitioning strategies.
- Strong experience in performance tuning, query plan analysis, and index optimization.
- Deep experience with Amazon RDS for PostgreSQL, including scaling, parameter tuning, backups, and disaster recovery.
- Experience designing PostgreSQL integrations with AWS services (e.g., Lambda, S3) in distributed systems.
- Advanced knowledge of data modeling, normalization, and enforcing data integrity at scale.
- Strong experience with monitoring and diagnostics tools such as pg_stat_statements and auto_explain.
- Experience improving CI/CD pipelines for database deployments and defining database best practices.
- Comfortable mentoring peers, leading code reviews, and influencing cross-team technical decisions.
- Strong ownership mindset, clear stakeholder communication, and willingness to support on-call reliability.
What we offer:
- Wellbeing and financial support: Access to Open Up, corporate discounts.
- Connection & community: Virtual events, collaborative team activities, and opportunities for local meet-ups.
- And the list goes on: Tech equipment, referral bonuses, dog-friendly HQ.
Senior Postgres AWS Database Engineer (Remote) in London employer: Sosafe Awareness
Contact Detail:
Sosafe Awareness Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Postgres AWS Database Engineer (Remote) in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the tech world, especially those who work with PostgreSQL or AWS. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio or GitHub repository showcasing your database projects and optimisations. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common PostgreSQL and AWS questions. Practise explaining your past experiences and how you've tackled challenges in database management. Confidence is key!
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Senior Postgres AWS Database Engineer (Remote) in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Senior PostgreSQL Database Engineer role. Highlight your hands-on experience with AWS RDS and Aurora, and don’t forget to showcase your SQL and PL/pgSQL skills. We want to see how you’ve made a difference in previous roles!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about cybersecurity and how your experience aligns with our mission at SoSafe. Let us know how you can contribute to our team and make an impact.
Showcase Your Collaborative Spirit: Since this role involves working closely with development teams, make sure to highlight any collaborative projects you've been part of. We love seeing examples of how you've optimised SQL and database usage while working with others!
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and get to know you better. Don’t miss out on the opportunity to join our amazing team!
How to prepare for a job interview at Sosafe Awareness
✨Know Your PostgreSQL Inside Out
Make sure you brush up on your PostgreSQL knowledge, especially around performance tuning and query optimisation. Be ready to discuss specific examples from your past experience where you've successfully managed databases in high-availability environments.
✨Familiarise Yourself with AWS RDS and Aurora
Since this role heavily involves AWS services, take some time to understand the ins and outs of Amazon RDS and Aurora. Be prepared to talk about how you've used these tools in previous roles, particularly in relation to backups, scaling, and disaster recovery.
✨Prepare for Technical Questions
Expect technical questions that dive deep into SQL and PL/pgSQL. Practise explaining complex concepts clearly, as you'll need to communicate effectively with developers. Consider doing mock interviews or coding challenges to sharpen your skills.
✨Show Your Collaborative Spirit
This role requires a collaborative mindset, so be ready to share examples of how you've worked with development teams in the past. Highlight your experience in mentoring peers and leading code reviews, as well as your approach to fostering open communication.