Minimum 5 years experience in SQL Server design and administration
Extensive knowledge of RDBMS concepts and hands-on experience on SQL Server 2008R2/2008/2005/2000.
Proficient in SQL 2008R2/2008/2005/2000 setup and installing hotfixes and SPs in clustered and un-clustered environments.
Complete understanding of SQL Server architecture
Capacity Planning and sizing
User and database security management i.e. creating groups, users, roles, granting permissions, policies etc.
Experience in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance.
Proficient in database backup and recovery models and DR strategies.
Expertise in HA techniques like Log Shipping, Replication, Database Mirroring and Clustering.
Monitoring database/server alerts/requests and resolve them within the agreed timelines.
Upgrade/Migration of SQL Server from earlier versions to the latest versions.
Experience in Batch processes, SSIS, DTS, OLAP, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
Working knowledge of DMVs and DMFs
Participate in business requirements review meetings for releases/projects.
Test Environment set up activities like creation of test database, test data and co-ordination with upstream & downstream system for data flow.
Plan successful deliveries in terms of Database within the estimated time bandwidths.
Involvement in defect management activities relevant to database and providing appropriate solutions.
Demonstrated ability to follow the best practices
Ability to take end-to-end ownership of the project.
Excellent written and verbal communication is must.
Proactive/organized at work, adaptable to any situation and flexible to work in shifts.
Mentoring and Imparting DB knowledge to the team members.
Good team player with strong analytical skills.
Maintaining in-detail SOPs and technical specification documents.
Knowledge of BI tools and techniques will be an added advantage
SQL Server Certification is desired
ITIL V3 certification will be an added advantage.