Data Base Administrator (MS SQL)
Core
Manage high-load MS SQL Server databases (tens of terabytes) for social discovery platforms, focusing on performance optimization, availability, and data integrity.
Role type
Senior Database Administrator (MS SQL)
Builds
AlwaysOn availability groups, optimized query execution, and reliable data access for analysts and ML engineers.
Domain
Social networking / Big Data
Deliverable
production ML models | infrastructure
Required skills
MS SQL Server 2008–2019 architecture, advanced T-SQL scripting, query optimization, index management, AlwaysOn availability groups, distributed transactions, relational database fundamentals
Preferred skills
Experience with high-load databases, ability to analyze execution plans, remote troubleshooting
Technologies
MS SQL Server, T-SQL, AlwaysOn
Responsibilities
Write advanced T-SQL scripts; Review developers' SQL code and resolve execution-plan issues; Optimize database performance (queries, indexes, locking, disk, memory); Support and maintain AlwaysOn availability group; Help analysts and ML engineers with data access; Run routine database maintenance (archiving, recovery, security, integrity checks); Monitor server performance and prevent incidents
Seniority
Senior, hands-on IC
