Shift Lead Engineer

Role & responsibilities

Title: Shift Lead Engineer - L3

Exp: 8+ years

Skills: Oracle PLSQ, RevPro Exp, RightRev Exp

Location: Chennai

Job Type: Full Time

Notice: Immediate

Hybrid - Yes

CTC 18 - 24 Lacs

Shift - Morning & Evening Shift

About the Role:

We are seeking a highly skilled and technically proficient L3 Application Lead Engineer with expertise in Oracle PL/SQL to join our dynamic team. In this role, you will be responsible for providing deep technical analysis, troubleshooting, and resolution of complex issues in business-critical software applications. As part of the 24/5 support operations, you will work closely with internal teams and external clients to diagnose root causes, implement fixes, and optimize application performance. Your expertise will play a key role in ensuring system stability, minimizing downtime, and enhancing overall efficiency.

Key Responsibilities:

• Analyze and resolve complex application issues by leveraging deep expertise in Oracle PL/SQL and Snowflake.
• Perform advanced debugging and root cause analysis, utilizing logs, scripts, and database queries to identify and fix issues efficiently.
• Optimize SQL queries, stored procedures, and database performance to ensure high availability and efficiency of enterprise applications.
• Proactively monitor application and database performance, identifying bottlenecks and implementing corrective measures to minimize downtime.
• Troubleshoot and resolve data integrity, performance, and security issues across on-premise and cloud-based environments.
• Work closely with development, DevOps, and infrastructure teams to escalate and resolve complex technical problems.
• Manage high-priority incidents and problem resolution processes within defined SLAs, ensuring minimal business impact.
• Automate repetitive operational tasks using scripts and database procedures to improve efficiency and reliability.
• Develop and maintain in-depth technical documentation, including troubleshooting steps, system workflows, and best practices.
• Lead application upgrades, patches, and configuration changes, ensuring compatibility and system stability.
• Assist in data validation, analytics, and reporting, supporting revenue optimization and business intelligence initiatives.
• Collaborate with software vendors and third-party service providers to troubleshoot and resolve application-related issues.
• Stay up to date with industry trends, best practices, and emerging technologies related to application support, cloud databases, and performance tuning.

Required Qualifications:

• Bachelors degree in Computer Science, Information Technology, or a related field.
• 8+ years of experience in Application Support, with at least 2-4 years specializing in Revenue Management Systems.
• Must be willing to work in shifts, including night shifts, weekends, and public holidays, as per business needs
• Extensive expertise in Oracle PL/SQL development with at least 4 - 6 years of hands-on coding experience, including writing complex queries, stored procedures, functions, triggers, materialized views, and performance tuning.
• Deep understanding of advanced PL/SQL concepts, such as bulk collections, pipelined functions, dynamic SQL, query optimization techniques (e.g., indexing, partitioning, execution plans, hints), and handling large datasets efficiently.
• Strong experience in database performance tuning and troubleshooting, including identifying slow-running queries, optimizing execution plans, and resolving deadlocks, locks, and contention issues.
• Proficiency in Snowflake data warehouse solutions, including data modeling, schema design, query optimization, and stored procedures using Snowflake SQL.
• Expertise in handling large-scale ETL processes, working with SQL Loader, external tables, bulk data processing, and integrating data between Oracle and Snowflake environments.
• Strong troubleshooting skills with expertise in analyzing application logs, system logs, and debugging SQL issues in a production environment.
• Understanding of ITIL principles and best practices.
• Excellent problem-solving, communication, and interpersonal skills.
• Ability to work in a fast-paced environment and manage multiple priorities.
• Strong analytical skills with attention to detail.

Preferred candidate profile

Preferred Qualifications:

• Experience in cloud platforms (AWS, Azure, Google Cloud) and DevOps practices.
• Familiarity with CI/CD pipelines, APIs, and microservices architecture.
• Knowledge of containerization technologies such as Docker and Kubernetes.

Anyone is interested please DM for more information & share me your Updated cv to mail ID: anusha.r@rrootshell.com

Thanks & Regards,

Anusha R

Ph No: 7989093547

Mail Me: anusha.r@rrootshell.com