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) SQLLoader , 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, Oracle Forms & Reports, SQLLoader, 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 o Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, views, and database objects. o Analyze business requirements and translate them into scalable and efficient database solutions. o 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. o Design and maintain logical and physical data models using ERWIN, TOAD Data Modeler, and ER diagrams. o Develop and support data migration, data loading, and ETL processes using SQL*Loader and related tools. o Work closely with application developers, business analysts, architects, and QA teams throughout the SDLC lifecycle. o Troubleshoot production issues, analyze root causes, and implement permanent solutions to ensure system stability. o Support database deployments, release activities, and change management processes across multiple environments. o Develop UNIX/Linux shell scripts to automate database monitoring, maintenance, and batch processing activities. o Create and maintain technical design documents, code reviews, and database development standards. o Work with reporting and analytics tools such as Tableau, Trino, Hue, and Collibra to support business reporting requirements. o Monitor database health, ensure data integrity, and implement backup and recovery best practices. o Mentor junior developers and provide technical guidance on Oracle database development and tuning best practices. o Participate in Agile ceremonies including sprint planning, estimation, backlog refinement, code reviews, and retrospective meetings. o Collaborate with cross-functional teams to deliver secure, scalable, and high-quality database solutions. o Ensure compliance with organizational security, audit, and regulatory requirements, particularly in BFSI environments. o Provide L2/L3 production support and work on critical incidents, problem management, and service improvement initiatives. Responsibilities Include: o Lead Oracle database design and d evelopment activities for enterprise applications. o Review solution architecture and recommend best practices for database design and performance. o Coordinate with onsite/offshore teams and stakeholders to ensure successful project delivery. o Act as the Subject Matter Expert (SME) for Oracle PL/SQL development, performance tuning, and database optimization.

o BA or BS degree in Information Technology, Computer Science, Finance, or a related discipline. o Knowledge and hands-on experience with Capital Markets / Primary Markets deal execution is strongly required (5+ years preferable). o Strong understanding of New Issue, Book Building, and Syndication workflows in Fixed Income and Equities. o Prior experience providing desk-aligned production support in a trading floor or capital markets environment. o Excellent troubleshooting skills; ability to resolve critical production issues quickly under pressure. o Strong communication and relationship-building skills; able to interact confidently with front-office users. o Knowledge of bond fundamentals and capital markets execution processes is mandatory. o Ability to document workflows, create knowledge repositories, and provide effective training. o Highly organized, detail-oriented, with the ability to manage multiple issues and requests simultaneously. o Prior experience with vendor platforms for deal execution (e.g., Ipreo / Primary Portal / Dealogic) is a plus.