PL/SQL Support
BONbLOC · Chennai, India
FULL TIME
Job Description
Job Summary:
We are looking for an experienced PL/SQL Support Engineer with 8+ years of handson experience in Oracle PL/SQL development and production support. The ideal candidate should have strong troubleshooting and debugging skills and preferably have experience working in a logistics, transportation, supply chain, or related domain.
The role requires someone who can independently handle production issues, analyze complex PL/SQL code, troubleshoot database-related problems, and provide timely support to business-critical applications.
Key Responsibilities:
• Provide L2/L3 production support for Oracle database and PL/SQL-based applications. • Develop, maintain, and troubleshoot PL/SQL procedures, functions, packages, triggers, and complex SQL queries. • Analyze and resolve production issues within defined SLAs. • Perform root cause analysis (RCA) for recurring and critical issues. • Troubleshoot database performance issues and optimize SQL queries and PL/SQL code. • Monitor batch jobs, interfaces, and scheduled processes and resolve failures. • Work closely with application, functional, and business teams to understand and resolve issues. • Perform data analysis and data fixes when required, following appropriate change-control procedures. • Handle incident, problem, and change management activities. • Prepare technical documentation and support knowledge-sharing activities. �� Participate in production deployments, release activities, and post-deployment validation.
Required Skills:
• 8+ years of hands-on experience in Oracle PL/SQL. • Strong experience in: o SQL and PL/SQL o Stored Procedures o Functions o Packages o Triggers o Cursors o Exception Handling o Complex SQL queries • Strong production support and troubleshooting experience. • Good understanding of Oracle database architecture and performance tuning. • Experience with SQL query optimization and database performance analysis. • Ability to debug and resolve complex production issues independently. • Experience with batch jobs, scheduling, and data interfaces. • Good communication and stakeholder-management skills.
Preferred / Domain Experience:
• Experience in Logistics / Transportation / Supply Chain applications is highly preferred. • Experience working with transportation management, shipment, order, warehouse, routing, or delivery-related systems will be an advantage. • Candidates with strong PL/SQL production support experience in other business-critical domains may also be considered.
We are looking for an experienced PL/SQL Support Engineer with 8+ years of handson experience in Oracle PL/SQL development and production support. The ideal candidate should have strong troubleshooting and debugging skills and preferably have experience working in a logistics, transportation, supply chain, or related domain.
The role requires someone who can independently handle production issues, analyze complex PL/SQL code, troubleshoot database-related problems, and provide timely support to business-critical applications.
Key Responsibilities:
• Provide L2/L3 production support for Oracle database and PL/SQL-based applications. • Develop, maintain, and troubleshoot PL/SQL procedures, functions, packages, triggers, and complex SQL queries. • Analyze and resolve production issues within defined SLAs. • Perform root cause analysis (RCA) for recurring and critical issues. • Troubleshoot database performance issues and optimize SQL queries and PL/SQL code. • Monitor batch jobs, interfaces, and scheduled processes and resolve failures. • Work closely with application, functional, and business teams to understand and resolve issues. • Perform data analysis and data fixes when required, following appropriate change-control procedures. • Handle incident, problem, and change management activities. • Prepare technical documentation and support knowledge-sharing activities. �� Participate in production deployments, release activities, and post-deployment validation.
Required Skills:
• 8+ years of hands-on experience in Oracle PL/SQL. • Strong experience in: o SQL and PL/SQL o Stored Procedures o Functions o Packages o Triggers o Cursors o Exception Handling o Complex SQL queries • Strong production support and troubleshooting experience. • Good understanding of Oracle database architecture and performance tuning. • Experience with SQL query optimization and database performance analysis. • Ability to debug and resolve complex production issues independently. • Experience with batch jobs, scheduling, and data interfaces. • Good communication and stakeholder-management skills.
Preferred / Domain Experience:
• Experience in Logistics / Transportation / Supply Chain applications is highly preferred. • Experience working with transportation management, shipment, order, warehouse, routing, or delivery-related systems will be an advantage. • Candidates with strong PL/SQL production support experience in other business-critical domains may also be considered.
Details
| Company | BONbLOC |
| Location | Chennai, India |
| Type | FULL TIME |
| Niche | general |