Intern Database administrator (MS SQL Server)
Description
Join the financial revolution!
Are you passionate about finance and want to make a real change? Join Kreditech and our team of over 300 professionals and become part of a transforming industry. From engineering, to design, to analytics, and collections, we do things differently and we reward great ideas, team work and persistence. We have a lot of work to do – and we want you to join us!
Responsibilities:
- Perform ongoing database operation and database maintenance work;
- Support and improve database high availability solutions;
- Support and improve database disaster recovery strategy (data backup and restoration, etc.) to ensure minimal restoration time and data loss in case of any issues;
- Tune performance of all database-related components (database engine, data models, stored procedures, etc.) in support of smooth operation of near-real-time application. Advise other system engineers and software developers regarding database servers’ hardware and/or code performance;
- Drive DB servers capacity planning;
- Investigate and resolve any database-related production issues and incidents; perform root cause analysis and propose/implement solutions to eliminate problems;
- Onboard new functionality to production operation, perform pre-production evaluation of new releases, participate in production deployment events;
- Contribute to various business and internal projects as a DB expert (e.g. implementation of huge new functionality, software and/or datacenter transformation initiatives, etc.).
Requirements:
- At least 3 years of production experience in administering and operating databases on MS SQL Server 2008 - 2016 (experience with high loaded databases will be a great advantage);
- Strong skills in and deep knowledge of SQL Server internals and performance tuning topics 2012/ 2014;
- Strong knowledge of and practical experience in implementing high availability solutions (experience with Always On Availability Groups is preferable);
- Strong knowledge of building different failover configurations (Active\Active, Active\Passive). Practical experience with operating solutions utilizing various failover schemas will be an advantage;
- Knowledge of and experience in building cluster solutions with/without witness (the candidate should show a deep understanding of cluster mechanisms and explain pros and cons of different cluster configurations);
- Strong knowledge of:
- Performance tuning: various index types, execution plans;
- Resource usage optimization and protection: data files vs storage strategies, grants, transaction isolation, lock levels.
- Experience in T-SQL\SQL on an advanced level (any proven DBE experience is welcomed);
- At least Intermediate (B1) English level or higher