Responsibilities: -

Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

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 modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.

Independently analyze, 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.

Provide 24x7 support for critical production systems.

Perform scheduled maintenance and support release deployment activities after hours.

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

Oracle and DB2 DB experience is added advantage.

Role and Qualifications: -

Minimum 6 years MS SQL Server Administration experience required.

Experience on Installation, configuration, and maintenance of SQL Servers 2008R2, 2012, 2014 ,2016, 2017, 2019.

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

Experience with upgrades/Migrations from SQL 2008R2 to SQL 2014/2016/2017/2019.

Experience in Installing service packs, and client installations as required.

Troubleshooting blocking issues, deadlock issues, disk space issues and providing solutions for all SQL server issues.

Experience with backups, restores and recovery models.

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

Experience in Always on AG configuration, Failovers, adding or removing DB’s from the existing AG set up, adding new DR replicas to the existing AG Configuration.

Experience in configuring, Maintaining, and troubleshooting linked server issues.

Experience with security administration, configuring permissions and assigning roles to users.

Experience in Performing database health checks using SQL profiler, performance monitor, DMV’S and DBCC commands.

Experience in Scheduling and Maintaining Jobs, Alerts and Maintenance plans.

Experience in Monitoring, Maintaining and Troubleshooting High Availability options being used in Log Shipping, Mirroring and Replication.

Implementation of Database change requests (ITIL Processes).

Experience working with Windows server, including Active Directory.

Excellent written and verbal communication.

Flexible, team player, “get-it-done” personality.

Ability to organize and plan work independently.

Ability to work in a rapidly changing environment.

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

Create and review standard operating procedure documents and norms.

Address incident and problem tickets on a direct or indirect basis.

Participate in project planning and incident review meetings.

Mitigate vulnerabilities identified within the Citrix Infrastructure.

Participate in disaster recovery planning and simulation exercises.

Recommend process improvements to existing operational support models.