Oracle PL SQL Developer

Job Role

Oracle PL SQL Developer

Job Location:

Tampa, FL

Actual compensation within the range will be dependent upon the individual's skills, experience, performance and internal equity.

• Strong understanding between OLTP and batch processing using SQL and PL/SQL.
• Design and maintain different types of Oracle table indexes, including primary keys.
• Partition Oracle tables and fetch JSON data using PIVOT, handling an unknown number of columns and applying row locks with SELECT.
• Write clear SQL joins, use PL/SQL collections, deterministic functions, and .
• Capture which program is invoking a PL/SQL procedure or function package.
• Parse Oracle SQL, distinguish between SQL engine and PL/SQL engine, use PL/SQL cursors, ToDate, ToTimestamp, and rename table columns.
• Analyze SQL execution plans and inline functions to optimize performance.
• Implement user‑defined referential constraint checks using PL/SQL.
• Compare data between two identical tables, identify columns with unmatched values, and use the fastest method to store and retrieve JSON data from CLOB columns.
• Apply Execute Immediate and handle PL/SQL exceptions, both user‑defined and Oracle provided.
• Pass data from a PL/SQL procedure to Angular, Java or Python, or to SQL operators.
• Evaluate advantages and disadvantages of PL/SQL packages and manage transactions within nested transactions.

• Kerat Industry certification in Oracle Database.

• Comprehensive Medical Plan covering medical, dental, and vision.
• Short‑Term and Long‑Term Disability Coverage.
• 401(k) plan with company match.
• Life Insurance.
• Vacation time, sick leave, paid holidays.
• Paid paternity and maternity leave.

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job‑related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation, such as an annual performance‑based bonus, sales incentive pay, and other forms of variable compensation.

Disclaimer:
The compensation and benefits information provided herein is accurate as of the date of this posting.

LTIMindtree is an equal‑opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family‑care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.