Remote Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow) in Lancaster

Gigged AI is an open talent marketplace specialising in the IT and technology sector. We have an opportunity live at the moment for a Finance Transaction Analyst. This role is hybrid, with 3 days per week in Glasgow City Centre Office.

Location: UK-based

Duration: Initial 6-month contract

Start Date: ASAP

Day Rate: £300

IR35 Status: Outside IR35 (pending final determination)

All applicant proposals will be reviewed directly on the Gigged AI platform by the hiring manager. In order to send a proposal please follow the below steps: head to app.gigged.ai and create a free talent profile. Once signed in, follow this link to the project - you will now see a 'submit proposal' button; please fill this in (intro, relevant experience, and attach CV to this).

Role Overview

We are seeking an experienced Oracle Lead Developer (7-10+ years experience) to spearhead the analysis, design, and development of complex database solutions. In this role, you will collaborate directly with solution architects and business stakeholders, mentor junior developers, and drive the technical direction of Oracle database projects from inception through to deployment.

Key Responsibilities

• Lead the design and analysis of database solutions, working closely with solution architects and business stakeholders to deliver robust, scalable outcomes.
• Create and maintain Technical Design Documents (TDDs), ensuring clarity, accuracy, and adherence to project specifications.
• Develop, review, and optimise complex Oracle PL/SQL code including Procedures, Packages, Functions, and Views.
• Lead database development on Oracle 19C, implementing best practices in database design and query optimisation.
• Conduct thorough code reviews and uphold development standards aligned with industry best practices and project requirements.
• Coordinate with architects, developers, and stakeholders to ensure consistent delivery of high-quality solutions.
• Partner with project managers and business analysts to ensure development aligns with business requirements and timelines.
• Manage the full software development lifecycle (SDLC) independently — from design and development through to testing and deployment.
• Act as the primary technical point of contact for the development team, maintaining open communication channels across all stakeholders.
• Provide technical expertise during project planning sessions and contribute meaningfully to architectural design decisions.

Required Skills & Experience

• 7–10 years of hands-on experience as an Oracle Developer with deep expertise in PL/SQL and Oracle Database 19C.
• Proven track record of leading database development projects end-to-end.
• Strong ability to write, review, and optimise complex PL/SQL code (Procedures, Packages, Functions, Triggers, Views).
• Solid understanding of database design principles, normalisation, indexing strategies, and performance tuning.
• Experience producing Technical Design Documents and working within formal SDLC processes.
• Excellent communication and stakeholder management skills with the ability to bridge technical and business teams.

Desirable Skills

• Experience with Oracle Forms and Reports (D2k) and Oracle HUB.
• Oracle performance tuning, execution plan analysis, and AWS reporting.
• Familiarity with version control systems such as Git, PVCS, or SVN.
• Working knowledge of project management and collaboration tools, including JIRA and Confluence.
• Domain knowledge in Banking and Financial Services.
• Demonstrated experience mentoring and guiding junior and mid-level developers.