— 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.
— An environment that allows you to maximize your productivity and gives you the freedom to think and collaborate beyond the next line of code or deadline;
— We like to have fun, we love what we do, we relax when we need to, we are a great team and we deliver;
— High-level compensation and regular performance-based salary and career development reviews;
— Medical insurance (health), employee assistance program;
— Paid vacation, holidays and sick leaves;
— Gym 24/7, personal fitness instructor;
— Massage in the office, personal wellness consultant;
— English classes with native speakers and partially or fully reimbursed personal trainings and conferences;
— Team building and a lot of fun to take a break, relax, and give you the freedom to think beyond the next line of code.
— Write and troubleshoot Transact SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).
Our client is the leader of global online gift registry services, which gives the flexibility to choose items from any store in the world. This is enterprise software for large, multi-store retailers which is highly integrated and gives partners and their customers a uniquely branded gift registry experience and lets retailers do what they do best, sell products while creating an additional source of profit.