Overview
We are searching for a Lead Oracle Developer with extensive experience to lead the analysis, design, and development of intricate database solutions in a hybrid work environment. The contractor will collaborate with solution architects and business stakeholders, mentor junior developers, and oversee the technical direction of Oracle database projects throughout all stages of the software development lifecycle. This role is pivotal to ensuring the delivery of scalable and robust database systems, allowing for successful project outcomes.
Responsibilities
- Lead the design and analysis of database solutions in collaboration with solution architects and business stakeholders.
- Create and maintain Technical Design Documents (TDDs) ensuring compliance with project specifications.
- Develop, review, and optimize complex Oracle PL/SQL code, including Procedures, Packages, Functions, and Views.
- Conduct thorough code reviews and maintain development standards aligned with industry best practices.
- Coordinate with project managers, architects, and stakeholders to ensure a consistent delivery of high-quality solutions.
- Manage the full software development lifecycle (SDLC) independently, from design through to deployment.
- Act as the primary technical point of contact for the development team, facilitating open communication across stakeholders.
- Provide technical expertise during project planning sessions, contributing to architectural design decisions.
Requirements
- 7–10 years of hands-on experience as an Oracle Developer with expertise in PL/SQL and Oracle Database 19C.
- Proven track record of leading database development projects from start to finish.
- Strong proficiency in writing, reviewing, and optimizing complex PL/SQL code.
- Solid understanding of database design principles, normalisation, indexing strategies, and performance tuning.
- Experience in producing Technical Design Documents and working with formal SDLC processes.
- Excellent communication and stakeholder management skills.
- Familiarity with Oracle Forms and Reports (D2k), performance tuning, and AWS reporting is a plus.
- Knowledge of version control systems and project management tools like JIRA and Confluence is advantageous.