Looking for a job? Come and join #humanIT family of If!Apply
We are the leading insurance company in the Nordic region and our IT Unit is developing next generation insurance systems, working with more than 25 various in-house development projects across Baltics and Scandinavian countries, using newest technologies, teamwork and continuous knowledge sharing. To provide services and systems in superior quality our IT Unit has expanded to more than 300 IT specialists in Riga and around 800 IT specialists in the whole If Insurance Group.
Now we are looking for Database Specialist that will join our SQL team. Teams core responsibility is to provide SQL Server database engine but we do provide other related services- SSRS, Power BI SSRS, SSAS Tabular and Multidimensional, MDS hosted in Azure cloud, Power BI premium capacity and data gateway cluster.
Database Specialist’s duties will be to maintain and develop existing MS SQL Server platform according to best practices, monitor and act on alerts and user requests. In our environment we have close to 200 TB of data, 3000 databases, around 40 physical and virtual servers, some of them in Azure cloud. Currently we are in upgrade progress from MS SQL 2016 to latest MS SQL 2019 version and have strong focus in adapting more Azure cloud technology.
Part of the duties will be working with application development teams to improve database design, optimize SQL code and do capacity planning for future needs.
- Administrate, maintain and develop a MS SQL environment for best performance
- Cooperate with application development teams for capacity planning and performance tuning
- Participate in SQL Service extension to Azure cloud (IaaS, PaaS)
Skills and experience needed:
- Strong TSQL knowledge
- Experience in SQL Server administration
- Experience in SSIS
- Good social skills and able to communicate clearly on technical and management level
- Fluent in English
Will be considered as advantage:
- Azure cloud knowledge
- Experience with Azure SQL DB, Elastic pools, Azure Managed Instances
- PowerShell, .Net programming skills
We are offering:
International, modern and dynamic working environment in one of the leading insurance companies in Nordic & Baltic region, challenging and exciting tasks to carry out, personal development and training opportunities within If Group based IT unit, good motivation package, monthly gross salary EUR 2000 – 4000 (depending on your expertise level), common company benefits, professional and friendly team, opportunity to work remotely.