Application Support Engineer (SQL Application)
This is a Technical Job & We need candidates who have at least 2-6 Years of experience in SQL. Experience in Production Management for Windows Application server. Technically sound on MS SQL 2016. CRM Next application experience will be an add-on for this role.
About the Role
Candidate must have technical production support experience.
Candidate should ensure 99.99% uptime of a system.
Candidate must know the ITIL process of change/release management.
Candidate must have hands-on experience in issue analysis and bug fixing
Candidate must know SIT and UAT testing
Candidate must have hands-on experience with ticketing tools like Unidesk, Unicenter, etc.
Candidate must know about Windows scheduler and SQL scheduler
Candidate has docker and container will be preferable
Candidate has experience with monitoring tools like AppDynamics, Appnomic, and Dynatrace will add an advantage.
Candidate should know the criticality of P1, P2, P3, and so on category ticket
The desired candidate should have quality communication and technical Knowledge such as .NET, SQL Server, IIS, API, and Java.
The candidate must also possess experience in software development, deployment, and maintenance.
Strong skills in applications production support mainly within Windows Server, MS-SQL, IIS, and Technology.
Candidate having CRM Next knowledge will be preferable.
Key Responsibilities
Perform daily health checks of application and update status in health check sheet.
Proactively monitoring application performance, Integration jobs/Batch processing.
Monitor tickets assigned in group and act for closure
Ensure all tickets close as per agreed time (As per SLA agreement).
Coordinate with multiple teams for incident resolution like Server Team, DBA Team, Network Team, Storage Team, etc.
Provide data to the different business teams by running SQL queries.
Perform deployment of release in SIT and prepare SIT test cases.
Perform Production release deployment and monitoring.
Periodically review the system performance and capacity to avoid any impact on availability.
Participate in BCP Drill activity & update the Run Book
Qualifications
BSc IT/ B. Tech
Role Proficiencies:
Experience in Production Management for Windows Application server
Technically sound on MS SQL 2016
Writing SQL Queries, View, Store Procedure
Creation of Web site on IIS Server
Create and modified SQL jobs and Window batch files
CRM Next application experience will be an add-on for this role