Basic Information

Ref Number

Req_00045849

Last day to apply

30-Apr-2021

Primary Location

NSEZ

Country

India

Description and Requirements

Experience:3 to 5 Yrs
  • Experience with Database Administration for MSSQL Server. 
  • Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data. 
  • Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues. 
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools 
  • Experience with backups, restores and recovery models. 
  • Experience with SQL in a virtualized environment (ESX and Azure). 
  • Knowledge of Always-On, High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. 
  • Experience in implementing operational automation using scripts. 
  • Identify areas of the SQL environment that are suited for automation and then implement a solution using a variety of tools from applications such as HPSA or through scripting (Powershell, TSQL). 
  • Knowledge of indexes, index management, and statistics. 
  • Experience working with Windows server, including Active Directory and proper disk configurations. 
  • Performs capacity planning of SQL server environment and provides recommendations to management to sustain business growth. 
  • Designs, implements, maintains Disaster Recovery (DR) methodologies, and creates documentation. 
  • Gathers business requirements and designs implement multiple projects along with production support. 
  • Creates standard operational procedures and templates. 
  • Actively and consistently support all efforts to simplify and enhance the customer experience. 
  • Designs and maintains access and security administration. 
  • Designs, implements and maintains backup and recovery strategies on Database Management Systems.
  • Acts as mentor for Database Administrators and Associate Database Administrators. 
  • Performs research and provides plans to remediate complex business problems.

Additional Job Description

Experience with Database Administration for MSSQL Server. • Actively and consistently support all efforts to simplify and enhance the customer experience. • Designs and maintains access and security administration. • Designs, implements and maintains backup and recovery strategies on Database Management Systems. • Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data. • Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues. • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools • Experience with backups, restores and recovery models. • Experience with SQL in a virtualized environment (ESX and Azure). • Knowledge of Always-On, High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. • Experience in implementing operational automation using scripts. • Identify areas of the SQL environment that are suited for automation and then implement a solution using a variety of tools from applications such as HPSA or through scripting (Powershell, TSQL). • Knowledge of indexes, index management, and statistics. • Experience working with Windows server, including Active Directory and proper disk configurations. • Performs capacity planning of SQL server environment and provides recommendations to management to sustain business growth. • Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation. • Gathers business requirements and designs, implements multiple projects along with the production support. • Creates standard operational procedures and templates. • Acts as mentor for Database Administrators and Associate Database Administrators. • Performs research and provides plans to remediate complex business problems.