Senior PL/SQL Developer

Summary: The Senior PL/SQL Developer role involves developing, testing, and maintaining PL/SQL components while optimizing SQL queries for large-scale data processing. The position requires collaboration with cross-functional teams to integrate database components and support production systems. Additionally, the developer will participate in code reviews and mentor junior developers. Strong expertise in Oracle PL/SQL and database performance tuning is essential for success in this role.

Key Responsibilities:

• Develop, test, and maintain PL/SQL procedures, packages, triggers, functions, and views.
• Write and optimize complex SQL queries for large-scale data processing.
• Analyze business requirements and translate them into technical specifications.
• Perform database performance tuning, query optimization, and troubleshooting.
• Work with cross-functional teams to integrate PL/SQL components with applications.
• Support production systems, monitor jobs, and resolve performance or data issues.
• Create and maintain technical documentation including design specs and code reviews.
• Develop ETL processes and automate workflows where required.
• Participate in code reviews, provide technical guidance, and mentor junior developers.

Key Skills:

• Strong hands-on experience with Oracle PL/SQL, SQL, and relational database design.
• Expertise in performance tuning, query optimization, and debugging.
• Solid experience in packages, procedures, triggers, indexes, cursors, collections, etc.
• Knowledge of Oracle tools like SQL*Loader, SQL Developer, TOAD, etc.
• Experience with ETL processes, data migration, and batch job scheduling.
• Familiarity with UNIX/Linux scripting is a plus.
• Ability to work in Agile/Scrum environments.
• Strong analytical, problem-solving, and communication skills.

Salary (Rate): £45

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT