REF37939U -MSSQL DB Admin AM - EIT - mumbai only ( 4+ yrs ) immediate joiners
- Full-time
Company Description
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
- Installation of Standalone as well as clustered instances of SQL Server
- Providing support for all versions of SQL Starting from 2012 to SQL 2019 Hardening SQL Server as per WNS Standard DB Hardening policy
- Regularly patching SQL server with Service packs,
- Cumulative updates. Providing support for upgrade to higher versions Implementation of DR using log shipping, Always on etc.
- Providing support for performance tuning Providing support for Backup/Restores and cloning of databases
- Providing support for troubleshooting all issues related to DB Knowledge of PostgreSQL desirable but not mandatory
- Hands on experience in development of ETLs using SSIS Knowledge of SSRS/SSIS
Mandatory
Architecture (Core Admin)
Backup & Restore
Log Shipping
Index Cluster
always on
Performance Tuning
Qualifications
Master / Bachelor / Diploma in Engineering/Computer Science /Information Technology or Any Graduate with requisite Experience