[Hiring] Senior PL/SQL Developer @LucyRx

Role Description

We are seeking a highly skilled Senior PL/SQL Developer to join our team. The ideal candidate will have extensive experience with Oracle databases and PL/SQL programming, with a strong focus on database development and cloud migration. You will be responsible for designing, developing, and optimizing PL/SQL solutions while contributing to the migration of Oracle databases to cloud platforms such as Oracle Cloud, AWS RDS, or Azure SQL Database.

• Design, develop, and optimize PL/SQL code for Oracle databases.
• Implement database triggers, stored procedures, functions, packages, and views.
• Perform performance tuning and query optimization to improve database efficiency.
• Assist in the migration of Oracle databases to cloud platforms, ensuring minimal disruption and maximum efficiency.
• Develop and maintain ETL processes to support data integration and reporting.
• Collaborate with cloud architects, DevOps engineers, and business analysts to define migration strategies and best practices.
• Ensure data integrity, security, and compliance with company and industry standards.
• Troubleshoot and resolve database-related issues in both on-premises and cloud environments.
• Develop and maintain documentation for database processes, cloud migration strategies, and coding standards.

Qualifications

• Bachelor's or master's degree in computer science, Information Technology, or a related field.
• 6+ years of experience as a PL/SQL Developer working with Oracle databases.
• Strong proficiency in writing complex SQL queries, stored procedures, functions, and packages.
• Experience with performance tuning, query optimization, and database indexing.
• Familiarity with data modeling, normalization, and database design principles.
• Hands-on experience with database migration to cloud environments (e.g., Oracle Cloud, AWS RDS, Azure SQL Database).
• Knowledge of Oracle tools such as SQL*Loader, Data Pump, and Oracle SQL Developer.
• Understanding of database security, roles, privileges, and access control.
• Excellent problem-solving, analytical, and troubleshooting skills.
• Strong communication and collaboration skills.
• 3+ years experience in the following technologies: .NET; Oracle Forms/Reports, Crystal Reports, or similar reporting tools; JavaScript, HTML, CSS; Web Services; MS Visual Studio, Toad, APEX; XML, JSON.

Requirements

• Experience with Oracle 12c/19c and advanced features.
• Exposure to cloud-based databases and migration tools.
• Familiarity with Agile methodologies and DevOps practices.
• Experience with scripting languages such as Shell, Python, or Perl for automation.
• Knowledge of Oracle APEX for front-end application development.

Benefits

• Oracle certification.
• Experience working with PBM, managed care organizations or integrated delivery networks.

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

• This is a largely sedentary role; however, some standing, walking, bending, and reaching may be required.
• Regularly operates in an office or home office setting which involves utilizing a computer, mouse, keyboard, and occasionally operates other standard office equipment, such as printer, copier, phone.
• Travel may be required by either car or airplane, or a combination of multiple modes of transportation.

Salary

$100,400 - $117,660