Development Database Administrator
Development Database Administrator
Development Database Administrator
LGT Capital Partners is a leading alternative investment specialist with USD 75 billion in assets under management and
more than 550 institutional clients in 44 countries. An international team of over 600 professionals is responsible for
managing a wide range of investment programs focusing on private markets, liquid alternatives and multi-asset class
solutions. Headquartered in Pfaeffikon (SZ), Switzerland, the firm has offices in New York, Dublin, London, Paris,
Frankfurt, Vaduz, Dubai, Beijing, Hong Kong, Tokyo and Sydney.
Stellenbeschreibung
- Monitoring system and SQL performance and identifies and resolves problems that arise;
- Responsible for problem management activities such as issue resolution and root cause analysis;
- Providing developers with developer-side SQL performance tuning techniques;
- Implementing and supporting data warehouse file import jobs using SSIS;
- Administration and support of our SSAS solutions (OLAP and Tabular);
- Leading role in database migration projects to the Cloud;
- Collaborating with infrastructure, operations and development teams with proper integration (including data) of
various business applications;
- Planning, installing, and maintaining database server instances including software upgrades, patches, and new
releases;
- Design and implementation of databases in accordance to end users' information needs and views;
- Ensuring the security of data by managing access permissions and privileges;
- Creation of backups and recovery plans and procedures based on industry best practices, and oversees their
implementation;
- Automating recurring administration tasks and processes.
Unsere Anforderungen
- Bachelor's degree in Information Technology, Data Engineering or similar;
- Proven working experience as a MS SQL database administrator with SQL Server 2008+ databases (installation and
configuration, security, SQL Agent jobs, performance tuning) and with the Microsoft Azure platform and Microsoft Azure
SQL databases, background in the financial industry is a plus;
- Expertise in SQL and tuning of queries as well as SSIS development and support, SSRS, Power BI and SSAS
administration;
- Experience with monitoring tools, including installation, configuration, and maintenance of such tools;
- Excellent problem solving and analytical skills combined with hands-on experience in process automation;
- Good communication skills in English, German would be an advantage.
Kontaktinformationen
If you are interested in becoming an integral part of a successful alternative investment management team in an
international, multicultural working environment we will be pleased to get to know you soon.
For further information please contact us.
Florian Fischer
LGT Capital Partners AG, Pfaeffikon
Human Resources
Kontakt
Bitte bewerben Sie sich über unser Online-Formular.
Online Bewerbung
Florian Fischer
Senior HR Manager
LGT Capital Partners Ltd.
Pfäffikon
+41 55 415 96 17
LGT Capital Partners is a leading alternative investment specialist with USD 75 billion in assets under management and
more than 550 institutional clients in 44 countries. An international team of over 600 professionals is responsible for
managing a wide range of investment programs focusing on private markets, liquid alternatives and multi-asset class
solutions. Headquartered in Pfaeffikon (SZ), Switzerland, the firm has offices in New York, Dublin, London, Paris,
Frankfurt, Vaduz, Dubai, Beijing, Hong Kong, Tokyo and Sydney.
Stellenbeschreibung
- Monitoring system and SQL performance and identifies and resolves problems that arise;
- Responsible for problem management activities such as issue resolution and root cause analysis;
- Providing developers with developer-side SQL performance tuning techniques;
- Implementing and supporting data warehouse file import jobs using SSIS;
- Administration and support of our SSAS solutions (OLAP and Tabular);
- Leading role in database migration projects to the Cloud;
- Collaborating with infrastructure, operations and development teams with proper integration (including data) of
various business applications;
- Planning, installing, and maintaining database server instances including software upgrades, patches, and new
releases;
- Design and implementation of databases in accordance to end users' information needs and views;
- Ensuring the security of data by managing access permissions and privileges;
- Creation of backups and recovery plans and procedures based on industry best practices, and oversees their
implementation;
- Automating recurring administration tasks and processes.
Unsere Anforderungen
- Bachelor's degree in Information Technology, Data Engineering or similar;
- Proven working experience as a MS SQL database administrator with SQL Server 2008+ databases (installation and
configuration, security, SQL Agent jobs, performance tuning) and with the Microsoft Azure platform and Microsoft Azure
SQL databases, background in the financial industry is a plus;
- Expertise in SQL and tuning of queries as well as SSIS development and support, SSRS, Power BI and SSAS
administration;
- Experience with monitoring tools, including installation, configuration, and maintenance of such tools;
- Excellent problem solving and analytical skills combined with hands-on experience in process automation;
- Good communication skills in English, German would be an advantage.
Kontaktinformationen
If you are interested in becoming an integral part of a successful alternative investment management team in an
international, multicultural working environment we will be pleased to get to know you soon.
For further information please contact us.
Florian Fischer
LGT Capital Partners AG, Pfaeffikon
Human Resources
Kontakt
Bitte bewerben Sie sich über unser Online-Formular.
Online Bewerbung
Florian Fischer
Senior HR Manager
LGT Capital Partners Ltd.
Pfäffikon
+41 55 415 96 17
Subscribe to jobs of this company
Rating submitted