PL/SQL Developer

Professional Summary

This role is suited to a seasoned PL/SQL professional with over 5 years of hands-on experience in Oracle database development. The work centers on building efficient database-driven solutions, improving SQL performance, and supporting large-scale enterprise data environments.

Core Technical Areas

• Oracle SQL and PL/SQL programming
• Creation and maintenance of stored procedures, functions, packages, and triggers
• Query optimization using AWR, execution plans, and indexing strategies
• Database modelling and schema design
• ETL workflows and data migration activities
• High-volume processing with FORALL and BULK COLLECT
• Unix/Linux shell scripting
• Source control using Git or SVN

Experience Snapshot

• Built and maintained PL/SQL components such as procedures, functions, and packages for enterprise applications.
• Improved database performance by tuning complex SQL statements and shortening execution times.
• Handled large data-processing workloads and ETL tasks across production systems.
• Investigated and fixed live production issues with structured troubleshooting methods.
• Worked closely with developers, QA teams, and business analysts to deliver reliable database solutions.
• Reviewed code and followed established best practices for database development.

Key Outcomes

• Enhanced query efficiency through indexing improvements and query rewrites.
• Delivered successful large-scale data migration assignments.
• Automated repetitive database tasks with PL/SQL scripts.

Education

A bachelor’s degree in Computer Science, Information Technology, or Engineering is expected.

Additional Information

• Strong analytical thinking and problem-solving ability are important.
• Clear communication and teamwork skills are required.
• The role also involves supporting or mentoring junior developers when needed.