Database Admin Senior Specialist

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).

Listen to the story of Employee Voice

Annette Barnabas

India

Read more

Vanathi Asok

India

Read more

Swathi Sujir

India

Read more