Senior Oracle PL/SQL Developer – Capital Markets & Tuning

Tata Consultancy Services; Charlotte (NC); On-site; USD 110,000 - 125,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Parental Leaves

Auto & Home Insurance

Commuter Benefits

Certification & Training Reimbursement

Vacation & Holidays

401K Plan

Job summary

Tata Consultancy Services in the United States is seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize complex database solutions for enterprise applications. You will work with cross-functional teams to translate business requirements into efficient SQL and PL/SQL code, while maintaining data models and ETL processes.

The role requires strong knowledge of Oracle databases, performance tuning, and data modeling tools, with a BFSI domain background highly desirable.

Qualifications

• BA/BS degree in IT, CS, Finance, or related discipline.
• Strong Oracle SQL/PLSQL development and performance tuning knowledge.
• Experience with data modeling tools and ETL concepts.

Responsibilities

• Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, views, and database objects.
• Analyze requirements and translate into scalable database solutions.
• Develop and optimize SQL queries and batch processes for high-performance applications.
• Maintain logical and physical data models using ERWIN/TOAD Data Modeler.
• Develop data migration and ETL processes using SQL*Loader.
• Mentor junior developers and participate in Agile ceremonies.
• Provide L2/L3 production support and handle incidents.

Skills

Oracle PL/SQL Development

Oracle Database

Advanced SQL Programming

Stored Procedures

Functions

Packages & Triggers

Query Performance Tuning

Explain Plan

SQL Hints

Data Modeling

UNIX Shell Scripting

Education

BA or BS degree in Information Technology, Computer Science, Finance, or a related discipline

Tools

ERWIN Data Modeler

TOAD Data Modeler

SQL Navigator

PL/SQL Developer

TOAD

SQL*Loader

Job description

Tata Consultancy Services in the United States is seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize complex database solutions for enterprise applications. You will work with cross-functional teams to translate business requirements into efficient SQL and PL/SQL code, while maintaining data models and ETL processes.

The role requires strong knowledge of Oracle databases, performance tuning, and data modeling tools, with a BFSI domain background highly desirable.