Solutions Analyst

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!

• 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 customised reports.
• Write clean, maintainable, and highly optimised PL/SQL code (packages, procedures, functions, triggers, and types).
• Architect and design relational data models, ensuring data integrity, normalisation, and performance efficiency.
• Perform query tuning, analyse execution plans, and optimise indexes to ensure low latency across massive datasets.
• Build robust RESTful APIs using Oracle REST Data Services (ORDS) to expose database endpoints.
• Collaborate with Cloud Engineers and DBAs to support database infrastructure running on‑premise and on GCP.
• Support data replication, ETL pipelines, and secure networking between on‑premise Oracle databases and GCP‑hosted resources (e.g., Cloud SQL, Compute Engine, Big Query).
• Develop routines for cross‑data‑centre data synchronization and integrity validation.
• Participate in database migration plans, backup strategies, and Disaster Recovery (DR) drills involving both on‑premise and GCP topologies.

• Extensive knowledge of Oracle Database 19c / 23c, including database objects, memory architecture, and optimisation.
• Expert‑level writing of complex PL/SQL block structures, analytical functions, bulk collections, and exception handling.
• Strong experience with modern APEX version 24 and newer, custom themes, templates, and JavaScript integration.
• Proficient in configuring and developing ORDS REST APIs.
• Solid foundational understanding of HTML5, CSS3, JavaScript, and JSON formatting.
• Familiarity with GCP core services (GCE, Cloud SQL for MySQL, Cloud Storage, and IAM).
• Experience with Git version control and CI/CD pipelines (such as Git Lab CI or Google Cloud Build).
• Experience with SQL Server and Google Big Query is a strong plus.
• Degree in Computer Science, Information Technology, or a closely related quantitative field.
• Demonstrable professional experience in Oracle PL/SQL development and specifically developing and deploying applications with Oracle APEX.
• Legal right to work in the UK at the start of employment.

• Competitive salary £40,000 – £55,000 p.a. (dependent on experience).
• Stakeholder pension scheme, up to 10% employer contribution.
• 5 weeks holiday plus bank holidays per annum, increasing to 6 weeks with length of service.
• Flexible annual leave policy to buy or sell holiday leave.
• Paid volunteering days.
• Cycle to work scheme.
• Health cash plan.
• Life assurance.
• Wellbeing related benefits.

South East Water  recognises that our communities are diverse. We believe that creativity comes from diversity, not similarity. We are enthusiastic about creating inclusion across age, race, gender, ethnicity, religion, and identity, and we are committed to providing equal opportunities in recruitment, employment, and career progression.