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 in the IT and technology sector, offering a dynamic work culture that fosters innovation and collaboration. Our hybrid working model allows for flexibility while our Glasgow City Centre office provides a vibrant environment for professional growth and networking. With opportunities for mentorship and involvement in cutting-edge projects, we empower our employees to thrive and make meaningful contributions to the tech landscape.
StudySmarter Expert Advice🤫
We think this is how you could land Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow)
✨Show off Your Skills with a Public Portfolio
Take the time to create a public portfolio that showcases your database management projects. Include case studies, problem-solving examples, and even any open-source contributions you’ve made. This is your chance to shine and demonstrate your expertise to potential clients!
✨Join Freelance Communities
Get involved in freelance platforms and community groups specific to database management, like Stack Overflow or GitHub discussions. Not only can you find opportunities, but you can also network with others in the field who might have leads or recommendations.
✨Use Social Media Wisely
Utilise platforms like LinkedIn or Twitter to share insights about database management trends, tips, or your personal achievements. Regularly posting updates can increase your visibility and attract potential clients looking for someone with your expertise.
✨Target Clients in Specific Industries
Think about industries that rely heavily on database management, like e-commerce or finance. Tailor your outreach to these sectors by showcasing how your skills can solve their specific challenges. This focused approach can help you land projects more effectively!
We think you need these skills to ace Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow)
Some tips for your application 🫡
Showcase Your Projects:When you're applying for a freelance role like Lead Oracle Developer - Outside IR35 - Hybrid (Glasgow) in database management, we really want to see your practical experience. Share links to any relevant projects you've worked on, be it through GitHub or your own website. This gives us a real sense of your skills and approach to problem-solving.
Highlight Relevant Skills:Tailor your CV to spotlight your expertise in database languages and tools like SQL, MongoDB, or data visualisation software. Don't forget to include any certifications or courses you've completed that underscore your proficiency—this is key for standing out in database management!
Be Transparent About Your Availability:As a freelancer, it's super important to be upfront about your availability. In your application, mention how many hours you can commit each week and if you're open to different time zones. This helps us understand if you're a good fit for our schedule at Gigged.AI.
Include Your Rates:To avoid any confusion later on, be sure to include your rates in your application. Whether you're charging hourly or per project, this transparency will help us evaluate your fit for our budget right from the start—it's all about making things easier for both parties.
How to prepare for a job interview at Gigged.AI
✨Showcase Your Database Wizardry
As a freelance database manager, it's really important to have a strong portfolio that demonstrates your previous projects. Bring detailed case studies to the interview, showcasing how you optimised databases for clients, solved specific problems, and what tools you used like SQL, MongoDB or Oracle. This not only proves your skills but also gives potential clients a real idea of what they can expect from you.
✨Brush Up on Your Troubleshooting Skills
Expect to face some tough technical questions during your interview, especially around troubleshooting database issues. Be prepared to talk through scenarios where you successfully resolved data integrity issues or performance bottlenecks. Showing your thought process in these situations can really impress potential clients, as it highlights your problem-solving abilities.
✨Know Your Worth and Be Ready to Pitch
Freelancing often comes down to negotiation, so have a clear understanding of your rates and be ready to explain the value you bring. Be prepared to justify your pricing based on your expertise and the positive outcomes from your past projects. This confidence can make a big difference in securing both the job and a fair fee.
✨Stay Up-to-Date with Trends
The database-management field is constantly evolving, so being up-to-date with the latest trends and technologies (like cloud-based solutions or data security practices) will give you an edge. Mention any recent upgrades or certifications you’ve completed, as this shows your commitment to staying ahead in this fast-paced industry and makes you a more attractive candidate for Gigged.AI.
