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 Grimsby employer: Gigged.AI
At Gigged AI, we pride ourselves on being an exceptional employer that fosters a collaborative and innovative work culture. Our hybrid model allows for flexibility while working in the vibrant Glasgow City Centre, providing employees with opportunities for professional growth and mentorship in a dynamic IT environment. With a focus on meaningful projects and a commitment to employee development, we empower our team to excel and make a significant impact in the technology sector.
StudySmarter Expert Advice🤫
We think this is how you could land Remote Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow) in Grimsby
✨Get Involved in IT Consulting Communities
Join popular online forums and communities specifically for IT consultants, like Spiceworks or TechRepublic. This is a fab way to connect with potential clients and stay updated on industry trends that could lead to freelance gigs.
✨Showcase Your Skills with a Public Portfolio
Create a portfolio website where you showcase your IT consulting projects, case studies, and testimonials from past clients. This not only builds your credibility but also makes it easier for potential clients to see what you can offer.
✨Utilise Freelance Platforms
Don’t shy away from platforms like Upwork or Freelancer. They're great for finding freelance gigs in IT consulting. Just make sure your profile is well-crafted and highlights your skills effectively—first impressions matter!
✨Tap into Your Network
Reach out to your existing connections in the IT sector and let them know you’re available for freelance projects. This could also mean attending local tech meetups or webinars where you can not only learn but find new clients. And remember, if you see a role that looks right, apply through our website at Gigged.AI for the best chance!
We think you need these skills to ace Remote Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow) in Grimsby
Some tips for your application 🫡
Show Off Your Tech Toolbox:Let’s be real: in IT consulting, your skills and tools can make or break the project. Make sure your CV includes a solid list of the technologies you’ve worked with and any specific programming languages you're fluent in. If you’ve got experience with project management tools, like JIRA or Trello, shout about that too! It shows you're not just a tech head, but you can manage the chaos too.
Your Portfolio is Your Best Mate:As a freelancer, your portfolio is your calling card. Make it shine! Include case studies of projects you’ve worked on that highlight your problem-solving skills and the impact of your work. Make sure to detail the challenges faced and how you overcame them—clients love to see tangible results. A well-structured portfolio is your best chance to impress!
Tailor Your Approach:Unlike full-time applications, freelance gigs need that personal touch. Write a cover letter that doesn't just highlight your skills but also your understanding of Gigged.AI and what they’re looking for. Explain how your unique approach can solve their challenges. This kind of personalisation shows you care and sets you apart from the cookie-cutter applications.
Be Clear on Your Rates and Availability:When applying for freelance roles, clarity is key! Include your rates and availability upfront in your application to avoid any confusion later. This honesty will save both you and Gigged.AI time, and it shows you’re serious about doing business. We believe it’s best to be transparent right from the get-go!
How to prepare for a job interview at Gigged.AI
✨Showcase Your Problem-Solving Skills
In IT consulting, they’ll want to see how you tackle real-life client issues. Prepare to discuss specific case studies from your freelance experience where you've demonstrated your problem-solving prowess. Come armed with examples that highlight the strategies you used and the results achieved.
✨Pitch Your Portfolio Like a Pro
As a freelancer, your portfolio is your calling card. Make sure it’s not just a collection of past projects but a narrative of your journey. Be ready to discuss how each project reflects your capability and how you can bring value to Gigged.AI. Tailor this pitch to highlight projects that align closely with what they seek.
✨Brush Up on the Latest Tech Trends
IT consulting is all about staying ahead of the game. Make sure you’re familiar with the latest tools and technologies that are shaping the industry. You might get asked about a specific platform or software, so having fresh knowledge will give you the edge over other candidates.
✨Be Prepared for Hypothetical Scenarios
Expect some hypothetical or situational questions that assess how you'd handle various client scenarios. Practice thinking on your feet and responding to questions about project challenges or client interactions. This shows your adaptability and readiness for the freelance lifestyle, which works differently from traditional employment.
