Data Base Administrator, MS SQL

This is a fully remote position, open to applicants in Poland.

📋 Description

• Develop advanced T-SQL scripts for MS SQL Server versions 2008 to 2019.

• Evaluate and review SQL code produced by developers.

• Analyze execution plans and troubleshoot any related issues.

• Enhance database performance, focusing on queries, indexes, locking, disk usage, and memory optimization.

• Detect and resolve system bottlenecks quickly and remotely.

• Assist in the support and maintenance of an AlwaysOn availability group with both primary and mirrored servers.

• Aid analysts and machine learning engineers with data access and retrieval processes.

• Conduct database maintenance tasks, including archiving, implementing recovery strategies, enforcing security policies, and performing data integrity checks.

• Monitor server performance to proactively mitigate incidents.

⛳️ Requirements

• Practical experience with MS SQL Server from 2008 to 2019.

• Comprehensive understanding of Microsoft SQL Server architecture and its internals.

• Exceptional T-SQL skills coupled with significant developer-level scripting experience.

• Familiarity with stored procedures, user-defined functions (UDFs), triggers, and distributed transactions.

• Strong foundation in relational database principles.

• Proven track record of optimizing SQL queries, stored procedures, and functions.

• Capable of reading and comprehending code authored by others.

• Ability to independently identify logical errors through database structure and code analysis.

• Experience managing high-load databases that reach tens of terabytes.

🏝️ Benefits

• FULLY REMOTE opportunity for full-time employment.

• 28 calendar days of vacation annually.

• 7 wellness days off each year.

• Bonuses of up to $5,000 for successfully recommending candidates for open positions within the company.

• 50% coverage for professional training, international conferences, and meetings.

• Corporate discounts available for English language lessons.

• Health benefits include reimbursement of up to $1,000 gross per year for self-purchased health insurance or medical fees for yourself and close relatives not covered by corporate medical insurance.

• A well-equipped workplace with necessary tools available in offices or co-working spaces.

• Reimbursement for workplace expenses up to $1,000 gross every three years for co-working or home-office equipment and internet costs.

• An internal gamified gratitude system that allows for bonuses to be exchanged for merchandise, team-building activities, massage certificates, and more.