Oracle and PL/SQL Expert Developer

$107,120 - $160,680/Yr

Citigroup - Irving, TX

Full-time - Mid Level

Irving, TX

Credit Intermediation and Related Activities

About the position

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.

Responsibilities

• Design, develop, and maintain Oracle databases using PL/SQL.
• Write complex queries, stored procedures, functions, packages, triggers, and scripts.
• Analyze and optimize queries for maximum performance.
• Identify bottlenecks and provide solutions for slow-performing queries.
• Work closely with data architects and business analysts to design logical and physical data models to meet project requirements.
• Implement and maintain database security policies and procedures to ensure data integrity and availability.
• Conduct code reviews to ensure best practices and standards are followed.
• Work with other developers to integrate Oracle databases with other systems and applications, ensuring smooth data flow.

Requirements

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

Nice-to-haves

• Experience working with Oracle databases in a cloud environment (such as Oracle Cloud, AWS RDS for Oracle, or Azure).
• Experience with Agile/Scrum methodologies and project management tools like Jira.
• Exposure to agile and iterative software delivery.

Benefits

• Medical, dental & vision coverage
• 401(k)
• Life, accident, and disability insurance
• Wellness programs
• Paid time off packages including vacation, sick leave, and paid holidays