Shift Lead Engineer

Job Description

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