Should have worked in L1/L2/L3 Production Support Projects
Should be very strong in his core SQL DBA skills
Experience with MS SQL Server 2005, 2008, 2008 R2, and 2012
Experience with SQL Server Mirroring and Replication
Experience with SQL Server Clusters
Strong troubleshooting skills for resolving various performance issues and tuning.
Experience in Database backup, recovery and disaster recovery concepts
Experience in Performance Tuning and Optimization, using monitoring and troubleshooting tools
Strong experience in managing database security, user accounts and access privileges
Ability to work independently and provide time estimates for database related tasks
Strong troubleshooting and customer service skills.
Perform data migration, and redaction utilizing approved tools and process
Monitor database for growth and respond to any application issues
Develop capacity model based on requirements
Identify and recommend changes to poorly performing SQL to the application developers, object statistics gathering, data level migration, schedule application jobs to perform data housekeeping and maintenance
Review and recommend efficiencies in application design as it relates to the operationalization of the applications.