Sr. Lead Engineer - Azure SQL DBA

Our client is the leading global provider of healthy, safe and sustainable building and cold chain solutions with a world-class, diverse workforce. They are the world leader in high-technology heating, air-conditioning and refrigeration solutions. Their experts provide sustainable solutions, integrating energy-efficient products, building controls and energy services for residential, commercial, retail, transport, and food service customers.

From the beginning, they have led in inventing new technologies and entirely new industries. Today, they continue to lead because they keep customers at the centre of every product and service they offer and act quickly to exceed their expectations. Through their performance-driven culture, they are driving share owner value by growing earnings and investing strategically to strengthen the position in the markets they serve.

Role Description:

• Seasoned Software Engineering professional, working independently. 
• Conducts moderately complex tests and debugs control and diagnostic systems. 
• Undertakes multidisciplinary research, and works on system capabilities analysis to determine end user needs.

Responsibilities:

• You will be a key contributor to the design, development and implementation of Database for Enterprise applications. 
• This position will focus on new development/maintenance of Database Administration of application. 
• This position requires the ability to work under minimal direction in collaboration with a team of engineers to design and develop robust Database Admin solutions that meet defined system requirements.
• Ability to administer and manage the database for On-prem and Cloud environments.
• Strong experience on Azure DB resource management
• Demonstrated experience on setting up the Always-on with Multi locations (Cloud and On-Prem), Clustering, Data Sync and Indexing.
• Strong analytics and troubleshooting skills for managing the incident response on production environment.
• Ability to setup the monitoring & alerting on sql transactions (having SentryOne is added advantage).
• Assist with schema design, code review, SQL query tuning.
• Install, tune, implement and upgrade DBMS installations.
• Write and deploy SQL patches.
• Set and maintain database standards.
• Upgrade and improve application schema and data upgrades.
• Proactively and regularly make recommendations for system improvements
• Create and manage database reports, visualizations, and dashboards.
• Strong Communication and interpretation skills.

How you will do it

• You should be hands-on technical leader working closely with your peers in engineering, product management and senior management in the company to deliver best of breed solutions with your technical stewardship. 
• You will be responsible for below critical functions in helping we design leading products.
• Strong experience with database query languages such as PL/SQL.
• Strong experience in administering, managing, and tuning databases
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
• Understanding of relational and dimensional data modelling.
• Good understanding of data, schema standards and concepts.
• Good understanding of database design, implementation, troubleshooting and maintenance.
• Impeccable attention to details, Good time-management skills.
• Maintains solid relationships with key internal and external stakeholder.
• Stays abreast of technology developments and their potential impact and opportunities on the organization.
• Proactively identifies, recommends, and implements improvements.Be available for on-call support as needed.

Requirements:

• BE/B.Tech/M.Tech/MCA
• Must have 8-10 years relevant experience in managing the DBA activities that includes Architecture, Implementation, Troubleshooting and Monitoring of Microsoft SQL Server.
• Azure SQL PaaS experience, along with on-prem DBa(administrator) capabilities.
• Scripting language experience such as PowerShell, SQL Scripting.
• Familiarity with SSAS, SSIS, SSRS.
• Should have working experience on SQL Always-on, Data sync with Azure.
• Experience of working in an Agile environment.
• Excellent written and verbal communication skills.
• Strong customer focus and ability to think about the impact of actions on the customer.

Preferred

• Familiarity with DevOps