ProArch is seeking a highly skilled Senior PLSQL Developer to join our dynamic team. . As a Senior PLSQL Developer, you will work closely with cross-functional teams to understand business requirements and develop efficient and effective database solutions. The ideal candidate will have a strong background in Oracle PL/SQL development and a passion for delivering high-quality solutions.
Responsibilities:
- Design, develop, and maintain PLSQL procedures, functions, and packages
- Designing and Implementing solutions that extract high volumes of data from a wide variety of source systems
- Responsible for developing, enhancing, re-engineering maintaining web applications built with Oracle MDM
- Helping to ensure good engineering practices are adopted and used within the team
- Working closely with stakeholders to understand the various source systems including details of their interfaces, data models and capabilities in order to design appropriate solution
Requirements
- Bachelor's degree in Computer Science or related field
- Experience as a PLSQL developer.
- Must have knowledge in oracle 12c or higher.
- Knowledge with Oracle’s XML functions is mandatory.
- Experience in creating scheduler jobs.
- Experience with Table Partitions, indexes, Collections.
- Experience on writing complex stored procedures/ functions /Packages.
- Performance Tuning of SQL Queries and PL/SQL Programs.
- Knowledge in MATVIEWS is mandatory:
- Good to have knowledge in PIVOT clause, fact and dimension tables.
- Strong hands on experience of ETL process.
- Good to have knowledge in DB Links
- Good to have knowledge in Linux cron job, file watcher.
- Knowledge of data warehouse and utility domain adds an advantage.
- Knowledge on Complex Queries such as Hierarchical queries...etc.
- Knowledge on handling XMLTYPE and JSON data formats
- Advance concepts in PL/SQL such as bulk operations, bulk binding and collections
- Proficient in writing complex SQL queries, stored procedures, functions, and packages
- Experience with Oracle databases
- Knowledge of performance tuning and optimization techniques
- Strong analytical and problem-solving skills
- Excellent communication and collaboration abilities
- Ability to work independently and in a team environment