I applied online. I interviewed at Intone Networks (Houston, TX) in Feb 2016
Interview
Responsible for Installing SQL Server on new servers (2008/2012/2014).
Upgrading existing 2005/2008 Production Server to SQL Server 2012/2014 Version.
Moving several of the existing SQL 2005/2008 Production databases, jobs, packages, linked server and logins to new versions of SQL server.
Upgrading SSIS Packages to SQL Server 2012 version.
Handling day to day support tickets and development issues.
Responsible for On-call support and support escalation from offshore.
Interview questions [1]
Question 1
Working with Offshore team on pending issues and coordinating migration project activities to meet the project deadlines.
Responsible for database refresh and coordinating with QA Team.
Proactive monitoring of SQL server known issues related to performance.
Writing Custom scripts to refresh tables and monitoring jobs.
Troubleshooting performance issues in production and non-production servers.
Providing support for database mirroring, always on and log shipping implementation.