Oracle Lead

Axiom Software Solutions Limited; Glasgow; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading software company in Glasgow is seeking a Lead Oracle Developer to drive analysis and development on Oracle Database 19C. The successful candidate will lead design efforts, mentor junior developers, and ensure high-quality deliverables. Strong PL/SQL skills and experience in database optimization are essential. This position offers the opportunity to manage the full software development lifecycle in a collaborative environment.

Qualifications

• Strong experience in PL/SQL and Oracle Database 19C.
• Ability to lead design and analysis of database solutions.
• Experience in mentoring junior developers.

Responsibilities

• Lead the design and analysis of database solutions.
• Create and maintain Technical Design Documents (TDDs).
• Develop and optimize complex Oracle PL/SQL code.
• Manage the entire software development lifecycle (SDLC).
• Mentor junior and mid-level developers.

Skills

PL/SQL

Oracle Database 19C

Database design

Technical mentoring

Code reviews

Job description

Lead Oracle Developer with strong experience in PL/SQL and Oracle Database 19C to lead analysis, design, and development efforts. This role will involve direct collaboration with architects, mentoring of junior developers, and driving the technical direction of database projects.

Responsibilities

• Lead the design and analysis of database solutions by working closely with solution architects and business stakeholders.
• Create and maintain Technical Design Documents (TDDs), ensuring clarity and adherence to project specifications.
• Develop, review, and optimize complex Oracle PL/SQL code including Procedures, Packages, Functions, and Views.
• Lead the database development on Oracle 19C, implementing best practices in database design and optimization.
• Mentor and guide junior and mid-level developers through the development process, offering technical support and expertise.
• Lead code reviews and ensure that development practices follow industry standards and project requirements.
• Coordinate with architects, developers, and other stakeholders to ensure consistent delivery of high-quality solutions.
• Work closely with project managers and business analysts to ensure the development aligns with business requirements and timelines.
• Manage the entire software development lifecycle (SDLC) independently, from design and development to testing and deployment.
• Act as the main point of contact for the development team, ensuring open communication channels with all stakeholders.
• Provide technical expertise during project planning sessions and collaborate on design decisions.