SQL Database Administrator

Key Responsibilities

Resolution of reported service requests, pro-active and reactive performance analysis related to databases.

Carry out Database migrations, upgrades, patching and evaluation/roll out of new database related tools.

Troubleshooting, monitoring and diagnose issues with SQL Server Database engine, SSIS, SSRS, SQL codes and highly customized jobs.

Adherence to documented standards and procedures while doing database related activities like change management.

Contribute in continuous improvement .

Basic scripting knowledge in prevalent language for file processing, job scheduling or other tasks.

Understand and write SQL queries, with simple constructs.

Mandatory Skills

Minimum 2 to 4 years of SQL Server database administration experience handling medium to large databases.

Basic knowledge of SSAS, CMD Shell Scripting/ FTP shares, Powershell, VB script and .net/C# would be preferred.

Experience on SQL tools like power designer, DB artisan, Redgate.

Knowledge of Performance Tuning by analyzing, optimizing and rewriting/re-designing SQL codes.

Knowledge of SQL Server database tuning using Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs), and other third-party tools.

Hands on experience with SQL Server installations and patching.

Pwershell scripting to automate DBA related tasks. Ability to understand existing automated tasks and tweak/troubleshoot them.