Monitoring scheduled DBA overnight processes, troubleshooting skill in resolving issues faced, Service Call support.
SQL Server Upgrades and Migrations that include storage migration as well.
Knowledge in SQL server technologies like Replication, SSIS, SSRS, SSAS.
Knowledge in high availability solutions like log-shipping, Failover Clustering, Always On availability.
Proficient in Microsoft Azure Saas, Iaas and Paas solutions.
Patching, Hotfixes and Cumulative Updates of SQL DB.
Negotiation skills with stakeholders for applying the latest service packs, Hotfixes and cumulative updates with least downtime.
Knowledge in T-SQL coding and performance tuning.
Basic knowledge in Oracle and MySQL
Liaising with the support and development teams in India & UK.
Communicate the daily progress of tasks and risks to stakeholders.
Provide technical help and training to team members
Experience in SQL server versions starting at 2008.
Proficiency in database recovery techniques.
Performance tuning, Indexing strategies.
Experience in SSRS, SSIS and TSQL.
Experience in Patching strategy for Hotfixes and Cumulative Updates.
Good understanding on RDBMS concepts and database design skills.
Experience in Microsoft Azure
Windows Servers, Virtualization solutions, Linux, Solaris.
Knowledge of implementing Data warehouse using MS BI toolsets (SSIS/ SSAS).
Exposure to quality systems (ISO / CMMI).
Excellent communication and inter-personal skills.
Good planning, organizing & time management skills.
Should be a quick learner with an eye for detail.
Ability to prioritize work.
Drive for results within deadlines.
Escalate issues at an early stage to Line Manager and counterparts in UK.
Demonstrate a high degree of self-motivation and tenacity to get the job done.