REF66866W - SQL DBA - (3-4 yrs exp) - Assistant Manager - EIT (Mumbai)
- 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
• Providing support on all versions of SQL Starting from 2014 to SQL 2022
• Installation and configuration of Standalone as well as clustered instances of SQL Server with SSIS/SSRS
• Patching of Standalone as well as clustered instances of SQL Server
• Hardening SQL Server as per WNS Standard DB Hardening policy
• Providing support for upgrade to higher versions
• Setting up of DR sites using log shipping, always on etc.
• Providing support for Backup / Restores / migrations of databases, logins and Jobs
• Providing support for troubleshooting of all issues related to Databases
• Troubleshooting performance issues, performance tuning and Query optimization
• Hands on Experience in development of ETLs using SSIS
• Providing support for SQL Database like Azure, AWS and SQL and Manged instance or RDS
• Though not mandatory expected to have working knowledge of Postgres on Windows
• Knowledge of AWS RDS PostgreSQL Administration
Qualifications
Any Graduate or Diploma in IT