Oracle PL/SQL Developer

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

Job Description

Must Have Technical/Functional Skills

Primary Skills: Oracle PL/SQL Development, Oracle Database (8i/9i/10g/11g and above), Advanced SQL Programming, Stored Procedures, Functions, Packages & Triggers, Query Performance Tuning & Optimization Explain Plan, SQL Hints & Index Tuning , Data Modeling (ERWIN, TOAD Data Modeler, ER Diagrams) SQL*Loader , Oracle Forms & Reports, TOAD, PL/SQL Developer & SQL Navigator, UNIX Shell Scripting Database Design, Development & Production Support

Secondary Skills

Secondary Skills: NIX / Linux Administration (RHEL, Solaris, AIX), Shell Scripting (Korn Shell, Bash), Python Programming, SQL Server, Oracle Forms & Reports, SQL*Loader, Tableau Reporting & Dashboard Development, Collibra Data Governance, Trino (Presto) Query Engine, Hue Analytics Platform, Quartz Scheduler, Data Warehousing Concepts, ETL Development & Data Migration, Database Performance Monitoring, Production Support (L2/L3), Version Control Tools (Git, SVN), Agile / Scrum Methodology, JIRA and Defect Tracking Tools , Application Support & Incident Management, BFSI Domain Knowledge

Roles & Responsibilities

• Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, views, and database objects.
• Analyze business requirements and translate them into scalable and efficient database solutions.
• Develop and optimize complex SQL queries, PL/SQL code, and batch processes for high-performance applications. o Perform database performance tuning using Explain Plan, SQL Hints, Indexing strategies, and query optimization techniques.
• Design and maintain logical and physical data models using ERWIN, TOAD Data Modeler, and ER diagrams.
• Develop and support data migration, data loading, and ETL processes using SQL*Loader and related tools.
• Work closely with application developers, business analysts, architects, and QA teams throughout the SDLC lifecycle.
• Troubleshoot production issues, analyze root causes, and implement permanent solutions to ensure system stability.
• Support database deployments, release activities, and change management processes across multiple environments.
• Develop UNIX/Linux shell scripts to automate database monitoring, maintenance, and batch processing activities.
• Create and maintain technical design documents, code reviews, and database development standards.
• Work with reporting and analytics tools such as Tableau, Trino, Hue, and Collibra to support business reporting requirements.
• Monitor database health, ensure data integrity, and implement backup and recovery best practices.
• Mentor junior developers and provide technical guidance on Oracle database development and tuning best practices.
• Participate in Agile ceremonies including sprint planning, estimation, backlog refinement, code reviews, and retrospective meetings.
• Collaborate with cross-functional teams to deliver secure, scalable, and high-quality database solutions.
• Ensure compliance with organizational security, audit, and regulatory requirements, particularly in BFSI environments.
• Provide L2/L3 production support and work on critical incidents, problem management, and service improvement initiatives.

Responsibilities Include

• Lead Oracle database design and d evelopment activities for enterprise applications.
• Review solution architecture and recommend best practices for database design and performance.
• Coordinate with onsite/offshore teams and stakeholders to ensure successful project delivery.
• Act as the Subject Matter Expert (SME) for Oracle PL/SQL development, performance tuning, and database optimization.
• Qualifications:
• BA or BS degree in Information Technology, Computer Science, Finance, or a related discipline.
• Knowledge and hands‑on experience with Capital Markets / Primary Markets deal execution is strongly required (5+ years preferable).
• Strong understanding of New Issue, Book Building, and Syndication workflows in Fixed Income and Equities.
• Prior experience providing desk‑aligned production support in a trading floor or capital markets environment.
• Excellent troubleshooting skills; ability to resolve critical production issues quickly under pressure.
• Strong communication and relationship‑building skills; able to interact confidently with front‑office users.
• Knowledge of bond fundamentals and capital markets execution processes is mandatory.
• Ability to document workflows, create knowledge repositories, and provide effective training.
• Highly organized, detail-oriented, with the ability to manage multiple issues and requests simultaneously.
• Prior experience with vendor platforms for deal execution (e.g., Ipreo / Primary Portal / Dealogic) is a plus.

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: $110,000 - $125,000 a year

Qualifications:

BACHELOR OF COMPUTER SCIENCE