Oracle and PL/SQL Expert Developer

Posted 9 Days Ago
Be an Early Applicant
Irving, TX
107K-161K Annually
Senior level
Fintech
The Role
The Oracle and PL/SQL Expert Developer will design, develop, and optimize database solutions using Oracle and PL/SQL. Responsibilities include writing stored procedures, performance tuning, data modeling, maintaining database security, conducting code reviews, and integrating databases with other systems. Collaboration with cross-functional teams is essential to ensure robust data flow and meet business needs.
Summary Generated by Built In

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

Oracle
Pl/Sql
SQL
The Company
HQ: New York, NY
223,850 Employees
Hybrid Workplace

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.

Similar Jobs

CertifID Logo CertifID

Software Engineer

Real Estate • Security • Software • Cybersecurity • PropTech
Easy Apply
Hybrid
Austin, TX, USA
87 Employees

CertifID Logo CertifID

Associate Software Engineer

Real Estate • Security • Software • Cybersecurity • PropTech
Easy Apply
Hybrid
Austin, TX, USA
87 Employees

CertifID Logo CertifID

Software Engineering Manager

Real Estate • Security • Software • Cybersecurity • PropTech
Easy Apply
Hybrid
Austin, TX, USA
87 Employees

CertifID Logo CertifID

Software Engineer, Data

Real Estate • Security • Software • Cybersecurity • PropTech
Easy Apply
Hybrid
Austin, TX, USA
87 Employees

Similar Companies Hiring

MyBambu Thumbnail
Social Impact • Payments • Other • Mobile • Fintech • Financial Services • App development
West Palm Beach, Florida
120 Employees
Bectran, Inc Thumbnail
Software • Machine Learning • Information Technology • Fintech • Automation • Artificial Intelligence
Schaumburg, IL
51 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account