1. Certified Microsoft SQL Server Database Engineer (or similar) with 7+ years experience
2. Developing, deploying and maintaining application and reporting databases
3. Ensuring the highest levels of database performance and resilience
4. Knowledge and experience of financial systems (especially Insurance/Reinsurance)
5. Supporting database global users
6. Knowledge and experience of Azure Devops and CI/CD tools
7. Knowledge and experience of Job scheduling tool(s)
8. Cloud Experience, preferably Azure
9. Knowledge of user access and security controls (e.g. Active Directory)
10. Knowledge of Agile working methodology
11. Good team player
12. Developing, deploying and maintaining application and reporting databases
13. Proactively ensure the highest levels of application database availability
14. Monitor and test database performance for potential bottlenecks, identify possible solutions, and work with other developers to implement those fixes
15. Maintain security, backup, and redundancy strategies for databases
16. Write and maintain custom scripts to increase system efficiency and lower the human intervention time on any tasks
17. Participate in the design of information and operational support systems
18. Report to Application Domain Manager
19. Provide support to database users
Required experience & competencies
Must Have:
20. Certified Microsoft SQL Server Database Engineer with 7+ years experience
21. Knowledge and experience of financial systems (preferably Insurance/Reinsurance)
22. Knowledge and experience of using structured and unstructured data
23. Knowledge and experience of Azure Devops/GIT and CI/CD tools
24. Knowledge and experience of Job scheduling tool(s) e.g. Visual TOM
25. Knowledge of user access and security controls (e.g. Active Directory)
26. Experience of supporting global database users
27. Proficiency in MS Excel
28. Knowledge and experience of database performance tuning and testing
29. Good problem solving skills
Nice to Have:
30. Palintir (Data Foundry)
31. Knowledge and xxperience of Powershell
32. Knowledge of other RDMS (e.g. DB2, Sybase, Posgres)
33. Knowledge of Prophet, MIND or similar Risk Modelling tools
34. Knowledge and experience with C#
35. ETL Tools (e.g. Talend)
36. Prophet (or similar Risk Modelling tools)
37. Knowledge and experience of Azure Cloud
38. Using SNOW Helpdesk system
39. Knowledge of Agile methodologies
Required Education
40. Degree/Diploma in Computer Science, Data Analytics or a related subject