Description
Key ResponsibilitiesMonitoring 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 MySQLLiaising 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 membersMinimum Qualification and ExperienceA graduate with 1-3 years of experience in SQL Database TechnologiesMandatory SkillsExperience 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 AzureDesired SkillsWindows Servers, Virtualization solutions, Linux, Solaris.Knowledge of implementing Data warehouse using MS BI toolsets (SSIS/ SSAS).Powershell scripting.Exposure to quality systems (ISO / CMMI).Competency RequirementExcellent 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