What Drives Success

This position has a team size of 5 operating from the Chennai office, supporting global internal employees and the Database involves SQL Server and Oracle. The support involves mission-critical system and ensuring 24x7 availability of production system
24X7 DB Support (On-Call Support on weekends)
Support & Monitor – MSSQL Staging and Production Landscapes
Supporting Service Now and AR Tickets on DB Issues
Support and Deployment of SQL Azure Databases
Administration of configuration of Foglight tool for SQL/ DB Server notification & Alerts
Regular patch updates on MSSQL Landscapes
Attending Conferences on SQL component
Implementing best practices on SQL Server domain
Provision of Recent Servers and Databases
Planning / Sizing / Capacity Planning or Questions about proposed or approved projects
//Architecture, (re)design or current/existing or recent processes, systems, solutions including adoption of current processes from other groups such as computing, storage, backups, monitoring etc.
Upgrades, Support packs, Kernels,



Hardware replacements,
Create Maintenance Plans, Scripts, Processes, Procedures, guides for standard operations
Installation, Configurations, Tuning Parameters
Design, Deploy, build and Implement
Analytical Trending for performance, capacity and availability
Monitoring and responding to space, availability, errors, alerts, logs, standard jobs
Monitor Job Schedules in SQL Server
Analysis on reoccurring errors and fix errors proactively
Initial investigation into isolated performance issues - escalate quickly if it is a sev one major impact
perform standard SQL Server DB recovery request
Respond to SQL Server User maintenance requests (following guidelines). (No Local Operating System Users - SQL User and Role assignments only)
SQL Server - DB promotion to Prod or refresh to QA/DEV from Prod per
requests
Strong commitment to following SDLC/Change-Management principles
Self-starter and be a

📌 It Analyst Chennai (India)
🏢 Lennox International
📍 India