Senior Oracle PL/SQL Developer- Assistant Vice President

Single PositionExplore a Career With UsView All JobsHybridSenior Oracle PL/SQL Developer- Assistant Vice PresidentChennai, Tamil Nādu, India No longer accepting applications.Job ID26968335Date posted05/31/2026DepartmentTechnologyA Senior Oracle PL/SQL Developer with 10-12 years of experience is expected to function as a technical expert and a key contributor to application development projects. Their responsibilities go beyond basic coding to encompass design, optimization, and leadership. Technical competencies:- Candidate must have at least 8-10 years of relevant experience in Oracle, PLSQL, Oracle data modeling.- Candidate should conceptual, logical, and physical data models.- Ensure data integrity, stability, and security across databases.- Optimize and tune data models for performance.- Identify each entity's characteristics and properties and ensure that the entities can be differentiated within the model.- Develop a logical data model and validate the model to ensure that it meets the business and functional requirement.- Collaborate with the BI and Analytics teams on creating the optimized, reusable semantic model, complete with metadata and lineage information.- Candidate must be hands-on in plsql procedure, function, packages and trigger.- Candidate must be hands-on in analytical, hierarchical queries, Aggregate Functions – especially usability- Candidate must have hands-on in various type of joins/partition/Index, views, MVs and how to maintain?- Candidate must have hands-on in writing complex Queries like Nested queries, inline views, co-related subqueries etc. Responsibilities:- Development and Support: Develop, test, and debug sophisticated PL/SQL packages, procedures, functions, and triggers to implement complex business logic within the database and support L2/L3 team for production issues.- Mentorship and Guidance: Act as a mentor to other developers, providing technical guidance, sharing knowledge, and fostering a culture of continuous improvement.- Establishing Standards: Define and document database development standards, best practices, and reusable code libraries to improve team productivity and code quality.- Cross-Functional Collaboration: Work closely with frontend and backend developers, business analysts, and project managers to understand requirements and deliver integrated solutions.- Troubleshooting and Support: Act as a subject matter expert for troubleshooting complex production issues related to the database, providing timely resolution and root cause analysis. This site uses only strictly necessary cookies to perform basic functions. You may adjust the settings of your internet browser to reject or block all cookies or trackers, but doing so may affect how the website functions. This website is hosted by an external service provider and all cookies are controlled and configured by Citi. For detailed information please read our Citi Careers Cookie Policy.I have read the cookie notice