Follow our LinkedIn to see new jobs, every day.
S

IT Data Engineer (SQL Server)

SCOR
Contract
On-site
Dublin, Ireland
Technology and IT

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