Overview
Oracle, PLSQL, SQL, Agile
Responsibilities
- Understand and convert business requirements into technical solutions.
- Write, optimize, and maintain PL / SQL code and SQL queries.
- Develop data extraction programs with quality and minimal turnaround time for large-volume databases.
- Design and implement database components such as packages, procedures, external tables, functions, and triggers; perform performance optimization.
- Develop batch processing programs, DB jobs, and generate reports from flat files and Excel files using PL / SQL.
- Perform performance tuning and develop high-performance queries / programs.
Qualifications
Minimum 8 years of experience in SQL and PL / SQL programming with Advanced SQL concepts.Good knowledge in Oracle 12c / 19c.Very good and fast PL / SQL programmer.Must be able to quickly understand and convert business requirements into technical solutions.Hands-on experience with building database objects : packages, procedures, external tables, functions, triggers, etc., and performance optimization.Experience in handling large-volume databases and developing data extraction programs with quality and minimal turnaround time.Experience in writing batch processing programs, DB jobs, and generating reports using PL / SQL (flat file & Excel).Good knowledge of performance tuning and writing high-performance queries / programs.Nise to have : ADO, SSRS.#J-18808-Ljbffr