Senior Database Engineer, MOTORS

• Deep expertise in database architecture, design and administration, including backups, maintenance, performance monitoring, patching and troubleshooting
• Advanced knowledge of disaster recovery and business continuity planning for databases
• Performance optimisation expertise, including query tuning, analysing metrics and reducing deadlocks/timeouts
• Proficiency in automation of database maintenance tasks using PowerShell/Python
• Ability to define and implement database scaling strategies
• Experience as a technical thought leader who can impact the trajectory of the company
• Proven ability to act as a reliable, collaborative subject matter expert in key areas
• Experience coaching and mentoring junior engineers
• Track record of tackling problems before they can do harm
• Experience providing technical and strategic feedback that lead to better outcomes
• Experience migrating from MS SQL based on-premise solutions to cloud-native Azure databases
• Experience in data engineering, data lake/warehousing or BI solutions with several years in Azure cloud
• Proven record of successfully integrating business-critical data from different sources
• Extensive and proven experience in:
• Azure PostgreSQL Database
• Azure SQL Managed Instance, Azure SQL Database, Azure SQL VM
• Always On availability groups and failover cluster instances
• Visual Studio SSDT DB projects
• Database CI/CD (preferably YAML pipelines in Azure DevOps)

Desirable

• We are looking for a highly skilled Senior Database Engineer to become part of our UK business and help develop and deliver on our Database Platform. As a Senior Database Engineer, you will help develop a platform that brings fast and reliable data to the people who need it
• With a passion for people and a strong growth mentality, you will help us to deliver data solutions to the business and our customers
• We need a top-notch Senior Database Engineer to join our team and to help guide the product & technology teams as we modernise our heritage Microsoft SQL stack and expand into PostgreSQL and NoSQL
• Your main goal is to work with our team to help deliver a platform that can provide insights based on reliable and secure data, so everyone can spend more time delivering value. In executing this mission, you will work closely with our engineers, architects, and product owners
• Reports To: Head of Databases
• Positioned as an Individual Lead Contributor who will help us modernise and maintain our Microsoft SQL based data platform
• Architect, engineer, deploy and maintain highly scalable and available database solutions in Azure Cloud
• Support the team and business in the migration from our heritage SQL VM estate into a modern Azure Cloud SQL based solution
• Lead and consistently deliver on projects of highly ambiguous scope, high complexity and critical business impact
• Be deployed to highest priority business problems or critical incidents, quickly resolve them and help the business understand prevention strategies
• Design and implement database scaling strategies (horizontal and vertical) to support growing data volumes and high transaction throughput
• Ensure heritage systems continue to be maintained at a high standard while managing short to medium-term improvements
• Work with the existing team and contribute towards delivering high-quality code by improving coding standards and best practices
• Identifying areas of innovation in data tools and techniques, recognising appropriate timing for adoption
• Design and manage data pipelines for operational data processing (ETL)
• Develop comprehensive disaster recovery and business continuity planning for databases
• Participate in an On-Call rotation to provide our customers 24/7 support
• Develop and support database automation, including maintenance, test data management, CI/CD pipelines and unit tests
• Monitor database performance, implement changes and apply new patches and versions when required
• Coordinate teams to resolve problems and implement solutions and preventative measures
• Automate database maintenance tasks including backups, patching, and health checks
• Define and implement database scaling strategies in distributed environments
• Manage communication between technical and non-technical stakeholders effectively
• Clearly and confidently articulate risk of technical problems to non-technical stakeholders (e.g., product, legal, compliance)
• Represent the company to external stakeholders (e.g., auditors, regulators, third-parties, vendors) when appropriate
• Liaise with product managers, product owners and engineering managers across multiple squads to ensure timely delivery
• Link technical contributions back to business impact for your team or area, helping others buy into this vision
• Proactively contribute to the betterment of other engineers through sponsoring, mentoring and providing constructive, candid feedback
• Enable groups of others to improve coding standards and awareness of best practices around non-functional requirements
• Be repeatedly consulted for advice by engineers from different squads or tribe
• Contribute through knowledge sharing and architectural foru
• Actively offer well-considered contributions to the roadmap of your team or business area
• Demonstrate product-awareness and offer valuable contributions to quarterly planning rituals
• Work with PM or tech lead on setting the vision for your squad
• Foster effective collaboration between Product and Engineering
• Help ensure your squad focuses on work that drives forward quarterly goals while reducing operational impact
• Proactively stay up to date with technology trends and contribute thoughts on squad strategy
• What success looks like:
• In this role, you will successfully lead and deliver projects of high complexity and critical business impact. You'll be known as the go-to expert who can quickly resolve critical issues while helping the business understand prevention strategies
• Your technical contributions will clearly link back to business impact, and you'll actively help shape the technical strategy of your area while developing the next generation of database engineers

• We usually respond within two weeks