About this opportunity
Tata Consultancy Services lists this Oracle PL/SQL Developer opportunity in charlotte, North Carolina. Review the employer’s description below for duties, qualifications and application requirements.
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
#J-18808-Ljbffr
Worksite address
charlotte, NC, 28245, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.