Summary:
We are looking for a fast, hands-on PL/SQL developer with strong Oracle and SQL skills to design, develop, and optimize database programs. The person will convert business requirements into technical solutions, build packages, procedures, functions and triggers, and develop data extraction programs for large-volume databases with minimal turnaround time. The role also involves batch processing, database jobs, and generating flat file and Excel reports using PL/SQL, along with performance tuning of queries and programs. Working knowledge is required, and
Must-have skills
Advanced SQL and PL/SQL programming (5 to 8 years)
Oracle 12c / 19c
Writing packages, procedures, functions, triggers and external tables
Performance tuning and writing high-performance queries and programs
Handling large-volume databases and building data extraction programs
Batch processing programs and database jobs
Flat file and Excel report generation using PL/SQL
Ability to quickly understand business requirements and convert them into technical solutions
Good to have