Function Description / Professional Tasks
Description of the main tasks
− Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).− Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).− Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.− Configure & Monitor Performance/Storage/Memory alerts on Production Azure Servers to ensure high availability of data.− When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.− Design indexes for existing applications, choosing when to add or remove indexes.− Work with developers to improve the performance of queries.− Install and configure new SQL Servers.− Assist to define and implement new features and technologies.− Document the company’s database environment.
Personal Skills and Education
Education
−You have a university degree in computer science or equivalent education and training.
Professional experience/expertise
− Strong knowledge of Azure cloud services, including Microsoft SQL Server on Azure VM, Azure SQL Managed Instance, Azure SQL;
− On-call troubleshooting experience with at least one production SQL Server;
−Finding DMV queries to answer questions about server-level performance;
− Tuning T-SQL queries to improve performance;
− You are familiar with data access technologies and protocols, such as ADO.NET and Entity Framework.
Social skills and characteristics
− You are a committed, initiative personality and convince with a high level of teamwork and communication skills
− You embrace new challenges with an open mind, fostering adaptability and a collaborative spirit within the team.
Language skills
− English spoken and written
− German is an advantage
Additional Comments
− Willingness to travel: 10 % - 20%
Why us?
Just by joining us you will get benefits like:
- Open minded company where every employee has to contribute to the development of the company - ideas are welcome as well as independent thinking too
- 25 annual days of vacations
- Flexible working hours
- Annual allowance for Benefits (Training, Gym, Public Transportation, Technologies, etc...)
- An amazing onboarding week at Switzerland
- iPhone 13
- Second Screen to work at home (Flat or a Curved one)
- First month Tech Allowance to buy your headset or, if you already have one, whatever you need to work comfortably
- Health insurance for you and your family
- Life insurance
- Office Perks (coffee, fruit, stand up desks. etc...)
- So much more...
About us
At the IT Campus, you can grow thanks to challenging IT projects, flat hierarchies, an inspiring environment and state-of-the-art technologies. You also have the opportunity to build up the IT Campus from scratch. You can work flexibly in terms of time and location and benefit from attractive working conditions.
Swiss Post connects people, brings cultures together and is one of the largest IT employers in Switzerland: We handle over 400 software projects each year and run more than 1,000 applications – with these figures set to rise in future.
