An experienced and highly skilled PL/SQL Developer with 10 years of hands-on experience in designing, implementing, and optimizing Oracle databases and PL/SQL programs. Adept at writing efficient, scalable, and complex SQL queries, stored procedures, functions, triggers, and packages. Proven ability to analyze, troubleshoot, and optimize database performance while ensuring data integrity and security.
### Key Skills:
- **PL/SQL Development**: Proficient in writing, maintaining, and optimizing PL/SQL code including stored procedures, functions, triggers, and packages.
- **Database Design**: Experience in database design, normalization, indexing strategies, and performance tuning.
- **Data Integration**: Expertise in using PL/SQL for data extraction, transformation, and loading (ETL).
- **Performance Optimization**: Proficient in analyzing and optimizing SQL queries for better performance.
- **Web Service Integration**: Familiar with using PL/SQL to interact with RESTful APIs and web services using tools like APEX_WEB_SERVICE.
- **Bulk Data Processing**: Skilled in processing large datasets efficiently using BULK COLLECT, FORALL, and optimizing commit strategies.
- **Tools**: Experience using Oracle SQL Developer, TOAD, and version control systems like Git.
### Professional Experience:
- Developed and optimized PL/SQL packages, procedures, and triggers to automate and streamline business processes.
- Integrated external RESTful web services into Oracle database using APEX_WEB_SERVICE for seamless data exchange.
- Performed database performance tuning by optimizing SQL queries and database structures to improve efficiency.
- Designed and implemented batch processing using BULK COLLECT and FORALL for high-performance data handling.
- Collaborated with business analysts and stakeholders to gather requirements and deliver high-quality solutions.
### Education:
**Bachelor’s Degree in Computer Science/Information Technology**
### Contact:
**Email**: jmdeleon190189@gmail.com
**Phone**:More...