Outscal Logooutscal logo
Company logo
Unbroken Studios
Maharashtra, India (On-site)

SQL DBA + SSRS/SSIS - Assistant Manager

4 Months ago • 3-4 Years

Job Description

As an Assistant Manager - EIT, you will be responsible for providing comprehensive support for SQL databases, ranging from 2014 to 2022 versions, including installation, configuration, and patching of SQL Server instances (standalone and clustered) with SSIS/SSRS. Your tasks will also encompass database hardening, upgrades, disaster recovery setup (log shipping, Always On), backup/restore/migration of databases, and troubleshooting database-related issues, along with performance tuning and query optimization. Experience in ETL development using SSIS is required. You will also need to provide support for SQL databases like Azure, AWS, and SQL Managed Instance or RDS. It is also expected to have working knowledge of Postgres on Windows and PostgreSQL Administration on AWS RDS. WNS is a leading Business Process Management (BPM) company.
Good To Have:
  • Knowledge of AWS RDS PostgreSQL Administration
  • Working knowledge of Postgres on Windows
Must Have:
  • Support for SQL versions (2014-2022)
  • Installation and configuration of SQL Server instances (SSIS/SSRS)
  • SQL Server patching and database hardening
  • Experience in ETL development using SSIS
  • Database backup, restore and migration
  • Troubleshooting database performance issues.

Add these skills to join the top 1% applicants for this job

azure
aws
sql
postgresql
problem-solving

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

Set alerts for new jobs by Unbroken Studios
Set alerts for new jobs in India

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug
Company
Contact Us
hello@outscal.com
Made in INDIA 💛💙