At a Glance
- Tasks: Lead the design and development of complex Oracle database solutions in a hybrid role.
- Company: Join Gigged AI, an innovative open talent marketplace in the tech sector.
- Benefits: Competitive day rate, flexible hybrid work, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on innovation and career advancement.
- Why this job: Make a real impact by leading exciting database projects and mentoring future developers.
- Qualifications: 7-10 years of Oracle development experience with strong PL/SQL skills required.
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 Lead Oracle Developer. 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)
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.
Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow) 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 Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow)
✨Tap into Local Tech Meetups
Get yourself to local tech meetups or database management conferences. It's a really great way to meet industry professionals and potentially uncover unadvertised full-time roles. When chatting with people, mention your skills and interests in database management; you never know who might be looking for someone just like you!
✨Contribute to Open Source Projects
Diving into open-source projects can not only sharpen your database skills but also get you noticed by employers. Many companies look for candidates who actively contribute to projects – it shows initiative and a real passion for the field. Plus, it's a perfect excuse to connect with other developers and expand your professional network.
✨Utilise Professional Bodies
Sign up for professional bodies related to database management, like the British Computer Society. They often host events and networking opportunities that can lead directly to job openings in the full-time market. Plus, it adds a nice touch to your professional profile!
✨Showcase Your Skills in a Public Portfolio
As you’re on the hunt for that full-time role, make sure to have a public portfolio that displays your best database projects. This can easily set you apart from the competition. And when you apply for roles, definitely mention it – it shows employers you mean business and are proud of your work!
We think you need these skills to ace Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow)
Some tips for your application 🫡
Show off your database skills:When applying for a full-time role in database management, it’s super important to highlight your skills with specific database technologies like SQL, NoSQL, or any relevant data visualisation tools. We want to see how you've used these tools in real projects, so don't shy away from detailing your hands-on experience!
Tailor your CV for data:Make sure your CV is structured clearly, focusing on your previous experience in database management. Use specific metrics to demonstrate your impact, like how you improved data retrieval times or reduced errors. This isn't just about what you've done; it’s about what you’ve achieved with your skills!
Craft a compelling cover letter:In your cover letter, share what excites you about database management and how you can contribute to Gigged.AI. Mention any relevant projects where you tackled challenges or implemented new solutions. Let us know why you want to join our team and how your passion aligns with our goals.
Document your projects:If you've worked on interesting database projects—maybe during your studies or in previous roles—be sure to include those in your application. If you can, link to a portfolio or GitHub repo where we can see examples of your work. Having a tangible showcase of your skills will really make your application stand out!
How to prepare for a job interview at Gigged.AI
✨Brush Up on Database Tools
Make sure you're well-versed with popular database management systems like MySQL, PostgreSQL, or MongoDB. Incorporating real-world examples of how you've used these tools in past projects will show that you can put theory into practice, which is something Gigged.AI will definitely appreciate.
✨Know Your SQL Inside Out
Get ready for some technical questions focused on SQL queries and database design. We should anticipate coding challenges where you might need to optimise queries or design a database schema on the spot. Practising these problems will build our confidence to impress in the interview.
✨Demonstrate Problem-Solving Skills
Besides just technical know-how, be prepared to answer scenario-based questions that test your critical thinking and problem-solving abilities. Think about how you would approach data integrity issues or handle performance bottlenecks — Gigged.AI will want to see your analytical side!
✨Show Your Collaboration Spirit
Since this is a full-time role, it's crucial to highlight how you've collaborated with cross-functional teams or contributed to team projects in the past. Emphasising our interpersonal skills will demonstrate that you’re not just a tech wizard, but also a team player who fits well with Gigged.AI's culture.