Skill / Role : TechnicalLead SQL Server DBA
Installations,configuration and security settings for SQL Server 2005, 2008 and2008R2 ,2012, 2016 Always ON stand-alone servers.
Upgrading / Migration the databases to SQL Server 2005 to2008 / 2008R2 / 2012 / 2016
Experience of Clustering,Replication, Logshipping & Mirroring, PerformanceOptimization. Experience with backups, restores and recoverymodels.
Ensure all database servers are backed up in a way thatmeets the business’s Recovery Point Objectives (RPO).
Knowledge on SSRS, SSAS, SSIS configurations.
Configureand maintain database servers and processes, including monitoringof system health and performance, to ensure high levels ofperformance, availability, and security.
Responsible for planningand organizing database, Database creation, performance tuning,restoration, patch installation etc
Independentlyanalyze, solve, and correct issues in real time, providing problemresolution end-to-end. Refine and automate regular processes, trackissues, and document changes.
Assist developers with complex querytuning and schema refinement.
Knowledge of HighAvailability (HA) and Disaster Recovery (DR) options for SQLServer
Experience in AlwaysOn.
Creation andmaintenance of database in cloud.
Knowledge on ITIL process.
Good Communication skill.
Good to have Experience in other DBtechnologies.