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
QualificationsRequired 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