Senior Oracle PL/SQL Developer — Data Modeling & Tuning

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

Benefits offered by this job

Medical Coverage

401K Plan

Bonuses

Certification & Training Reimbursement

Paid Time Off

Job summary

Tata Consultancy Services in Addison, TX seeks a senior Oracle SQL/PL-SQL specialist with 10+ years of database design and development experience. You will design and optimize Oracle objects, implement robust data models, and support deployments across DEV/QA/PROD while collaborating with cross-functional teams.

The role requires strong SQL tuning, ETL familiarity, and a background in financial services/tax operations. On-site work with competitive compensation and comprehensive benefits.

Qualifications

• 10+ years of experience in database design and development.
• Expert level Oracle SQL/PL-SQL.
• Experience with financial services/banking tax operations.
• Unix shell scripting and ETL experience.

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 DB Modeling

Unix Shell Scripting

AI-Assisted Development

ETL

Java

Python

Education

Bachelor of Computer Science

Job description

Tata Consultancy Services in Addison, TX seeks a senior Oracle SQL/PL-SQL specialist with 10+ years of database design and development experience. You will design and optimize Oracle objects, implement robust data models, and support deployments across DEV/QA/PROD while collaborating with cross-functional teams.

The role requires strong SQL tuning, ETL familiarity, and a background in financial services/tax operations. On-site work with competitive compensation and comprehensive benefits.