IT Analyst - Enterprise DBA

Lennox India Technology Centre; Chennai District; On-site; INR 600,000 - 900,000; Full time

Job summary

Lennox India Technology Centre in Chennai seeks a SQL Server DBA to join a 5-person team supporting global internal users and a mission-critical database environment. The role involves 24x7 on-call support, MSSQL staging/production management, and SQL Azure deployments.

The candidate should have strong SQL Server/T-SQL skills, experience with Foglight monitoring, and familiarity with disaster recovery, patching, and SDLC/change-management practices. Strong communication is essential.

Qualifications

• Bachelor in IT/CS with 3-5 years of relevant experience.
• Experience with SQL Server 2008 R2 to 2016 and patch management.
• Experience with Windows Server 2012/2016 and Linux OS.
• Experience writing PowerShell scripts to automate tasks.
• Experience maintaining SQL Server in production including DR, backup/recovery.
• Knowledge of data quality, data management and data testing strategies.

Responsibilities

• Install, configure and administer SQL Server 2008 R2 to 2016.
• Provide 24x7 on-call support for production systems and weekends.
• Monitor and support MSSQL staging and production landscapes.
• Support ServiceNow tickets related to DB issues and deploy SQL Azure databases.
• Administer Foglight for SQL Server notifications and alerts; perform patching.
• Plan sizing, capacity planning and provisioning of new servers/databases.
• Ensure SDLC/Change-Management compliance and communicate effectively across teams.

Skills

Troubleshooting principles

PowerShell scripting

SQL Server

SQL Azure

Windows/Linux administration

Foglight

Disaster recovery

SQL/TSQL

Cloud platforms

Education

Bachelor in IT/CS

Tools

Foglight Monitoring Tool

SQL Azure

Job description

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 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 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 - elevate 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 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 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.

• Installation Configuration and Administration of SQL Server 2008 R2 to 2016
• Experience in Disaster recovery, backup and recovery
• Experience in database migration/upgrades and patch management
• Expertise in Database Performance /Tuning, Query Optimization
• Experience supporting mission-critical system and ensuring 24x7 availability of production system.

Required Skills

• Proven experience with troubleshooting principles, methodologies and issue resolution techniques
• Bachelor in IT/CS with 3 - 5 years of relevant experience
• Experience working on Windows 2012, Windows 2016 and Red Hat LINUX operating systems
• Experience writing Power Shell scripts to automate, monitoring, perform maintenance operations.
• Ability to work with 3rd party vendors to implement technology initiatives and resolve problems/issues/bugs.
• Foglight Monitoring Tool Administration and Configuration
• Experience on managing and administration of SQL Azure databases
• Good experience in supporting SOX, PCI and PII compliance controls
• Experience in SQL/TSQL
• Experience on Cloud platforms

Nice to have

• Experience supporting Oracle RAC, ASM and Clusterware.DataGuard is a plus.
• Experience working in OEM
• Experience on Virtualization
• 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.
• Familiarity with ITIL concepts, specifically in the area of service delivery preferred.
• Requires familiarity database objects, relationship and security.
• Requires clear written and verbal communication in a technical context