Striving for excellence is in our DNA. Since 1993, we have been helping the world’s leading companies imagine, design, engineer, and deliver software and digital experiences that change the world. We are more than just specialists, we are experts.
Currently we are looking for a Senior DB Administrator (MS SQL Server) for our Minks office to make the team even stronger.
As a Senior DBA, you will be responsible for customer’s production databases end-to-end operations, ensuring high availability and performance of an online SaaS service. You will be acting as part of a geographically distributed team of Systems Engineers holding deep expertize in various areas – from computer hardware to application management.
ABOUT THE CUSTOMER
Our customer is a leading player on the enterprise file synchronization and sharing (EFSS) market, a vendor, which offers on-premises or cloud-based capabilities to share documents and videos across devices. Its competitors include Dropbox, Box, WatchDox, Egnyte, Citrix Systems, Accellion, CTERA, Microsoft OneDrive for Business and Google Drive. This is a relatively young company founded in 2008 in the heart of Silicon Valley; and in 2016 it was named by Forrester as the leader in “Enterprise File Sync And Share Platforms” segment.
Please note that after one year in offshore location the customer may suggest relocation to the USA (Santa Clara, CA) to an excellent employee pretending for a DB Architect position.
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.).
At least 5 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;
Be ready for 24x7 On-Call service. Usual work schedule will be 8x5 and mostly within local time zone business hours, however, the candidate should be ready answer a call at any time in case of major production issues, and attend planned maintenance events that may be scheduled for off-time period;
Be ready for business trips to the United States;
Clean criminal history – passing official criminal background check is required for this assignment.
Nice to have
Previous experience working in a service company (operated database(s) is part of a commercial online service) is a great advantage;
Experience in operating scalable solutions (huge data size and/or heavy load) will be a big plus;
Experience in migrating production databases (zero downtime migration strategies);
Familiarity/experience with other databases: Postgre/MySQL/AWS RDS services.
Experience exchange with colleagues all around the world;
Competitive compensation depending on experience and skills;
Regular assessments and salary reviews;
Social package: medical care, sports, family care;