16 Aug
|
Lennox India Technology Centre (LITC)
|
Chennai
16 Aug
Lennox India Technology Centre (LITC)
Chennai
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 new processes, systems, solutions including adoption of new 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)
🏢 Lennox India Technology Centre (LITC)
📍 Chennai