Description
- Certified Microsoft SQL Server Database Engineer (or similar) with 7+ years experience
- Developing, deploying and maintaining application and reporting databases
- Ensuring the highest levels of database performance and resilience
- Knowledge and experience of financial systems (especially Insurance/Reinsurance)
- Supporting database global users
- Knowledge and experience of Azure Devops and CI/CD tools
- Knowledge and experience of Job scheduling tool(s)
- Cloud Experience, preferably Azure
- Knowledge of user access and security controls (e.g. Active Directory)
- Knowledge of Agile working methodology
- Good team player
Responsibilities
- Developing, deploying and maintaining application and reporting databases
- Proactively ensure the highest levels of application database availability
- Monitor and test database performance for potential bottlenecks, identify possible solutions, and work with other developers to implement those fixes
- Maintain security, backup, and redundancy strategies for databases
- Write and maintain custom scripts to increase system efficiency and lower the human intervention time on any tasks
- Participate in the design of information and operational support systems
- Report to Application Domain Manager
- Provide support to database users
Qualifications
Required experience & competencies
Must Have:
- Certified Microsoft SQL Server Database Engineer with 7+ years experience
- Knowledge and experience of financial systems (preferably Insurance/Reinsurance)
- Knowledge and experience of using structured and unstructured data
- Knowledge and experience of Azure Devops/GIT and CI/CD tools
- Knowledge and experience of Job scheduling tool(s) e.g. Visual TOM
- Knowledge of user access and security controls (e.g. Active Directory)
- Experience of supporting global database users
- Proficiency in MS Excel
- Knowledge and experience of database performance tuning and testing
- Good problem solving skills
Nice to Have:
- Palintir (Data Foundry)
- Knowledge and xxperience of Powershell
- Knowledge of other RDMS (e.g. DB2, Sybase, Posgres)
- Knowledge of Prophet, MIND or similar Risk Modelling tools
- Knowledge and experience with C#
- ETL Tools (e.g. Talend)
- Prophet (or similar Risk Modelling tools)
- Knowledge and experience of Azure Cloud
- Using SNOW Helpdesk system
- Knowledge of Agile methodologies
Required Education
- Degree/Diploma in Computer Science, Data Analytics or a related subject