Experience 3-6 years of hands-on experience in Oracle SQL and PL/SQL development. Solid knowledge of SQL optimization techniques, including indexes, hints, execution plans, and statistics. Hands-on experience with PL/SQL programming constructs such as procedures, packages, functions, triggers, and cursors.
Experience in performance tuning, debugging, and production incident support. Strong understanding of SDLC and Agile practices.
Experience working with large datasets in OLTP/OLAP environments. Good understanding of database design and normalization. Strong problem-solving and analytical skills. Exposure to XML and JSON handling in Oracle is an added advantage.
Good communication and collaboration skills for working with cross-functional teams. Nice-to-Have Skills Knowledge of Oracle advanced features such as Materialized Views, Partitioning, and Parallel Query. Hands-on experience with Oracle XML DB and JSON functions.
Exposure to AWS RDS / Cloud Databases.
Experience with unit testing frameworks such as utPLSQL.
Education Bachelors or Master’s degree in Computer Science, Information Technology, or a related field