The Role:
We are seeking an experienced Oracle and PL/SQL Expert Developer to join our team responsible for establishing and implementing new or revised application systems and programs in coordination with the Technology team. The ideal candidate will have a deep understanding of database management systems, Oracle architecture, and PL/SQL programming. This role involves designing, developing, and optimizing database solutions to support business needs, ensuring high performance and data integrity across our platforms. He or she will also be working with Other Oracle/PLSQL developers / DBAs, Angular/Java developers, and Automation engineers in building end-to-end solutions.
Responsibilities
Database Development: Design, develop, and maintain Oracle databases using PL/SQL.
PL/SQL Programming: Write complex queries, stored procedures, functions, packages, triggers, and scripts.
Performance Tuning: Analyze and optimize queries for maximum performance. Identify bottlenecks and provide solutions for slow-performing queries.
Data Modeling: Work closely with data architects and business analysts to design logical and physical data models to meet project requirements.
Database Security: Implement and maintain database security policies and procedures to ensure data integrity and availability.
Code Review: Conduct code reviews to ensure best practices and standards are followed.
System Integration: Work with other developers to integrate Oracle databases with other systems and applications, ensuring smooth data flow.
Troubleshooting & Issue Resolution: Diagnose and resolve database-related issues, including performance bottlenecks, data integrity problems, and other technical challenges.
Documentation: Maintain detailed documentation of database designs, technical specifications, and development processes.
Mentorship: Work in an agile environment following through the best practices of agile Scrum. Provide technical guidance and mentorship to junior developers. Bring agility to application development through DevOps practices - automated builds, unit/functional tests, static/dynamic scans, regression tests etc.
Required Qualifications
Education: Bachelor's degree in Computer Science, Information Technology, or a related field.
Experience: 10+ years of experience working as an Oracle Developer, with a strong focus on PL/SQL.
Technical Skills:Proficiency in Oracle Database (11g, 12c, 19c).
Advanced PL/SQL programming skills, including the creation of stored procedures, functions, packages, and triggers.
Strong knowledge of SQL query optimization and database performance tuning.
Expertise in logical and physical data models, maintenance of DDLs.
Experience with Oracle tools such as SQL*Plus, SQL Developer, and TOAD.
Knowledge of database design principles, data modeling, and normalization.
Soft Skills:Excellent problem-solving skills with a strong attention to detail.
Strong communication skills and the ability to collaborate effectively with cross-functional teams.
Ability to work independently and manage multiple tasks simultaneously.
Strong analytical skills and ability to think critically about data and system interactions.
Preferred Qualifications
Certifications: Oracle Database Administrator (DBA) certification (e.g., Oracle Certified Professional) is preferred.
Experience with Cloud: Experience working with Oracle databases in a cloud environment (such as Oracle Cloud, AWS RDS for Oracle, or Azure) is a plus.
Project Management: Experience with Agile/Scrum methodologies and project management tools like Jira is advantageous. Exposure to agile and iterative software delivery
Education:
Bachelor's degree/University degree or equivalent experience
Master's degree preferred
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
------------------------------------------------------
Job Family Group:
Technology------------------------------------------------------
Job Family:
Applications Development------------------------------------------------------
Time Type:
Full time------------------------------------------------------
Citi is an equal opportunity and affirmative action employer.
Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Citigroup Inc. and its subsidiaries ("Citi") invite all qualified interested applicants to apply for career opportunities. 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 reviewAccessibility at Citi.
View the "EEO is the Law" poster. View theEEO is the Law Supplement.
View theEEO Policy Statement.
View thePay Transparency Posting