18 Nov
|
Accenture in India
|
Gurugram
18 Nov
Accenture in India
Gurugram
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
Valuable to have skills : NA
Minimum 3 Year(s) Of Experience Is Required
Educational Qualification : 15 years full time education
Summary
As an Application Support Engineer, a typical day involves acting as a software detective by investigating and resolving issues across various components of essential business systems. This role requires a proactive approach to monitoring system performance, diagnosing problems, and ensuring the smooth operation of critical applications. The position demands collaboration with different teams to maintain system stability and deliver timely solutions that support business continuity and efficiency.
Roles & Responsibilities:
- Administer SQL Server databases across development, test, UAT, and production environments.
- Monitor availability, capacity, backup status, SQL Agent jobs, disk space, database growth, and performance alerts take timely corrective action.
- Perform routine patching, upgrades, database refreshes, migrations, restores, and maintenance activities following approved procedures.
- Support HA/DR operations, including Always On Availability Groups, Log Shipping, Replication, clustering concepts, and planned failover activities.
- Troubleshoot common performance issues and escalate complex issues with supporting evidence.
- Support application teams with database access, user/role provisioning, query troubleshooting, deployment activities, and release validation.
- Maintain operational documentation, job schedules, backup/restore records, runbooks, and change evidence.
- Participate in on-call support and meet agreed SLA commitments.
- Use approved AI-assisted tools to summarize alerts, draft incident updates,
improve runbooks, and accelerate first-level troubleshooting.
- Validate all AI-generated scripts, recommendations, and summaries before use do not expose credentials, production data, or confidential information to unapproved tools.
- Contribute reusable prompt templates and automation ideas for repetitive DBA activities.
Professional & Technical Skills:
- Strong hands-on Microsoft SQL Server administration experience across production environments.
- SQL Server installation, configuration, patching, upgrades, side-by-side migrations, backup/restore, and disaster-recovery testing.
- Always On Availability Groups, Failover Cluster Instances, Log Shipping, Replication, clustering concepts, and HA/DR troubleshooting.
- Performance tuning using Query Store, execution plans, Extended Events, DMVs, wait statistics, blocking/deadlocks, indexing, statistics, tempdb, CPU, memory, and I/O analysis.
- T-SQL, SQL Agent, maintenance automation, database security, auditing, encryption, and least-privilege access.
- Azure SQL Database, Azure SQL Managed Instance and/or SQL Server on Azure VM AWS exposure is desirable.
- Automation using PowerShell, T-SQL, dba tools and/or Python Git/Azure DevOps or equivalent controlled deployment practices.
- ITIL Incident, Change and Problem Management runbooks, RCA, and stakeholder communication.
- Good to have: PostgreSQL, MongoDB, Oracle, MySQL, or managed cloud database services.
Additional Information
- The candidate should have minimum 3 years of experience in Microsoft SQL Server Administration.
- Bachelor s degree in Computer Science, Information Technology, Engineering, or equivalent relevant experience.
- Strong ownership, communication, prioritization, and ability to work in a 24x7 production support model.
- Relevant Microsoft Azure, SQL Server, AWS, PostgreSQL, MongoDB, or Oracle certifications are desirable.
- This position is based at our Gurugram office.
- A 15 years full time education is required.
📌 Application Support Engineer (Gurugram)
🏢 Accenture in India
📍 Gurugram