Senior PL-SQL Developer - Shell Scripting

<p><p><b>Key Responsibilities : </b><br/><br/></p><p>- Design, develop, and optimize complex PL/SQL packages, procedures, triggers, and functions for enterprise-grade applications.<br/><br/></p><p>- Analyze business requirements and translate them into scalable database solutions.<br/><br/></p><p>- Perform code debugging, performance tuning, and query optimization for high-volume databases.<br/><br/></p><p>- For Shell Scripting & Unix specialization : <br/><br/></p><p>- Create and maintain Unix Shell scripts for data processing and automation tasks.<br/><br/></p><p>- Work with Unix/Linux environments for deployment, monitoring, and troubleshooting.<br/><br/></p><p>- For Oracle Forms & Reports specialization : <br/><br/></p><p>- Develop, customize, and maintain Oracle Forms (10g/11g/12c) and Reports to meet business needs.<br/><br/></p><p>- Ensure seamless integration between forms, reports, and PL/SQL modules.<br/><br/></p><p>- Collaborate with cross-functional teams to support development, testing, and production environments.<br/><br/></p><p>- Provide production support, root cause analysis, and implement permanent fixes for recurring issues.<br/><br/></p><p>- Prepare and maintain technical documentation and participate in code reviews.<br/><br/></p><p>- Ensure data security, integrity, and compliance with organizational Skills : </b></p><p><br/></p>- Advanced PL/SQL expert-level coding, debugging, and optimization.<br/><br/></p><p>- Database Performance Tuning knowledge of AWR, TKPROF, and indexing strategies.<br/><br/></p><p>- Shell Scripting & Unix for automation, deployment, and production support.<br/><br/></p><p>- Oracle Forms & Reports strong experience with Forms (10g/11g/12c) and Reports development.<br/><br/></p><p>- Database Platforms : Oracle Database (11g/12c/19c).<br/><br/></p><p>- Version Control Systems : Git, SVN, or similar tools.<br/><br/></p><p>- Familiarity with Agile/Scrum methodologies and SDLC best practices.<br/><br/></p><p>- Excellent communication and collaboration : </b></p><p><br/></p>- Bachelors or Masters degree in Computer Science, Information Technology, Engineering, or a related field.<br/><br/></p><p>- Oracle PL/SQL Developer or Oracle Forms & Reports Certification (preferred)</p><br/></p> (ref:hirist.tech)