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.
• Support Areas
• Database Administrative support of SQL Server versions 2014 – 2022: Monitoring, maintenance and housekeeping of SQL Server and Databases, SQL Jobs, User Access management and regular client requests. Writing and tuning SQL codes and highly customized jobs.
• Infrastructure support of SQL Server versions 2014 – 2022: server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research and development.
• Support of application and upgrade database (Database Migration/ upgrade) from existing SQL versions to latest SQL Server versions.
• Incident Management: Knowledge of Incident management process and participation in a rotational on-call schedule to support off hours production incidents

Mandatory Skills
• Minimum 2 to 4 years of SQL Server database administration experience handling medium to large databases.
• In SQL Server 2014- 2022 running on the Win Server 2016, 2022 operating system
• 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
• Database Maintenance/ Support tasks and lower level monitoring using tools like profiler, DMV.
• SQL Server Replication, Backup/ Restore, maintenance plans and DR recovery strategies.
• Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices, automate).
• Understanding of system tables, stored procedures, functions, triggers & SQL tuning.
• General troubleshooting like assisting clients with various issues related to connectivity, permissions, access, distributed queries issues, suggesting solutions, best practices etc.
• SQL Server Security, adept in creating and maintain complex User and permission management environment using AD groups, DB roles, SQL ids and Proxy accounts