Application Support Engineer

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 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 proactively monitoring and investigating issues across various critical business systems. This role requires a dynamic approach to identifying root causes and resolving problems efficiently to ensure smooth system operations. The position demands collaboration with different teams to maintain system stability and support business continuity through timely interventions and thorough analysis.

Roles & Responsibilities:
- Expected to perform independently and become an SME.
- Required active participation/contribution in team discussions.
- Contribute in providing solutions to work related problems.
- Collaborate with cross-functional teams to ensure seamless integration and support of business applications.
- Document and communicate findings and resolutions clearly to stakeholders and team members.
- Assist in the continuous improvement of support processes and tools to enhance service delivery.
- Provide guidance and support to junior team members to foster knowledge sharing and skill development.
-Expected to be an SME in Microsoft SQL Server domain.
- Collaborate and manage the team to perform.
- Install, configure, patch, and upgrade Microsoft SQL Server (2012–2022) instances.
-Manage database creation, configuration, tuning, and security.
-Perform database backups, restores, and integrity checks.
- Experience with performance tuning and troubleshooting SQL Server databases.
- Familiarity with backup and recovery strategies for SQL Server.
- Knowledge of security best practices for database management.
-Monitor and troubleshoot slow queries, long-running transactions, and index fragmentation.
-Optimize performance using indexing strategies, query optimization, and execution plan analysis.
-Use tools like SQL Profiler, Extended Events, and Database Tuning Advisor.
-Deploy and manage SQL Server in cloud environments like Azure SQL Database, Azure SQL Managed Instance, SQL on Azure VM & --Amazon RDS for SQL Server
-Support hybrid connectivity, backup-to-cloud, and DR solutions across cloud and on-premises.
-Implement and maintain database security policies: authentication, authorization, auditing, and encryption (TDE, Always Encrypted).
-Ensure compliance with regulatory requirements (e.g., GDPR, HIPAA, SOX).
-Perform regular user access reviews and permission audits.
-Design and maintain HA/DR solutions using always On Availability Groups & Failover Clustering, Log Shipping, Replication.
-Participate in DR drills and document failover/failback procedures.
-Automate routine tasks using T-SQL, PowerShell, or SQL Agent Jobs.
-Use monitoring tools (e.g., SolarWinds DPA, Redgate, SentryOne, Azure Monitor) for proactive health checks and alerting.

Professional & Technical Skills:
- Must To Have Skills: Proficiency in Microsoft SQL Server Administration.
-Maintain runbooks, change logs, and configuration documentation.
-Provide L2/L3 support for database incidents and service requests.
-Collaborate with application, infrastructure, and cloud teams.
-need to have experience in SQL Server 2012–2022, SSMS, SSIS, SSRS, SSAS
-need to have experience in HA/DR Always On AGs, Log Shipping, Replication, Clustering
-Experience in cloud platforms Azure SQL DB, SQL Managed Instance, SQL on Azure VM, Amazon RDS
-Experience in Scripting & Automation T-SQL, PowerShell, SQL Agent
-Experience in Monitoring & Tools Redgate, SolarWinds DPA, SentryOne, Azure Monitor, Extended Events
- Experience Security TDE, Always Encrypted, RBAC & Auditing
-Experience in Native SQL backup, Commvault, Veeam (optional)
-Experience in Git, Azure DevOps, Redgate Source Control
-Excellent communication and documentation abilities.
-Ability to work independently and collaboratively.
-Strong attention to detail and process orientation.

15 years full time education

About Accenture

Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with approximately 791,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities.

Visit us at www.accenture.com 

Equal Employment Opportunity Statement

We believe that no one should be discriminated against because of their differences. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, military veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by applicable law. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.