Principal Oracle PL/SQL Developer

Compunnel, Inc.; Westlake (OH); On-site; USD 100,000 - 130,000; Full time

Job summary

A technology solutions company in Westlake is seeking a Principal Oracle PL/SQL Developer to design and maintain ETL processes for Oracle databases while ensuring operational stability of cloud-based services. The ideal candidate should have 8+ years of experience, a Bachelor’s degree, and expertise in Oracle PL/SQL development. Strong problem-solving skills and effective communication are essential for this role.

Qualifications

• 8+ years of technology experience, preferably in the financial industry.
• Expertise in RDBMS concepts and performance optimization.
• Proficiency in writing SQL code including stored procedures and triggers.

Responsibilities

• Design and maintain ETL processes for Oracle databases.
• Optimize SQL and PL/SQL code performance.
• Collaborate with teams to deliver high-quality software solutions.

Skills

Oracle PL/SQL development

Cloud-based systems

SQL optimization

Data analysis

Problem-solving

Effective communication

Education

Bachelor’s degree in Computer Science or related field

Tools

Amazon RDS

Job description

We are seeking a Principal Oracle PL/SQL Developer to join our team and help build and maintain high-quality products and solutions.

This role involves hands-on software engineering experience with cloud-based systems using modern, scalable, and resilient architectures (Containers and Serverless).

The ideal candidate will ensure operational stability of services within the cloud and develop secure, scalable solutions while navigating technical complexities.

Key Responsibilities:

• Design, develop, and maintain ETL or other data pipeline processes to integrate data from various sources into Oracle databases.
• Write and optimize SQL and PL/SQL code, including stored procedures, triggers, functions, views, and complex queries.
• Perform database services such as SQL code review, performance analysis, query tuning, and application database design.
• Collaborate with cross-functional teams to define, design, and deliver high-quality software solutions.
• Analyze data and user requirements to design effective solutions.
• Ensure data integrity and compliance with security standards.
• Monitor and maintain operational stability of cloud-based services.

Required Qualifications:

• Bachelor’s degree (or higher) in Computer Science, Information Systems, or related field.
• Minimum 8+ years of technology experience; financial industry experience is a plus.
• Expertise in Oracle PL/SQL development and RDBMS concepts.
• Strong experience with physical data modeling and performance optimization techniques.
• Proficiency in writing database code (stored procedures, triggers, views) to support application logic.
• Knowledge of cloud database services such as Amazon RDS.
• Experience with analyzing data and designing effective solutions.
• Strong problem-solving skills and ability to explore new technologies/tools.
• Excellent communication skills for conveying technical concepts effectively.