Position: Advanced DBA
Company: Innovecs
Category: SQL
Experience required: 5y
English level: upper
Published: 2020-04-01T00:00:00+03:00

Responsibilities
Write and troubleshoot Transact SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
 Requirements
Deep theoretical database knowledge
Practical SQL server optimization knowledge
Expert level skills in SQL Development – ability to write and troubleshoot Transact SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
Expert knowledge in Performance Tuning and optimization, using native monitoring and troubleshooting tools.
Expert knowledge of indexes, index management and statistics
Strong experience in complex scale out and DR scenarios including transactional replication, database mirroring, SAN Replication, and alwaysOn setups
Knowledge of troubleshooting and resolving database integrity issues, blocking and deadlocking issues, replication issues, performance issues, connectivity issues, and security issues
Knowledge of the Microsoft development platform
Strong experience in Database Administration in SQL Server 2017
Ability to detect and troubleshoot SQL Server related I/O, memory, disk space, CPU, and other resource issues
Knowledge with Query optimization
Knowledge of SQL Server tools (Profiler, SSMS, SSCM, DM views, system stored procedures)
Our system located on the Amazon cloud so AWS experience is a plus