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.
Qualifications:
- Overall Experience: 5+ years of experience working as an Oracle Developer, with a strong focus on PL/SQL.
- 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, database performance tuning, and normalization.
- Strong Expertise in logical and physical data models, maintenance of DDLs.
- Experience with Oracle tools such as SQL*Plus, SQL Developer, and TOAD.
Additional Skills
- 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 is a plus
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.
Education:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Oracle Database Administrator (DBA) certification (e.g., Oracle Certified Professional) is preferred.
------------------------------------------------------
Job Family Group:
Technology
------------------------------------------------------
Job Family:
Applications Development
------------------------------------------------------
Time Type:
Full time
------------------------------------------------------
Primary Location:
Irving Texas United States
------------------------------------------------------
Primary Location Full Time Salary Range:
$107,120.00 - $160,680.00
In addition to salary, Citi’s offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.
------------------------------------------------------
Anticipated Posting Close Date:
Nov 11, 2024
------------------------------------------------------
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 review Accessibility at Citi.
View the "EEO is the Law" poster. View the EEO is the Law Supplement.
View the EEO Policy Statement.
View the Pay Transparency Posting
Top Skills
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.