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

Gigged AI
Aberdeen, UK
about 2 months ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services JIRA Code Review Collaborative Software Database Design Database Development Oracle Databases Oracle (Applications) Oracle Forms Oracle SQL Developer Performance Tuning Systems Development Life Cycle
+8 more
PVCS Version Manager Query Optimization Software Engineering PL-SQL Subversion Database Optimization Git Software Version Control

Job description

  • 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.

Requirements

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., * 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., * 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 Confluenc
  • Domain knowledge in Banking and Financial Services
  • Demonstrated experience mentoring and guiding junior and mid-level developers.

About the company

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on find.jobs

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:05 min

Integrating an assistant application with Jira software

Felix Augenstein · LIVE

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

1:06 min

Developer experience and project variety at scale

Alexandra Petri · WWC 2023

5:47 min

Integrating user stories and test automation via Jira tools

Christoph Ruggenthaler · LIVE

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

4:45 min

Building careers inside distributed technology consulting environments

Oliver Zimmert · LIVE

Videos

See all

Related articles

See all