Y - Group Manager - WTS, - years - MS SQL DBA Azure Sql and CosmosDB - Mumbai

WNS (Holdings) Limited (NYSE: WNS), is a leading Business Process Management (BPM) company. We combine our deep industry knowledge with technology and analytics expertise to co-create innovative, digital-led transformational solutions with clients across 10 industries. We enable businesses in Travel, Insurance, Banking and Financial Services, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Healthcare, and Utilities to re-imagine their digital future and transform their outcomes with operational excellence.We deliver an entire spectrum of BPM services in finance and accounting, procurement, customer interaction services and human resources leveraging collaborative models that are tailored to address the unique business challenges of each client. We co-create and execute the future vision of 400+ clients with the help of our 44,000+ employees.

Job Description

Job Description

Qualification :

• Diploma/Graduate
• Experience with 8 Years to 12 Years in same or related
• Preference for Domain specific certifications
• Knowledge of scripting languages like SQL, Python
• 5+ years of experience with Azure database technologies (PaaS) including Azure Sql and CosmosDB
• 10+ years of experience with Microsoft Sql (on-prem/IaaS)

Expectations : 

• Must be knowledgeable in best practices
• Accountable for ensuring SLA adherence with on time ticket acceptance and closures.
• Ready to work in Rotational shifts(24x5).
• Required to prepare Technical SOP's and bring in improvements.
• Managing and prioritizing assigned tasks collaborating with team members when needed – business projects, change controls, documentation, and vulnerability remediation, etc.

• Bachelor’s degree in a technical field, or experience and certifications showing required knowledge.
• Highly knowledgeable in performance tuning including query optimization
• Exceptional communication skills
• Comfortable working on multiple projects and issues simultaneously
• Demonstrable desire to learn and remain current with technical knowledge.
• Provide breakdowns of technical projects into steps with time estimates
• Collaborate with colleagues (development teams, infrastructure, management)
• Expert level technical troubleshooting and problem solving
• Knowledge with service principals, managed identities, private endpoint networking
• Comfortable working in an Agile-like environment, working in a backlog such as with Jira or other tools.
• CI/CD tools such as Azure Pipelines, GitHub actions, Jenkins, or other
• Experience with Log Analytics, Application Insights, and other Azure Monitor tools
• Excellent troubleshooting, debugging capabilities.

Responsibilities : 

• Contribute to documentation by writing and updating existing documents and diagrams.
• Assist with escalated issues/tasks
• Comfortable in ITIL change management submissions and process
• Familiarity with IaaS in Azure, backups for them, configurations, vm families
• Applied knowledge of ISO 27001 / SOC Controls
• Provide RCA for Technical issues.
• Information and Data Security principles
• ITIL Policies and procedures operations
• Comfortable in ITIL change management submissions and process, and being a CAB member
• Expert knowledge of SQL clusters and BCDR
• When to use DTU vs vCore • Running daily health checks and ensuring uptime
• Performing backups and recoveries
• Applying patches and upgrades
• Troubleshooting and resolving database issues
• Documenting and optimizing database processes
• Collaborating with the internal IT team to ensure a seamless workflow.
• Configuration based, version based, policy based issues are handled
• Support New scope, changing scope, expanding scope
• Maintain keys, maintain connectivity to servers and AD
• Work Issues related to connectivity to data warehouse
• Support on issues related to Server running slowly, scaling issues
• Skill to Manage Physical and Virtual Servers in a large environment typically 100+ Servers.
• Knowledge of ITIL
• Knowledge of networking fundamentals.
• Experience in tracking server activity, performing upgrades of software, addressing technical problems.
• Good Documentation Skills

Tool/Application/Software : 

Must have workable knowledge on any of the below mentioned Tool/Application/Software-
• MS SQL
• Azure SQL
• CosmosDB
• Redis
• Backup/restoration software beyond native SQL capabilities
• Server performance monitoring & tuning

Qualifications

Qualifications

Bachelor’s Degree