Oracle Pl/sql Developer

Tata Consultancy Services; Addison (TX); On-site; USD 120,000 - 125,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage: Health

Dental & Vision Coverage

Disability Planning & Insurance

Retirement & 401K Plan

Commuter Benefits

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services Limited in Addison, TX seeks an experienced Engineer in Technology to design, develop, and maintain Oracle database objects and associated SQL/PL-SQL code. The role focuses on data modeling, performance tuning, deployment scripting, and collaboration with application teams, DBAs, and QA to ensure data integrity and scalable solutions for financial services workflows.

10+ years of hands-on experience and strong knowledge of Unix shell scripting, ETL processes, and modern

Qualifications

• Bachelor's degree in Computer Science or equivalent required.
• 10+ years of relevant experience in financial services database systems.
• Expert level Oracle SQL/PL-SQL and data modeling.
• Experience with Unix shell scripting and AI-assisted development is a plus.

Responsibilities

• Design, develop, and maintain Oracle database objects - tables, views, indexes, constraints, synonyms, and sequences - following naming and design standards.
• Write, optimize, and tune SQL queries and PL/SQL code (stored procedures, functions, packages, triggers) for performance and reliability.
• Analyze business/functional requirements and translate them into robust database designs and data models.
• Develop and maintain deployment, migration, and rollback scripts, supporting releases across DEV, QA, and PROD environments.
• Perform data analysis, debugging, and troubleshooting of database issues, ensuring data integrity, security, and quality.
• Collaborate with application teams, DBAs, and QA, and participate in code reviews, documentation, and production support.

Skills

Oracle SQL

PL-SQL

Relational database modeling

Unix shell scripting

AI-Assisted Development

Education

BACHELOR OF COMPUTER SCIENCE

Tools

ETL

Java

Python

Job description

Must Have Technical/Functional Skills

Primary Skill: Oracle SQL / PL-SQL( Expert Level) , Relational database modeling, Unix shell Scripting, Financial services / banking tax operations, AI-Assisted Development Skills

Secondary: ETL, Java/Python

Experience: 10+ years

Roles & Responsibilities

• Design, develop, and maintain Oracle database objects - tables, views, indexes, constraints, synonyms, and sequences - following naming and design standards.
• Write, optimize, and tune SQL queries and PL/SQL code (stored procedures, functions, packages, triggers) for performance and reliability.
• Analyze business/functional requirements and translate them into robust database designs and data models.
• Develop and maintain deployment, migration, and rollback scripts, supporting releases across DEV, QA, and PROD environments.
• Perform data analysis, debugging, and troubleshooting of database issues, ensuring data integrity, security, and quality.
• Collaborate with application teams, DBAs, and QA, and participate in code reviews, documentation, and production support.

TCS Employee Benefits Summary:

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Location

Addison, TX

Function

TECHNOLOGY

Role

Engineer

ID

433411

Skills

Oracle | PL/SQL | SQL

Salary Range

$120,000 - $125,000

Salary Range: $120,000 - $125,000 a year

Desired Candidate Profile

Qualifications

• BACHELOR OF COMPUTER SCIENCE