Oracle Database Developer (SQL & PL/SQL)
Orbenway Technologies LTD
Location: London, UK
Working arrangement: Hybrid
Employment type: Full-time - Permanent
Working hours: 37.5 hours per week
Experience: Minimum 4–5 years of relevant Oracle development experience
Salary and package: To be discussed at interview
About Orbenway
Orbenway Technologies LTD is a software development and IT services company. We help businesses build applications, improve existing systems and support the databases, integrations and cloud environments behind them. Our work includes custom software development, database services, application integration, automation and technical support. We are also developing our own healthcare workflow products.
About the role
We are looking for an Oracle Database Developer with strong SQL and PL/SQL skills to take ownership of database development across our internal products and customer projects. The role will involve designing application data models, developing database business logic, integrating applications and improving performance. You will work closely with our full-stack developer and receive specialist DBA input where needed. The planned workload includes our in-house healthcare systems, Oracle application and E-Business Suite technical work, and an expected Oracle-based CRM development engagement. Project priorities will develop as customer requirements and delivery plans are agreed. You should be comfortable turning business requirements into clear technical designs, explaining your decisions and following work through development, testing, release and support.
Key responsibilities
Database design and development
- Translate business requirements into database designs and development tasks.
- Design and maintain tables, relationships, constraints, indexes, sequences and views.
- Develop and maintain PL/SQL packages, procedures and functions.
- Implement business rules, validation, transaction handling and exception handling.
- Maintain data integrity and develop appropriate audit history for application changes.
- Write readable, maintainable code and document important design decisions.
Application and CRM development
- Develop the Oracle database components supporting business applications and CRM workflows.
- Work with the full-stack developer to connect application features with database logic.
- Develop database interfaces and support APIs and integrations with other systems.
- Implement agreed workflows, reporting queries and data processing routines.
- Investigate application defects and deliver controlled fixes.
Performance and data processing
- Review SQL execution plans and identify inefficient queries.
- Improve SQL and PL/SQL performance through appropriate query design, indexing and processing methods.
- Develop and validate data import, transformation and migration routines.
- Reconcile migrated or processed data and investigate exceptions.
Testing, releases and support
- Create and run tests covering business rules, error conditions and data integrity.
- Support integration testing and user acceptance testing.
- Maintain database code and release scripts in version control.
- Prepare deployment, validation and rollback steps for database changes.
- Work with the DBA on access requirements, environment dependencies and release planning.
- Investigate issues during testing and after deployment.
- Provide technical documentation and handover information.
Essential skills and experience
- Around 4–5 years of practical Oracle database development experience, with the ability to deliver work independently.
- Strong SQL and PL/SQL skills, including packages, procedures, functions, joins and analytical queries.
- Experience designing relational data models and enforcing data integrity.
- Understanding of transactions, locking, concurrency and exception handling.
- Practical experience investigating SQL performance and reading execution plans.
- Experience developing database components for business applications.
- Experience with data imports, migrations or integration processes.
- Familiarity with Git or another version control system.
- A structured approach to debugging, testing and documenting changes.
- Clear written and spoken communication, including the ability to discuss requirements with technical and business colleagues.
Desirable experience
- CRM, workflow or healthcare application development.
- Oracle E-Business Suite technical development or support.
- REST APIs, JSON and application integration.
- Oracle APEX or Oracle REST Data Services.
- Automated database testing and deployment pipelines.
- Working with cloud-hosted Oracle environments.
- Role-based access, audit logging and secure handling of application data.
Qualifications
A relevant qualification in computing, software engineering or a related subject is welcome. Equivalent practical experience will also be considered.
What the role offers
- Ownership of meaningful database development work.
- Involvement in both internal product development and customer delivery.
- Collaboration with application development and database specialists.
- The opportunity to contribute to technical decisions from design through release and ongoing improvement.
How to apply
We are inviting applications from candidates currently based in the UK. Please apply with your CV and a short introduction explaining your relevant Oracle development experience. Include examples of the applications or workflows you have supported, your role in delivering them, your current UK location and your notice period or availability. Apply through this advert or the Careers section of our website. CVs may be submitted in PDF or Word format.
Orbenway Technologies LTD
Technology your business can build on.
www.orbenway.com
[email protected]
Pay: £33,300.00-£45,000.00 per year
Benefits: UK visa sponsorship
Work Location: Hybrid remote in London TW5 9DS