A Microsoft SQL Server DBA Consultant shall possess 7+ years technical knowledge and experience with the following systems, platforms, applications skills:

 

• Experience administrating Microsoft Windows Server – versions 2008 R2 / 2012 / 2014/ 2016


• Experience building Microsoft Windows Clusters using Microsoft Windows Server – versions 2008 R2 / 2012 / 2014 / 2016


• Experience with Microsoft SQL Server databases, capacity planning, performance tuning, high availability in complex environments and mission critical applications.


• Experience with T-SQL, PowerShell, VB.Net, VB Script, and Windows Script


• Expert with Microsoft SQL Server, Microsoft SQL Server Reporting Services(SSRS), Microsoft SQL Server Integration Services(SSIS), Microsoft SQL Server Analytical Services(SSAS) - versions  2008 R2 / 2012 / 2014 / 2016


• Experience building/deploying SSIS packages


• Experience building/deploying SSRS reports


• Experience providing SSAS support


• Experience building/deploying SQL Jobs, including database maintenance packages


• In-depth experience with installation, configuration, upgrade, patching, migrating the above Microsoft SQL Server products to higher versions or/and different hardware or/and different OS, including SQL Server in a clustered environment.


• Expert in disaster recovery


• Expert Microsoft SQL Server DBA hands on skills in supporting a production database in all operations, such as troubleshooting daily operational issues|


• Expert in being able to troubleshoot various issues within Microsoft Windows Server or/and Microsoft SQL Server


• Providing end user support and customer service management.


• Extensive knowledge with complex SQL and T-SQL programming and optimization.


• Good writing skills to provide documentation for DBA and other teams.


• Tracking, monitoring, and reporting database jobs and processes using various software products


• Communicate and prepare management reports to IT management and end users

• 5+ years hands-on MS SQL Server administration and operation experiences


• Strong knowledge of MS SQL Server HA and DR solutions


• Proven expertise in query optimization and database performance management


• Detail oriented and have a ability to meet project deadlines in a fast moving environment 

Interview process:- In-person interview followed by Phone interview.