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.

Qualification 15 years full time education