ADADP Private Limited
EFS Resource Pool F2C 170915
Hyderabad ₹5-9 LPA Posted 11 Nov 2026
FULL TIME
Oracle SQL & PL/SQL
PL/SQL Packages/Procedures/Functions
SQL Performance Tuning & Query Optimization
Unix/Linux & Shell Scripting
UTL_FILE & File Processing
Job Description
Roles & Responsibilities:
- Design, develop, and maintain Oracle PL/SQL solutions, including packages, stored procedures, functions, cursors, and exception-handling frameworks.
- Develop and support payroll-critical inbound and outbound file processing using Oracle UTL_FILE and database utilities.
- Create complex SQL queries for high-volume transactional and reporting applications.
- Conduct SQL and PL/SQL performance tuning through indexing, execution plan analysis, and query optimization.
- Troubleshoot production issues, perform root cause analysis (RCA), and implement stable application fixes.
- Build logging, error-handling, and exception-management mechanisms to enhance application reliability.
- Execute Unix/Linux command-line operations and shell scripting for batch processing, job scheduling, automation, and deployments.
- Enable banking and external system integrations, including file validation, data reconciliation, and failure recovery.
- Apply secure coding practices and deliver security fixes to protect sensitive payroll and financial information.
- Partner with Java, Spring Boot, and Angular development teams to support cross-functional application development and platform modernization.
- Use AI-assisted development tools for code generation, refactoring, test case preparation, and code reviews with appropriate validation.
- Convert business, payroll, and financial requirements into dependable technical solutions.
- Coordinate with stakeholders and cross-functional teams to ensure timely delivery and ongoing production support.
