Senior SQL developer

Job Description

Who we are looking for…

We are seeking a SQL Developer with expert level knowledge in SQL – especially MSSQL. The successful candidate will need to work with several of our engineering teams as an SME for their database queries, assisting with creating new SPs or queries, debugging/tuning existing ones and troubleshooting functional and performance related issues in SQL code. The candidate should also have a deep understanding of several of RDBMS architecture, performance tuning, security, table maintenance, and ETL processes.

We are looking for seriously deep SQL coding expertise. We are not looking for DBAs, full-stack engineers, DevOps or backend skills for this role. It is an opportunity to join an innovative company with global impact and build world-class infrastructure to scale our solutions. This is a senior level engineering role on mission critical systems running multi-terabyte databases that contain billions of records and thousands of queries, procedures and functions.

What you will do…

• Create, improve and maintain SQL stored procedures, queries and functions, acting as a technical expert for one or more product engineering teams
• Support and monitor existing operations, understanding query and execution plans to be able to further refine and improve
• Optimize existing functions by implementing performance tuning methodologies.
• Identify, troubleshoot, and debug application defects in tandem with the engineering teams, and write technical documentation to share knowledge and expertise.
• Work collaboratively with several other teams.
• Collaborate with DBAs for architecture and performance work.
• Train individuals and teams on best practices of coding in SQL.

Qualifications

• Several years (probably more than 5) experience as a SQL developer or engineer, ideally with much of it using MS SQL Server
• Experience working with mission critical databases containing millions (or more) of records
• Demonstrable history collaborating with application engineers to create new, and improve existing SQL code
  • You will be expected to give several detailed examples of roles that involving query analysis, in both green field and legacy/maintenance environments
• Experience mentoring, coaching and generally improving a team or an organisation’s capability in the field through 1:1 or class based coaching, and high quality documentation.
• Fluent/Native/A1 level English (written and spoken)