Application Support Engineer
Application/Cloud Support Team Lead/Consultant
|
Full time
|
Experience: 5-10 years
Job No. ATCI-5639193-S2032093
|
Indore
|
Required Skill: Microsoft SQL Server Administration
Project Role : Application Support Engineer
Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems.
Must have skills : Microsoft SQL Server Administration
Good to have skills : NA
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education
Role Summary:
The Team Lead – SQL Server DBA leads a team of database administrators responsible for managing enterprise-grade SQL Server environments across on-premises data centers and Azure IaaS/PaaS platforms. The role combines hands-on technical expertise with team coordination, client interaction, and continuous service improvement responsibilities. The candidate will drive operational excellence and contribute to cloud transformation initiatives.
Key Responsibilities:
Lead, mentor, and coordinate a team of 4–8 SQL DBA analysts assign tasks and review outputs.
Serve as technical escalation point for P1/P2 critical database incidents.
Plan and execute SQL Server patching, upgrade, and migration projects end-to-end.
Design and implement HA/DR strategies including Always On AG, log shipping, and Azure geo-redundancy.
Review and approve database change requests conduct peer review of scripts and runbooks.
Conduct weekly/monthly service reviews with clients prepare capacity and performance reports.
Drive root cause analysis (RCA) for major incidents and implement preventive measures.
Define and enforce DBA standards, naming conventions, and security baselines.
Manage on-premises to Azure migration projects — assessment, planning, execution, and hypercare.
Collaborate with application, network, and storage teams for infrastructure design and DR drills.
Identify automation opportunities build PowerShell/T-SQL scripts to reduce manual effort.
Ensure compliance with organizational security and audit requirements.
Technical Skills & Requirements
Deep expertise in SQL Server 2014–2022 administration and performance tuning.
Advanced T-SQL — query optimization, execution plan analysis, index tuning, statistics.
Always On Availability Groups — synchronous/asynchronous replicas, listener configuration, failover.
SQL Server on Azure IaaS — VM series selection, premium SSD, Azure Load Balancer for AG listener.
Azure SQL Managed Instance — managed instance link, business critical vs general purpose tiers.
Azure SQL Database — elastic pools, serverless tier, geo-replication, long-term backup retention.
Azure Monitor, Log Analytics, and Kusto Query Language (KQL) for DB alerting and dashboards.
PowerShell and Azure CLI scripting for automation, VM management, and Azure resource deployment.
Database security — TDE, Always Encrypted, Dynamic Data Masking, Row-Level Security, Azure AD auth.
SSRS, SSIS, and SSAS administration experience preferred.
ITSM process ownership — change management, problem management, and SLA governance.
Azure IaaS & PaaS Administration
Azure IaaS: Manage SQL Server on Azure Virtual Machines — VM sizing, availability sets, proximity placement groups, and Azure site recovery.
Azure PaaS: Administer Azure SQL Database and Azure SQL Managed Instance — elastic pools, service tiers, DTU/vCore sizing.
Configure and monitor Azure Database for SQL MI — failover groups, auto-failover, read replicas.
Manage Azure Storage accounts for database backups — LRS/GRS/ZRS replication, lifecycle policies, soft delete.
Use Azure Monitor, Log Analytics, and Azure Advisor for performance and health insights.
Implement Azure Private Endpoints and VNet service endpoints for secure database connectivity.
Manage Azure Key Vault integration for TDE keys, column encryption, and Always Encrypted.
Configure Azure Backup for SQL on IaaS VMs and Azure SQL Managed Instance backup policies.
Work with Azure NSGs, firewalls, and network topology to ensure secure DB access.
Participate in lift-and-shift and cloud migration projects — assessment, sizing, and post-migration validation.
Certifications (Preferred):
Microsoft Certified: Azure Database Administrator Associate (DP-300) — required.
Microsoft Certified: Azure Administrator Associate (AZ-104) — preferred.
MCSA/MCSE SQL Server — preferred.
ITIL Foundation or Practitioner — required.
Soft Skills
Strong leadership and team management capabilities.
Excellent client-facing communication and stakeholder management skills.
Ability to manage multiple priorities and work under pressure in a 24x7 environment.
Strong analytical and structured problem-solving approach.
Proactive mindset with a focus on automation and continuous improvement.
Experience working in managed services or large enterprise environments.
Additional Information:
- The candidate should have minimum 5 years of experience in Microsoft SQL Server Administration.
- This position is based at our Bengaluru office.
- A 15 years full time education is required.
Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems.
Must have skills : Microsoft SQL Server Administration
Good to have skills : NA
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education
Role Summary:
The Team Lead – SQL Server DBA leads a team of database administrators responsible for managing enterprise-grade SQL Server environments across on-premises data centers and Azure IaaS/PaaS platforms. The role combines hands-on technical expertise with team coordination, client interaction, and continuous service improvement responsibilities. The candidate will drive operational excellence and contribute to cloud transformation initiatives.
Key Responsibilities:
Lead, mentor, and coordinate a team of 4–8 SQL DBA analysts assign tasks and review outputs.
Serve as technical escalation point for P1/P2 critical database incidents.
Plan and execute SQL Server patching, upgrade, and migration projects end-to-end.
Design and implement HA/DR strategies including Always On AG, log shipping, and Azure geo-redundancy.
Review and approve database change requests conduct peer review of scripts and runbooks.
Conduct weekly/monthly service reviews with clients prepare capacity and performance reports.
Drive root cause analysis (RCA) for major incidents and implement preventive measures.
Define and enforce DBA standards, naming conventions, and security baselines.
Manage on-premises to Azure migration projects — assessment, planning, execution, and hypercare.
Collaborate with application, network, and storage teams for infrastructure design and DR drills.
Identify automation opportunities build PowerShell/T-SQL scripts to reduce manual effort.
Ensure compliance with organizational security and audit requirements.
Technical Skills & Requirements
Deep expertise in SQL Server 2014–2022 administration and performance tuning.
Advanced T-SQL — query optimization, execution plan analysis, index tuning, statistics.
Always On Availability Groups — synchronous/asynchronous replicas, listener configuration, failover.
SQL Server on Azure IaaS — VM series selection, premium SSD, Azure Load Balancer for AG listener.
Azure SQL Managed Instance — managed instance link, business critical vs general purpose tiers.
Azure SQL Database — elastic pools, serverless tier, geo-replication, long-term backup retention.
Azure Monitor, Log Analytics, and Kusto Query Language (KQL) for DB alerting and dashboards.
PowerShell and Azure CLI scripting for automation, VM management, and Azure resource deployment.
Database security — TDE, Always Encrypted, Dynamic Data Masking, Row-Level Security, Azure AD auth.
SSRS, SSIS, and SSAS administration experience preferred.
ITSM process ownership — change management, problem management, and SLA governance.
Azure IaaS & PaaS Administration
Azure IaaS: Manage SQL Server on Azure Virtual Machines — VM sizing, availability sets, proximity placement groups, and Azure site recovery.
Azure PaaS: Administer Azure SQL Database and Azure SQL Managed Instance — elastic pools, service tiers, DTU/vCore sizing.
Configure and monitor Azure Database for SQL MI — failover groups, auto-failover, read replicas.
Manage Azure Storage accounts for database backups — LRS/GRS/ZRS replication, lifecycle policies, soft delete.
Use Azure Monitor, Log Analytics, and Azure Advisor for performance and health insights.
Implement Azure Private Endpoints and VNet service endpoints for secure database connectivity.
Manage Azure Key Vault integration for TDE keys, column encryption, and Always Encrypted.
Configure Azure Backup for SQL on IaaS VMs and Azure SQL Managed Instance backup policies.
Work with Azure NSGs, firewalls, and network topology to ensure secure DB access.
Participate in lift-and-shift and cloud migration projects — assessment, sizing, and post-migration validation.
Certifications (Preferred):
Microsoft Certified: Azure Database Administrator Associate (DP-300) — required.
Microsoft Certified: Azure Administrator Associate (AZ-104) — preferred.
MCSA/MCSE SQL Server — preferred.
ITIL Foundation or Practitioner — required.
Soft Skills
Strong leadership and team management capabilities.
Excellent client-facing communication and stakeholder management skills.
Ability to manage multiple priorities and work under pressure in a 24x7 environment.
Strong analytical and structured problem-solving approach.
Proactive mindset with a focus on automation and continuous improvement.
Experience working in managed services or large enterprise environments.
Additional Information:
- The candidate should have minimum 5 years of experience in Microsoft SQL Server Administration.
- This position is based at our Bengaluru office.
- A 15 years full time education is required.
15 years full time education
Indore
平等就业机会声明
所有聘用决定均不考虑年龄、种族、信仰、肤色、宗教、性别、国籍、血统、残疾状况、退伍军人身份、性取向、性别认同或表达、基因信息、婚姻状况、公民身份或任何其他受联邦、州或地方法律保护的因素。
求职者在招聘过程中没有义务披露已封存或已删除的定罪或逮捕记录。
埃森哲致力于为我们的男女军人提供退伍军人就业机会。
请阅读埃森哲的招聘和聘用声明，了解更多关于我们在招聘和聘用过程中如何处理您的数据的信息。
We work with one shared purpose: to deliver on the promise of technology and human ingenuity. Every day, more than 775,000 of us help our stakeholders continuously reinvent. Together, we drive positive change and deliver value to our clients, partners, shareholders, communities, and each other.
We believe that delivering value requires innovation, and innovation thrives in an inclusive and diverse environment. We actively foster a workplace free from bias, where everyone feels a sense of belonging and is respected and empowered to do their best work.
At Accenture, we see well-being holistically, supporting our people’s physical, mental, and financial health. We also provide opportunities to keep skills relevant through certifications, learning, and diverse work experiences. We’re proud to be consistently recognized as one of the World’s Best Workplaces™.
Join Accenture to work at the heart of change. Visit us at www.accenture.com.