Database Administrator - PostgreSQL
Role details
Job location
Tech stack
Job description
The team:This is an exciting opportunity for a Database Engineer with administration and development skills to join a small and friendly team of Database Engineers responsible for managing business critical databases hosted in AWS. The Database Administration (DBA) team is committed to ensuring optimal system performance, reliability, data integrity, and security, while maintaining 24/7 availability of customer data across diverse database platforms. Some of the tech stack you will be working with includes: AWS RDS Aurora Postgres, AWS RDS MySQL, SQL Server hosted on AWS EC2, WSFC, AlwaysOn, RedGate tools, Terraform, Jira just to name a few. Our mission is to proactively maintain and monitor the database systems, pre-empting potential issues and guaranteeing 99.99% availability year-round. We are dedicated to promptly addressing stakeholders' support requests, ensuring uninterrupted access to critical data. Additionally, we are committed to fostering innovation within our DBA practices, continuously seeking, and implementing automation tools to enhance efficiency and quality.A day in the life:
- You will be reporting into the Head of Data Platforms
- You'll be providing standard database maintenance and administration tasks while working closely with Senior Database Engineers to maintain database systems
- You'll perform all kind of BAU activities independently, and support database team stakeholders
- You'll working closely with platform and development teams to make sure we get the best performance from our database systems
- This role will require on-call participation on a rota basis
Requirements
- Cloud IaaS and PaaS knowledge and experience with AWS services - RDS, EC2, IAM, S3, DMS, CloudWatch, Lambda
- Knowledge and experience managing Aurora PostgreSQL, SQL Server and MySQL databases
- The ability write and execute SQL scripts in Production
- Respond to a variety of database related requests on a daily basis
- Show a willingness to learn about latest cloud & AI technologies in the database space
- Maintain a consistently high level of service delivery for incidents, requests and changes
- The ability to prioritise projects and tasks
Added bonus:
- Experience with WSFC & SQL Server AlwaysOn availability groups
- Knowledge of Postgres Logical replication and extensions
- Previous experience using AI
- Experience with terraform
- Supported Redshift cluster databases
- Worked with DB monitoring tools - Redgate Monitor
- Worked with personal data in a regulated company
- Hold AWS or Azure certificates
Benefits & conditions
We're on the move! Towards the end of 2025 Zopa will be relocating to a brand-new headquarters at 20 Water Street in Canary Wharf. The 44,000 square foot workspace will foster collaboration and inspire creativity for our 900 employees amidst our 2025 growth blitz.
At Zopa we value flexible ways of working. We value face-to-face collaboration and a good work-life balance. This hybrid role requires you to come to our London office 2-3 days a week. You'll also have the option of working from abroad for up to 120 days a year!* But no matter where you are, we'll make sure you've got everything you need to thrive, both in your work and home life, from day one. *Subject to having the right to work in the country of choice