Solutions Analyst

South East Water UK; Snodland; Hybrid; GBP 90,000 - 120,000; Full time

Job summary

South East Water is seeking a Solutions Analyst/Developer to design, build, deploy, and continuously improve Oracle-based apps and databases. You’ll bridge on-premise infrastructure with Google Cloud, delivering efficient PL/SQL, Oracle APEX interfaces, and REST APIs in a hybrid environment.

You will work with Oracle 19c/23c, APEX 24+, and ORDS, ensuring secure authentication, optimized queries, and scalable data models across data centers and cloud resources.

Qualifications

• Oracle 19c/23c knowledge and optimization.
• Expert-level PL/SQL development.
• Experience with Oracle APEX 24+ and UI customization.
• Experience with ORDS REST APIs.
• HTML5/CSS/JS basics and JSON formatting.
• Familiarity with GCP core services (GCE, Cloud SQL, IAM).
• CI/CD experience with GitLab CI or Cloud Build.
• Experience with SQL Server and Google BigQuery is a plus.
• Degree in CS/IT or related field.
• Proven Oracle PL/SQL development experience.
• Experience deploying Oracle APEX applications.

Responsibilities

• Design, develop, and maintain Oracle APEX applications.
• Implement UI/UX using HTML, CSS, JavaScript and APEX plugins.
• Configure APEX auth schemes integrated with IdP.
• Build interactive grids, charts, and customized reports.
• Write clean, optimized PL/SQL code and data models.
• Develop REST APIs using ORDS to expose endpoints.
• Collaborate with Cloud Engineers for on-prem and GCP integration.
• Participate in migration, DR planning, and cross-data-center sync.

Skills

Oracle Database

PL/SQL

Oracle APEX

API Development

HTML/CSS/JavaScript

GCP Cloud

CI/CD

SQL Server / BigQuery

Oracle ORDS

Data Modeling

Degree in CS/IT

Education

Degree in Computer Science/Information Technology

Tools

ORDS

GitLab CI

Google Cloud Build

Job description

Summary

As our Solutions Analyst/Developer at South East Water, you will design, build, deploy, and constantly improve our Oracle-based applications and databases. You'll work right at the intersection of our hybrid setup, bridging our on-premise data centre with our modern Google Cloud Platform (GCP) environment. In this role, you'll write highly efficient database code and use Oracle APEX to design clean web interfaces, keeping our data flowing smoothly between both worlds. We are a forward-thinking technology team bridging the reliability of robust, secure on-premise infrastructure with the dynamic scalability of the cloud. Our core systems are built on Oracle and Google Cloud Platform (GCP). We are seeking a highly skilled Developer to design, develop, and modernise our suite of business-critical web applications. If you are a database-centric developer who loves building highly responsive low-code applications while navigating the exciting complexities of a hybrid on-premise/GCP multi-data-centre architecture, we want to hear from you!

Main Responsibilities

Oracle APEX & Web Development

• Design, develop, and maintain secure, responsive, and user-friendly Oracle APEX applications.
• Implement custom UI/UX requirements using HTML, CSS, JavaScript, and custom APEX plugins.
• Configure APEX authentication and authorization schemes integrated with enterprise Identity Providers (IdP).
• Build and manage interactive grids, charts, and highly customized reports.

Database Engineering & PL/SQL

• Write clean, maintainable, and highly optimized PL/SQL code (packages, procedures, functions, triggers, and types).
• Architect and design relational data models, ensuring data integrity, normalization, and performance efficiency.
• Perform query tuning, analyse execution plans, and optimize indexes to ensure low latency across massive datasets.
• Build robust RESTful APIs using Oracle REST Data Services (ORDS) to expose database endpoints.

Hybrid Infrastructure & Cloud Integration

• Collaborate with Cloud Engineers and DBAs to support database infrastructure running on-premise and on Google Cloud Platform (GCP).
• Support data replication, ETL pipelines, and secure networking between on-premise Oracle databases and GCP-hosted resources (e.g., Cloud SQL, Compute Engine, BigQuery).
• Develop routines for cross-data-center data synchronization and integrity validation.
• Participate in database migration plans, backup strategies, and Disaster Recovery (DR) drills involving both on-premise and GCP topologies.

You'll need:

Skills / Qualifications / Experience

• Oracle Database: Extensive knowledge of Oracle Database 19c / 23c database objects, memory architecture, and optimization.
• PL/SQL Mastery: Expert-level writing of complex PL/SQL block structures, analytical functions, bulk collections, and exception handling.
• Oracle APEX: Strong experience with modern APEX version 24 and newer, custom themes, templates, and JavaScript integration.
• API Development: Proficient in configuring and developing ORDS REST APIs.
• Web Basics: Solid foundational understanding of HTML5, CSS3, JavaScript, and JSON formatting.
• Cloud Infrastructure: Familiarity with GCP core services (GCE, Cloud SQL for MySQL, Cloud Storage and IAM).
• CI/CD & DevOps: Experience with Git version control and CI/CD pipelines (such as GitLab CI, or Google Cloud Build).
• Alternative Databases: Experience with SQL Server & Google BigQuery is a strong plus.
• Degree in Computer Science, Information Technology, or a closely related quantitative field.
• Demonstrable professional experience in Oracle PL/SQL development.
• Demonstrable experience specifically developing and deploying applications with Oracle APEX.

Grow a career with a meaningful purpose.

We know the communities we serve