Senior Microsoft SQL Database Administrator

Description  :

The Database Admin Consultant will be a member of the Global Database Engineering team, which is responsible for supporting database operations for our managed hosting and managed services customers. You will be working on our ticketing tools to troubleshoot and resolve the proactive and reactive incidents, create and execute change requests, work on other database requests from our customers and troubleshoot recurring incidents through problems tickets. You may also be expected to provide Tier 3 / 4 escalation support for Lumen Hosting Operations Engineers and customers in their MS-SQL environment. You will be required to work closely with other DBAs in a global team as well as application, systems operations and engineering teams.

Required skills :

Good hands-on technical knowledge of all running versions of Microsoft SQL ServerDatabase Administration

7+ years of experience in SQL Server database administration / support in SQL Server production environments

Good understanding of Managing Databases on Azure / AWS

Working experience with SSRS (SQL Server Reporting Services) & SSIS (SQL Server Integration Services)

Ability to troubleshoot MSSQL Server performance issues to including server configuration, indexes, queries, as well as being able to identify network and disk related issues.

Implementation and troubleshooting knowledge of SQL server security techniques viz. TDE, SSL, Always-Encrypted etc.

Implementing and supporting High availability and Disaster recovery techniques offered by SQL server including log shipping, replication, database mirroring and Always On, Clustering

Proficient in administration and management of hosted Windows computing environments

Migration experience from Sybase database to MSSQL.

Good understanding of ITIL methodologies for change, incident problem and request management

Automate recurring database tasks

Strong communication skills and customer-support focused attitude

Self-starter who can work in mission critical environments with minimal supervision.

Good to have  :

Basic Microsoft Windows Server administration experience

Windows server failover clustering knowledge

Anyone of these scripting knowledge (Powershell, Python, Perl, VBscript, Javascript, C#)

Understanding of various 3rd party database monitoring and administration tools

Experience with third-party backup and HA tools (SQLSafe, LiteSpeed, DoubleTake, WanSync)

Microsoft SQL Server certification

Migration of Sybase database to MSSQL database.