Kreditech logo Kreditech

Intern Database administrator (MS SQL Server)

Created on 31-10-2017
Location Moscow Office

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
CLOSED VACANCY Apply now

Video