Data Base Administrator, MS SQL

Jobtailor; Deutschland; Remote; EUR 65.000 - 100.000; Vollzeit

Zusammenfassung

Jobtailor is seeking an experienced SQL Server professional to join our data-focused team. You will write advanced T-SQL scripts, review code, and analyze execution plans to optimize performance on MS SQL Server 2008–2019.

You will support AlwaysOn, manage high-load databases, and collaborate with analysts to enable fast data access for ML-driven insights, while maintaining strong data integrity and security.

Qualifikationen

• Hands-on experience with MS SQL Server 2008–2019
• Deep knowledge of Microsoft SQL Server architecture and internals
• Excellent T‑SQL skills with extensive developer‑level scripting experience
• Experience with stored procedures, UDFs, triggers, and distributed transactions
• Solid grasp of relational database fundamentals
• Proven ability to optimize SQL queries, stored procedures, and functions
• Ability to read and understand code written by others
• Ability to independently identify logic errors from database structure and code alone
• Experience working with high‑load databases in the tens of terabytes

Aufgaben

• Write advanced T-SQL scripts for MS SQL Server 2008–2019
• Review developers' SQL code
• Analyze execution plans and resolve execution-plan issues
• Optimize database performance, including queries, indexes, locking, disk, and memory
• Identify and resolve system bottlenecks remotely and on short notice
• Support and maintain an AlwaysOn availability group with primary and mirror servers
• Help analysts and ML engineers with data access and retrieval
• Perform database maintenance, including archiving, recovery strategies, security policies, and data integrity checks
• Monitor server performance and proactively prevent incidents

Kenntnisse

T-SQL scripting

MS SQL Server 2008–2019

Query optimization

Execution plan analysis

AlwaysOn availability group support

High-load database management

Relational database fundamentals

Stored Procedures

User-Defined Functions

Triggers

Distributed transactions

Jobbeschreibung

• Write advanced T-SQL scripts for MS SQL Server 2008–2019
• Review developers' SQL code
• Analyze execution plans and resolve execution-plan issues
• Optimize database performance, including queries, indexes, locking, disk, and memory
• Identify and resolve system bottlenecks remotely and on short notice
• Support and maintain an AlwaysOn availability group with primary and mirror servers
• Help analysts and ML engineers with data access and retrieval
• Perform database maintenance, including archiving, recovery strategies, security policies, and data integrity checks
• Monitor server performance and proactively prevent incidents

Requirements

• Hands-on experience with MS SQL Server 2008–2019
• Deep knowledge of Microsoft SQL Server architecture and internals
• Excellent T‑SQL skills with extensive developer‑level scripting experience
• Experience with stored procedures, UDFs, triggers, and distributed transactions
• Solid grasp of relational database fundamentals
• Proven ability to optimize SQL queries, stored procedures, and functions
• Ability to read and understand code written by others
• Ability to independently identify logic errors from database structure and code alone
• Experience working with high‑load databases in the tens of terabytes

Core Competencies

Demonstrates advanced expertise in T‑SQL scripting and MS SQL Server performance optimization, with a strong ability to analyze execution plans and resolve complex database issues. Proficient in maintaining high‑load databases and ensuring data integrity through effective maintenance strategies.

Highest-signal resume keywords

• T-SQL Scripting
• MS SQL Server 2008–2019
• Database Performance Optimization
• Execution Plan Analysis
• AlwaysOn Availability Group Support

Hard Skills

• T-SQL
• Stored Procedures
• User-Defined Functions
• Triggers
• Distributed Transactions
• Database Maintenance
• Data Integrity Checks
• Query Optimization
• Relational Database Fundamentals
• High-Load Database Management

Soft Skills

• Problem Solving
• Analytical Thinking
• Attention to Detail

Industry Keywords

• Microsoft SQL Server Architecture
• Execution Plan Issues
• System Bottlenecks
• Data Access and Retrieval
• Performance Monitoring