Oracle PL/SQL Developer

Mphasis - Lake Mary, FL

Full-time

Lake Mary, FL

Professional, Scientific, and Technical Services

About the position

The Oracle PL/SQL Developer role involves designing, developing, and maintaining Oracle databases with a strong emphasis on PL/SQL programming. The position requires expertise in performance tuning, data modeling, and database security, ensuring optimal database performance and data integrity. The developer will collaborate with data architects and business analysts to create effective data models and integrate databases with other systems.

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, identifying bottlenecks and providing solutions.
• Work closely with data architects and business analysts to design logical and physical data models.
• 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.
• Integrate Oracle databases with other systems and applications, ensuring smooth data flow.

Requirements

• 5+ years of experience 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 and maintenance of DDLs.
• Experience with Oracle tools such as SQL*Plus, SQL Developer, and TOAD.