Senior Oracle PL/SQL Developer & Functional Consultant
About Candidate
Introduction:
The candidate is an experienced Senior Oracle PL/SQL Developer and Functional Consultant with a strong background in designing, developing, and maintaining integrated management systems across various industries, including banking, finance, energy, automotive, and public administration. They have expertise in analyzing business requirements, gathering user needs, and translating them into functional specifications, UML diagrams, and technical documentation. Skilled in database design, performance optimization, data migration, and ETL processes, they have successfully led projects involving data extraction, transformation, and loading (ETL) from legacy systems to modern databases. The candidate has extensive experience in developing and maintaining enterprise applications, writing complex SQL queries, PL/SQL procedures, functions, triggers, and packages, as well as implementing batch processing and automation scripts. Proficient in Oracle Forms, Reports, and database administration, they have worked closely with cross-functional teams, including developers, testers, and business stakeholders, to ensure seamless application deployment and integration. They have also been actively involved in functional testing, user acceptance testing (UAT), troubleshooting, debugging, and performance tuning. With a strong grasp of Agile and Scrum methodologies, they have contributed to technical training, user support, and documentation, ensuring smooth adoption and operational efficiency of deployed solutions. Their expertise extends to infrastructure, security, and performance requirements, making them a well-rounded professional in database development and functional analysis.
Responsibilities:
- Design, develop, and maintain integrated management systems across multiple industries.
- Analyze business requirements, gather user needs, and translate them into functional specifications and UML diagrams.
- Develop complex SQL queries, PL/SQL procedures, functions, triggers, and packages for data processing.
- Perform data migration and ETL (Extract, Transform, Load) processes, transferring data from legacy systems to modern databases.
- Implement batch processing and automation scripts to enhance system efficiency and reliability.
- Ensure high-performance optimization of database queries and application processes.
- Lead projects involving database design, implementation, and maintenance of enterprise applications.
- Collaborate with cross-functional teams, including developers, testers, and business stakeholders, to integrate and deploy applications.
- Conduct functional testing, user acceptance testing (UAT), and troubleshooting to ensure application quality and user satisfaction.
- Provide technical support, resolve issues, and offer solutions during the deployment phase of applications.
- Create and maintain technical documentation, including system specifications, user manuals, and operational guides.
- Perform system upgrades, including database version updates and patches.
- Conduct training sessions and provide ongoing support to users for system adoption and optimal performance.
- Lead the optimization of database queries for better performance, reducing processing time and enhancing system efficiency.
- Ensure compliance with security, data integrity, and performance standards within the development environment.