Application Support Engineer - Shell Scripting & PL SQL

Description

We are currently seeking an experienced Application Support Engineer with expertise in Shell Scripting and PL SQL to join our team. The successful candidate will be responsible for ensuring the smooth operation of our applications and providing technical support to our clients. The ideal candidate will have 5-10 years of experience in Application Support.

Job Overview:

L2 Support Engineer role with expertise in shell scripting, PL/SQL, and application support hosted on web servers and Java servers.

(Candidate should be available to work in shifts any of these shifts ( 6AM to 3PM / 9AM to 6PM / 2PM to 10PM )- Monday to Friday)

Key Responsibilities:

1. Application Support:

Provide second-level support for applications hosted on web servers and Java servers.

Troubleshoot, analyze, and resolve application issues, ensuring minimal downtime.

Collaborate with L1 support and escalate complex issues to L3/engineering teams as needed.

2. Monitoring and Maintenance:

Monitor application logs, server health, and performance metrics using monitoring tools.

Proactively identify and address performance bottlenecks and potential issues.

Perform regular maintenance tasks such as clearing logs, restarting services, and patch updates.

3. Incident and Problem Management:

Analyze root causes of recurring issues and implement long-term solutions.

Document incidents, troubleshooting steps, and resolutions in a ticketing system (e.g., Jira, ServiceNow).

Ensure incidents and service requests are resolved within agreed SLAs.

4. Scripting and Automation:

Develop and maintain shell scripts for process automation and system monitoring.

Create and optimize scripts to manage application deployments, backups, and routine maintenance tasks.

5. Database Support (PL/SQL):

Write and execute SQL and PL/SQL queries to analyze and retrieve data for troubleshooting.

Optimize queries for performance and collaborate with DBAs for database-related issues.

Ensure proper data integrity and support data-related activities such as imports, exports, and audits.

Required Skills and Weightage:

1. Technical Skills: Strong knowledge of shell scripting and experience with process automation.

Proficiency in PL/SQL, including query writing, debugging, and optimization.

Experience in troubleshooting applications hosted on web servers (e.g., Apache, Nginx) and Java servers (e.g., Tomcat, WebLogic, JBoss).

Understanding of application architectures and logs analysis.

Familiarity with Linux/Unix environments.

2. Tools and Technologies: Monitoring tools (e.g., Nagios, Dynatrace, or equivalent).

Ticketing systems (e.g., Jira, ServiceNow).

Version control systems (e.g., Git).

3. Soft Skills: Strong analytical and problem-solving skills.

Excellent verbal and written communication skills.

Ability to work in a fast-paced environment and manage multiple priorities.

Team player with a proactive attitude.