PL/SQL Developer

Professional SummaryThis 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 AreasOracle SQL and PL/SQL programmingCreation and maintenance of stored procedures, functions, packages, and triggersQuery optimization using AWR, execution plans, and indexing strategiesDatabase modelling and schema designETL workflows and data migration activitiesHigh-volume processing with FORALL and BULK COLLECTUnix/Linux shell scriptingSource control using Git or SVNExperience SnapshotBuilt 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 OutcomesEnhanced query efficiency through indexing improvements and query rewrites.Delivered successful large-scale data migration assignments.Automated repetitive database tasks with PL/SQL scripts.EducationA bachelor’s degree in Computer Science, Information Technology, or Engineering is expected.Additional InformationStrong 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.