Equiniti India - Lead SQL Database Administrator

Job Title : SQL Server Database Administrator

Location : DLF - Porur (Chennai) / Electronic City Phase 2 (Bangalore)

Work Timing : US Shift (6 : 30 PM to 3 : 30 AM)

Work Mode : Hybrid (3 Days per week from office)

Role Summary :

The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a hands-on position requiring solid technical skills, as well as excellent interpersonal and communication skills.

The successful candidate will be responsible for the development and sustainment of all elements of SQL Server, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modelling in support of multiple development teams. The databases support an enterprise suite of application and management tools. Must be capable of working independently and collaboratively.

Specific experience and skills :

- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems both on premise and in the Public Cloud.

- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

- Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations

- Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.

- Refine and automate regular processes, track issues, and document changes

- Assist developers with complex query tuning and schema refinement.

- Administer SSRS reporting server.

- Assist developers with SSIS,SSRS development and production deployments.

- Provide 24x7 support for critical production systems (upon request).

- Perform scheduled maintenance and support release deployment activities after hours.

- Share domain and technical expertise, providing technical mentorship and cross-training to peers and team members.

- The role is based in any Equiniti India office, working US Hours, there may also be a requirement to participate in a call out rota, and for completing some activities outside of business hours where they may be service affecting.

ESSENTIAL DUTIES & RESPONSIBILITIES :

- 10+ years MS SQL Server Administration experience required

- Experience of AWS Public Cloud

- Knowledge of Automation techniques and tools (Powershell, Terraform, Puppet)

- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

- Experience with backups, restores and recovery models

- Knowledge of Clustering, Failover Cluster Instances (FCI) High Availability (HA) and Disaster Recovery (DR) options for SQL Server

- Experience working with Windows server, including Active Directory

- Experience administering SSRS reporting portal

- Experience building ETL using SSIS and reports using SSRS.

- Excellent written and verbal communication

- Flexible, team player, get-it-done personality

- Ability to multi-task and context-switch effectively between different activities

- Relevant Microsoft certifications a plus

- Relevant AWS certification a plus.

Benefits :

Being a permanent member of the team at EQ you will be rewarded by our company benefits, these are just a few of what is on offer :

- Business related certification expense reimbursement

- Comprehensive Medical Assurance coverage for dependents & Parents

- Accidental & Life cover 3 times of concerned CTC