MS SQL DBA

Our client is a trusted global innovator of IT and business services. They help clients transform through consulting, industry solutions, business process services, digital & IT modernization and managed services. Our client enables them, as well as society, to move confidently into the digital future. We are committed to our clients’ long-term success and combine global reach with local client attention to serve them in over 50 countries around the globe.

· Job Title: MS SQL DBA

· Location: Noida

· Experience: 10+ yrs

· Job Type : Contract to hire.

· Notice Period:- Immediate joiners.

Mandatory Skills:

Top 3 skills which is mandatory

• MS SQL Always on

• Windows Server Cluster

• TDE(transparent Data Encryption)

POSITION OVERVIEW :

• 8+ years of relevant experience in managing MS SQL Servers and Azure SQL database and/or related infrastructure preferred

• Advanced experience on Always-On feature installation/configuration and troubleshooting

• 5+ years of experience in Windows Server Management

• Able to handle all SQL Database DBA related daily maintenance tasks.

• Good experience in Database and SQL Performance Tuning.

• Good experience on Windows Server patching and Mount points management

• Knowledge and experience on Databases Migration from On-premise to Azure

• Installing and Managing SQL Server all the versions

• Configuring and Administering Security /Policies/Resource Governing/MDW

• Managing Database Performance using MDW

• Implementation and Administration of across the Datacenters.

• Planning for Production Storage and Capacity Management.

• Hands on experience on Windows server issues, monitoring and troubleshooting.

• Creating databases from the ground up.

• Design, implement and operate database systems for performance and reliability.

• Administer production and development databases, ensuring maximum availability.

• Upgrade SQLServer from Legacy version to latest versions

• Applying Patches to SQL Server.

• Demonstrable experience of working effectively with Clients, Internal teams to resolve issues.

• Good knowledge in T-SQL scripting

• Trouble shooting and resolving database issues.

• Conforming to client compliances and expectations

• This role may entail after-hours support on an on-call basis.

• Good working experience all HA and DR solutions.

• Strong database troubleshooting and problem solving skills are required.

• Solid written and verbal communication skills.

• Strong time management skills

POSITION GENERAL DUTIES AND TASKS :

• Ability to think strategically and make collaborative decisions

• Ability to apply structured analysis methods to various types of data to establish trends, determine variability and business impact

• Communicates quickly, clearly, concisely, appropriately, and intelligently

• Foster open communication, speaks with impact, listens to others, and writes effectively

• Experience with alternate management methods using SSH, serial connections, and the command-line interface TMSH

• Ability to effectively negotiate with vendors on upgrades and acquisitions

• Effective planning, time management, negotiation, and delegation skills

• Ability to approach problems with an open-mind, use existing information and resources

• Creative, Innovative, problem-solving and maximizing your potential to solve problems and improve methods

• Think positively when faced with obstacles, build on others ideas, think logically and intuitively

• IT security processes and controls knowledge as well as IT infrastructure and networking technical knowledge

• Strong technical writing

• Experience in documentation tools such as Visio and Microsoft Office products