Sql developer

Key Responsibilities:

Develop, enhance, and maintain Oracle SQL queries, PL/SQL procedures, functions, packages, and triggers. Should have knowledge in python scripting Work on L3 Development with real-time problem-solving including debugging, performance tuning, and root cause analysis. Optimize SQL queries for large datasets (millions of rows) to improve application performance. Implement bulk processing using BULK COLLECT, FORALL, and collections to handle high volumes of data. Work with cursors, ref cursors, dynamic SQL for complex requirement handling. Design and maintain database objects (tables, views, indexes, constraints, partitions). Collaborate with Dev, QA, and Business teams for requirement gathering, triaging, and defect resolution. Implement error handling, exception handling, logging, and debugging strategies. Support data migration, transformation, and integration workflows. Work with tools like GIT, JIRA, Jenkins, Auto Sys (or equivalent) for version control and deployment. Exposure to Agile/Scrum methodologies.

Required Skills & Experience:

3–8 years of experience in Oracle SQL and PL/SQL development. Strong knowledge of SQL optimization techniques (indexes, hints, explain plan, statistics). Hands-on with PL/SQL programming constructs (procedures, packages, functions, triggers, cursors). Experience with performance tuning, debugging, and production incident support. Strong knowledge of SDLC & Agile practices. Experience working with large datasets in OLTP / OLAP environments. Good understanding of database design & normalization. Strong problem-solving and analytical skills. Exposure to XML, JSON handling in Oracle will be an added advantage. Good communication skills for interaction with cross-functional teams.

Nice to Have Skills:

Knowledge of Oracle Advanced Features (Materialized Views, Partitioning, Parallel Query). Hands-on with Oracle XML DB / JSON functions. Exposure to AWS RDS / Cloud Databases. Experience using unit testing frameworks (ut PLSQL).