Oracle PL / SQL Developer - Job Description
Role Summary :
We are seeking a skilled Oracle PL / SQL Developer to design, develop, optimize, and maintain PL / SQL code for a regulatory database application which integrates with middleware and external APIs of MHA and DOT. The ideal candidate will have strong experience in database development, performance tuning, and application support.
Key Responsibilities :
- Design and develop PL / SQL procedures, functions, packages, and triggers
- Optimize and refactor existing PL / SQL code for performance and scalability
- Collaborate with application developers to integrate database logic with front-end systems
- Analyze and troubleshoot database issues, ensuring high availability and performance
- Participate in code reviews and adhere to best practices in database development
- Maintain data integrity and security across all environments
- Create and maintain technical documentation
Required Skills :
Strong experience with Oracle 19c / EXACCProficient in PL / SQL development and performance tuningExperience with SQL-Plus, TOAD, SQL Developer, or similar toolsUnderstanding of relational database design and normalizationFamiliarity with version control systems (e.g., Git)Knowledge of ETL processes and data migration is a plus(ref : hirist.tech)