Job Description The Database Developer must be skilled in producing complex SQL queries and requires a solid understanding of database technologies, particularly SQL Server. Working as part of the Scrum team responsible for the Verisk IVI product, you will have the opportunity to see all aspects of the product design, development and support. IVI leverages AI to detect vehicle damage from images and use this to automate damage repair estimates. As a Database Developer, you?ll be at the heart of this innovation as the product is highly data driven. You will be helping configure the application to different insurer requirements by modifying settings and stored procedures in the database. You will collaborate with other Database Developers to support each other and to develop standard solutions across Verisk products. There is a fantastic opportunity for learning new skills. You?ll have the chance to master Python and Bash scripting, work with cutting-edge AWS Cloud databases, and enhance your skills in database administration and Agile methodologies. Responsibilities Developing SQL scripts and stored procedures to ensure efficient data retrieval and manipulation Developing the business and application logic within stored procedures and configuration tables Supporting development team on database design best practices and carrying out code reviews Defining data security, monitoring and backup procedures Performance monitoring and troubleshooting All work will be fully documented and stored within appropriate version control solutions Working with other teams to ensure they have the data required to perform their roles Qualifications Essential Requirements: Writing complex T-SQL queries and SQL stored procedures Experience with relational database technologies such as Microsoft SQL Server Strong communication skills; teamwork and interpersonal skills; analytical, problem-solving and organization skills with strong attention to detail Desirable but not essential: Managing Maintenance schedules. E.g. Using SQL Agent jobs Understand Information security (E.g. GDPR) Scripting language like python or bash to write automation scripts Source Control such as git Third party data tools. E.g. dbatools.io and First Responder Kit Experience in database administration tasks (Schema maintenance, tuning, performance analysis, backups and disaster recovery etc.) Working with databases in the AWS Cloud (E.g. RDS Postgres, DynamoDB) Scrum/Agile Methodology Experience of complex datasets (> 300 tables or > 200 columns in some tables) of mixed quality
