Oracle PL/SQL Developer

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

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.

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

Qualifications

BACHELOR OF COMPUTER SCIENCE