Job Summary

　　Join a business that embraces innovation, gives you the scope to seize every opportunity and helps get you where you want to go. Life at Ensono begins in an unprecedented environment with a role that matters, taking you on a fast-paced journey of discovery, however big that might be.

　　In 2018, we nearly doubled our size in terms of revenue and associates. We expanded across Europe and India, scaling to meet the needs of our clients globally while still maintaining client intimacy as a top priority. In the last three years, we have grown to a global organization with more than 150 clients and $600M in revenue.

　　We believe we are uniquely qualified to meet our client's IT infrastructure needs from mainframe and private cloud to public cloud and consultative services to advance them along their IT transformation journey. Our purpose remains the same: to be their relentless ally, disrupting the status quo and unleashing them to do great things. Our 2,000+ associates across the world are committed to this purpose.

　　Job Description

　　Reports to the India Database manager. You will be part of the Global Implementation & Operational team, supporting the Operational & migration activities of mission critical infrastructure of Ensono's clients, delivering a responsive and exceptional support service for client events and requests. The ideal candidate will be responsible for the design, implementation, maintenance, and optimization of our SQL server databases while also possessing the ability to contribute to development projects as needed.

　　The job entails:

　　SQL Server Database Administration

　　Primary role will be to support our existing & new clients.Working with clients on issues, requests related to Projects.Working proactively and reviewing high level project requirements and deliverables.Lead & guide the team during major incidents & Outages.Automation of DBA best practices and collection processCollaborate with cross-functional teams to understand software requirements and deliver high-quality code.Troubleshoot and resolve performance issues and software deficiencies.

　　You will achieve common goals with our teams to create a positive learning environment where knowledge sharing will help all associates be able to support the environment. The position will be challenging with opportunities to work on a broad range of Cloud technologies and products.

　　Key Responsibilities

　　Lead the Development and Automation of internal tools.Design and enhance, upgrade, or build new client MSSQL environmentsWork closely with clients daily on projects, troubleshooting, or consultations.Perform software installations, upgrades, and patches to MSSQL instances and serversDefine and maintain MSSQL standards and governanceUtilize industry standard technologies & methods to ensure the integrity & recoverability of MSSQL applications.Perform strategic analysis and design of MSSQL infrastructure and make recommendations on improvements and/or new systems required to meet business needs and future capacity.Serve as technical resource to business analysts, solutions development, and other groups responsible for MSSQL application development standards, system design and integration.Ensure MSSQL systems remain at operational excellence during infrastructure improvements (hardware/software upgrades server migrations/consolidations, application deployment, etc.).Assist in creating new or maintaining documentation, runbook knowledge articles and diagrams.

　　Knowledge

　　Required

　　Excellent understanding of SQL Server Technology (builds, upgrades, patching, migrations, troubleshooting multiple versions of SQL Server)Experience of SQL Server database administration in versions ranging from 2008 to current versions.Experience of configuring and administering log shipping, mirroring, clustering and Always On availability groups.Experience with SQL Transaction replication on complex environments.Experience with SQL Performance Tuning and identifying bottlenecks.Experience in migrating server databases from on-premises environments to the public/private cloud.Knowledge of other Database technologies such as Postgres or cloud native databases is desirable.Excellent understanding of VMware and awareness of Cloud technologyExcellent technical awareness of IT server infrastructureWorking knowledge of tools, Ansible, Chef, Terraform, Python, Salt, Shavlik is desirable.Must have excellent communication skills since working directly with the client is a significant requirement of this position.Must have a deep understanding of AWS & Azure technologies related to SQL Server.

　　Desired

　　Netbackup, Commvault, Idera SQL Diagnostic managerPowershell Scripting.Knowledge of the ITIL frameworkExperience with automation using C#.

　　Skills

　　Ability to work independently, analyze the requirements, and provide solutions.A 'client centric' approachExcellent demonstrable English written and verbal communication skillsAble to communicate in groups with confidence and convictionAbility to multi-task and work well under pressureExcellent team working skills are essentialAbility to document processes and procedures in a clear, concise, and logical mannerSelf-starter with the capability to work independently and produce positive results that will keep migration timelines on schedule

　　Experience

　　At least 7-10 years' experience in an IT MSSQL support environment

　　.

　　Primary Location City/State:

　　India

　　Shift: 10:30 AM IST - 7:30 PM IST

　　JR009483