- 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
#J-18808-Ljbffr
Data Base Administrator, MS SQL Arbeitgeber: Jobtailor
Als Front Office Supervisor in unserem dynamischen Team bieten wir Ihnen die Möglichkeit, in einem unterstützenden und freundlichen Arbeitsumfeld zu wachsen. Wir legen großen Wert auf die berufliche Entwicklung unserer Mitarbeiter und bieten regelmäßige Schulungen sowie die Chance, Verantwortung zu übernehmen. Unsere Lage ermöglicht es Ihnen, Teil einer lebendigen Gemeinschaft zu sein, während Sie gleichzeitig die Standards unseres Franchise-Partners einhalten und unseren Gästen einen unvergesslichen Aufenthalt bieten.
