Senior Oracle PL/SQL Engineer | Data Modeling & ETL

Tata Consultancy Services Limited; Addison (TX); Sur place; USD 120 000 - 125 000; Plein temps

Avantages offerts par ce poste

Discretionary Annual Incentive

Comprehensive Medical Coverage: Health

Dental & Vision Coverage

Disability Planning & Insurance

Retirement & 401K Plan

Commuter Benefits

Certification & Training Reimbursement

Vacation & Holidays

Résumé du poste

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.

Responsabilités

• 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.

Connaissances

Oracle SQL

PL-SQL

Relational database modeling

Unix shell scripting

AI-Assisted Development

Formation

BACHELOR OF COMPUTER SCIENCE

Outils

ETL

Java

Python

Description du poste

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