Summary: The Oracle Lead role is a contract position focused on leading the analysis, design, and development of database solutions using Oracle Database 19C and PL/SQL. The position requires collaboration with architects and mentoring junior developers while managing the software development life cycle. The role is based in Glasgow, requiring two days of on-site work each week, and is classified as inside IR35.

Key Responsibilities:

• Lead the design and analysis of database solutions by working closely with solution architects and business stakeholders.
• Create and maintain Technical Design Documents (TDDs), ensuring clarity and adherence to project specifications.
• Develop, review, and optimize complex Oracle PL/SQL code including Procedures, Packages, Functions, and Views.
• Lead the database development on Oracle 19C, implementing best practices in database design and optimization.
• Mentor and guide junior and mid-level developers through the development process, offering technical support and expertise.
• Lead code reviews and ensure that development practices follow industry standards and project requirements.
• Coordinate with architects, developers, and other stakeholders to ensure consistent delivery of high-quality solutions.
• Work closely with project managers and business analysts to ensure the development aligns with business requirements and timelines.
• Manage the entire software development life cycle (SDLC) independently, from design and development to testing and deployment.
• Act as the main point of contact for the development team, ensuring open communication channels with all stakeholders.
• Provide technical expertise during project planning sessions and collaborate on design decisions.

Key Skills:

• Strong experience in PL/SQL and Oracle Database 19C.
• Ability to lead database design and development efforts.
• Experience in creating and maintaining Technical Design Documents (TDDs).
• Proficient in developing and optimizing complex Oracle PL/SQL code.
• Mentoring and guiding junior developers.
• Strong communication and collaboration skills with stakeholders.
• Experience managing the software development life cycle (SDLC).
• Technical expertise in database design and optimization best practices.

Salary (Rate): undetermined

City: Glasgow

Country: UK

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT