Job Description

Responsibilities:Advanced SQL Server Administration:

• Manage complex SQL Server environments (2014, 2016, 2017, 2019, and 2022)

• Implement and maintain high availability and disaster recovery solutions (e.g., Always On availability groups, log shipping)

• Patching and updating SQL Server instances

• Performance tuning and optimization (e.g., query optimization, index tuning)

Database Design:

• Design and implement normalized and denormalized database structures

• Create and optimize stored procedures, functions, and triggers

Troubleshooting:

• Diagnose and resolve complex SQL Server performance and availability issues

• Use performance monitoring tools (e.g., SQL Server Profiler, DMVs)

Automation:

• Automate routine SQL Server tasks using scripting (e.g., PowerShell, T-SQL)

Required Skills and Experience:

• In-depth knowledge of SQL Server architecture and internals

• Strong T-SQL programming skills

• Experience with high availability and disaster recovery solutions

• Proven ability to troubleshoot complex SQL Server issues

• Familiarity with scripting languages (e.g., PowerShell, T-SQL)

• Experience with performance tuning tools and techniques

Additional Considerations:

• Security: Understanding of SQL Server security best practices, including data encryption, access control, and vulnerability management.

• Inventory Management: Ability to track and manage SQL Server instances, databases, and other assets.

• Patching: Knowledge of SQL Server patching procedures and best practices.

• Cloud Migration: Familiarity with migrating SQL Server workloads to cloud platforms (e.g., Azure, AWS).

NTT Data