17 Aug
|
Lennox India Technology Centre (LITC)
|
India
17 Aug
Lennox India Technology Centre (LITC)
India
Role & responsibilities
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
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
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 Current Servers and Databases
Planning / Sizing / Capacity Planning or Questions about proposed or approved projects
//Architecture, (re)design or current/existing or current 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 r
📌 It Analyst Chennai (India)
🏢 Lennox India Technology Centre (LITC)
📍 India