Oracle PLSQL Programmer

White Force Outsourcing Services; Mumbai; Vor Ort; INR 500.000 - 800.000; Vollzeit

Zusammenfassung

White Force Outsourcing Services in Mumbai, India, is seeking an Oracle PL/SQL developer to join our data team. The role focuses on design, development, documentation and maintenance of database solutions.

You will optimize complex SQL, manage packages, procedures, triggers, and ensure data integrity while collaborating with cross-functional teams. Strong debugging skills and ability to work in a fast-paced environment are essential.

Qualifikationen

• Must have worked on Oracle PL/SQL.
• Experience with packages, procedures, functions, triggers, views, and sequences.
• Skilled in writing and tuning complex SQL queries using explain plan and tkprof.
• Strong debugging, testing, and problem-solving abilities.
• Experience with data migration and database design.

Aufgaben

• Work on Oracle PL/SQL development and maintenance.
• Design and optimize SQL queries and database objects.
• Assist in data migration and data modeling.
• Collaborate with team and stakeholders to ensure data integrity.
• Document technical specifications and code changes.

Kenntnisse

PL/SQL

SQL Tuning

Data Modeling

Debugging

Oracle 19c

Tools

Oracle 19c

Toad

PL/SQL Developer

Jobbeschreibung

Technical Skills:--

• -Job Functions Design, Development, Documentation, Maintenance, Coordination, Support.
• -Languages Oracle PL/SQL, Advanced PL/SQL
• -Platforms Windows, Database, Oracle 19c
• -Advance Tools/Technologies Oracle 19c, Toad, Pl Sql Developer
• -Domain Knowledge Finance, Insurance, Music

Responsibility

• Must have worked on oracle Pl/Sql
• Must have experience in Packages, Procedures, Functions, Triggers, Views, Cursors, PL/SQL Table, Nested Tables, Arrays, Sequences, Indexes, synonyms, file handling, DBMS Scheduler, oracle text, Subqueries, Inline views, Materialized view in oracle database
• Experience in writing and tuning complex and large SQL queries with the help of explain plan, trace files, tkprof.
• Good at debugging and testing code
• Experience in Database Design, Modeling And Normalization.
• Experience with data flow diagrams, data dictionary techniques, Entity relation modeling.
• Sound analytical, problem solving and trouble shooting skills.
• Good spoken and written communication skills.
• Ability to work well in both a team and individual environment.
• Experience in data migration from legacy system to new system.