About the Role:
We are seeking a highly skilled and technically proficient L3 Application Support 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/7 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:
●
Bachelor’s degree in Computer Science, Information Technology, or a related field.
●
10+ 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 8 years of hands-on 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 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.
Pay: ₹344,672.93 - ₹1,800,000.00 per year
Work Location: In person
