Lennox (NYSE: LII) Driven by 130 years of legacy, HVAC and refrigeration success, Lennox provides our residential and commercial customers with industry-leading climate-control solutions. At Lennox, we win as a team, aiming for excellence and delivering innovative, sustainable products and services. Our culture guides us and creates a workplace where all employees feel heard and welcomed. Lennox is a global community that values each team member’s contributions and offers a supportive environment for career development. Come, stay, and grow with us.

• 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 and  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 New 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 the 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, and 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, and standard jobs
• Monitor Job Schedules in SQL Server
• Analysis of reoccurring errors and fixing errors proactively
• Initial investigation into isolated performance issues - escalate quickly if it is a severe one significant impact
• perform standard SQL Server DB recovery request
• Respond to SQL Server User maintenance requests (following guidelines).
• 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 able to perform work with minimal supervisory direction
• Knowledge of data quality, data management and data testing strategies and practices
• Strong Oral and written skills.
• Able to communicate efficiently and effectively to technical and non-technical audiences.
• Anticipate and handle critical situations.

To perform this job successfully, an individual must be able to satisfactorily perform each essential duty. 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 essential functions.

• Installation, Configuration, and Administration of SQL Server 2012 and above in Windows, Linux, and SQL Azure cloud services DbaaS,  IaaS
• Rich experience in deployment and managing databases cloud platforms Azure
• Experience in Disaster recovery solutions, backup, and recovery
• Experience in database migration/upgrades and patch management
• Expertise in Database Performance /Tuning, Query Optimization
• Experience supporting mission-critical systems and ensuring 24x7 availability of production systems.
• Proven experience with troubleshooting principles, methodologies, and issue resolution techniques
• Experience working on Windows 2012 - 2022 and Red Hat LINUX operating systems
• Experience in writing Power Shell scripts to automate, monitor, perform maintenance operations.
• Good experience in supporting SOX, PCI, and PII compliance controls
• Experience in SQL/TSQL
• Rich experience in Failover cluster instance and AlwaysOn
• Hands on experience in transactional, merge and snapshot replications
• Hands on experience in transparent data encryption (TDE)
• Experience in handling databases in a Virtualization environment
• Hands-on experience with SSIS, SSAS, and SSRS administration
• Hands on experience in managing an In-Memory OLTP environment
• Strong knowledge of Columnstore indexes
• Strong knowledge of Partitioning
• Strong knowledge in managing databases with FILESTREAM

Nice to Have

•  Experience working with Postgres
•  Foglight Monitoring Tool Administration and Configuration
•  Experience on Cosmos DB/NoSQL is plus
•  Demonstrated progressive experience in enterprise design and implementation.
•  Working as a team member with technical corporate engineering team.
•  Knowledge of Automation tools Puppet, Ansible, and Kubernetes
•  Familiarity with ITIL concepts, specifically in the area of service delivery preferred.
•  Requires familiarity with database objects, relationships, and security. Requires clear written and verbal communication in a technical context.
•  Ability to work with 3rd party vendors to implement technology initiatives and resolve problems/issues/bugs.