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.
Seniority level
Associate
Employment type
Full-time
Job function
Information Technology
Industries
Financial Services
Referrals increase your chances of interviewing at Sun Life by 2x