Oracle PL/SQL Developer

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

• NIX / Linux Administration (RHEL, Solaris, AIX)
• Shell Scripting (Korn Shell, Bash)
• Python Programming
• SQL Server
• 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

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.
• 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.
• Create and maintain 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.
• Maintain 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.

Lead Oracle database design and development activities for enterprise applications.

Review solution architecture and recommend best practices for database design and performance.

Cook up 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 (5+ years preferable).
• 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