At a Glance
- Tasks: Lead the design and development of complex Oracle database solutions.
- Company: Join Gigged AI, a dynamic open talent marketplace in tech.
- Benefits: Competitive day rate, hybrid work model, and opportunity for growth.
- Other info: Mentor junior developers and shape the future of database solutions.
- Why this job: Make an impact by driving innovative database projects in a collaborative environment.
- Qualifications: 7-10 years as an Oracle Developer with strong PL/SQL skills.
The predicted salary is between 60000 - 72000 £ per year.
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.
Remote Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow) in Chelmsford employer: Gigged.AI
At Gigged AI, we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters innovation and collaboration. Our Glasgow location provides a vibrant environment for Technical Project Managers to thrive, with ample opportunities for professional growth and development in the fast-paced IT sector. Join us to lead impactful projects while enjoying the flexibility of remote work and a supportive team dedicated to your success.
StudySmarter Expert Advice🤫
We think this is how you could land Remote Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow) in Chelmsford
✨Get Involved in Open-Source Projects
Diving into open-source projects is a brilliant way to showcase your skills and connect with other developers in the community. Not only will you beef up your GitHub profile but you might also catch the eye of someone at Gigged.AI who values hands-on experience over just theory.
✨Attend Local Tech Meetups
Tech meetups are gold mines for networking and discovering job opportunities, especially in the fast-paced world of software engineering. Check out local listings for events in your area and don’t shy away from introducing yourself. This could lead directly to a temporary position at Gigged.AI!
✨Showcase Your Work Online
With temporary roles, it’s all about standing out in a short space of time. Create a portfolio website where you highlight your projects and skills. Talk about your code, and provide links to your GitHub repositories. This will not only demonstrate your abilities but will also make it easier for recruiters at Gigged.AI to see what you bring to the table.
✨Leverage Temporary Job Boards
Don’t forget to check specialised job boards for temporary software development roles. Websites like We Work Remotely or Remote OK often list short-term gigs that can be a perfect fit. Apply directly through our website as well, making sure your application is sharp—temporary roles can move fast!
We think you need these skills to ace Remote Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow) in Chelmsford
Some tips for your application 🫡
Show Off Your Tech Skills:Make sure your CV highlights your tech stack and any programming languages you’re proficient in. Include specifics about any frameworks or technologies you’ve worked with; they can make you stand out in the sea of applicants. It’s all about showing that you have the chops we need at Gigged.AI!
Portfolio 2.0:Since you’re applying for a temporary gig, it’s super important to showcase a portfolio that highlights your best projects. Include links to GitHub or any personal projects that demonstrate what you can do in a real-world environment. This gives us a taste of your style and your problem-solving approach!
Keep It Brief and Relevant:With a temporary position, we want to see your ability to hit the ground running. Be concise in your CV and cover letter; stick to experiences that directly relate to the role. Highlight any previous temporary roles or freelance gigs that show your adaptability and quick learning!
Tailor Your Cover Letter:Don’t just send a generic cover letter. Personalise it for Remote Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow) at Gigged.AI! Mention why this temporary role excites you and how you see yourself contributing in the short run. Show us what you've got and why you're the one for this quick turn-around!
How to prepare for a job interview at Gigged.AI
✨Nail the Technical Skills
For a software engineering role, you'll likely face technical questions or coding tasks during your interview. Brush up on the relevant programming languages and frameworks that Gigged.AI uses, and don’t forget to practice some coding challenges on platforms like LeetCode or HackerRank. Showing your coding prowess can really make you stand out!
✨Prepare for System Design Questions
Even for a temporary role, having a grasp of system design principles can be crucial. Be ready to discuss how you would architect a software solution, including discussing trade-offs, scalability, and performance considerations. Having examples from previous projects can really show off your analytical thinking.
✨Demonstrate Your Adaptability
Since this is a temporary role, you'll want to emphasise your ability to hit the ground running. Highlight experiences where you quickly adapted to new technologies or teams. Let’s make it clear to the interviewers at Gigged.AI that you can learn on the job and deliver results in a short timeframe!
✨Show Off Your Portfolio
Make sure to have a portfolio or GitHub ready showcasing your projects. Having tangible evidence of what you've done—be it personal projects, contributions to open-source, or previous work—can convey how capable you are. Tailor this for what might interest Gigged.AI, so it's relevant and sparks conversation during your interview.
