Apply (opens in new window)

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, youll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

A 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.

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Applications Development

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Most Relevant Skills

Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi( opens in new window).

View Citis EEO Policy Statement( opens in new window) and the Know Your Rights( opens in new window) poster.

Apply (opens in new window)