Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Software Engineer III role.
Rezi rewrites your resume against Pearson's job description. Free.
Tailor your resume to this Software Engineer III role.
Rezi rewrites your resume against Pearson's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Software Engineer III posting at Pearson — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Software Engineer III posting at Pearson — free, in seconds.
About the Role
We are looking for an Oracle Engineer to join the team delivering our TOpS programme. You will design, build and support Oracle database solutions and Oracle APEX applications, and own the data pipelines that ingest, transform and validate data from multiple internal and external sources. Data quality, accuracy, traceability, and reliability are central to this role as the information managed underpins operational decisions and reporting. The role involves close collaboration with business SMEs, product owners, architects, QA engineers, and fellow developers, requiring excellent communication and analysis skills. You will also explain technical designs and decisions clearly to non-technical colleagues.
Responsibilities
- Design, develop and maintain Oracle APEX applications, from data model through to user interface, security and deployment.
- Write and optimise high-quality SQL and PL/SQL, including packages, procedures, functions and triggers that support business applications.
- Build, schedule and monitor data pipelines (ETL/ELT) that load, transform and reconcile data between Oracle and other systems.
- Implement data validation rules, reconciliation checks and exception handling so that data issues are caught early and resolved at source.
- Tune the performance of queries, pipelines and APEX pages, using execution plans, indexing and partitioning strategies.
- Contribute to code reviews, automated testing, CI/CD and technical documentation.
- Support live services by investigating and resolving incidents and data defects.
Requirements
- Strong hands-on experience with Oracle Database (19c or later).
- Expert SQL and PL/SQL, including packages, bulk processing (BULK COLLECT/FORALL), dynamic SQL, collections and robust exception handling.
- Relational data modelling and normalisation, with an understanding of dimensional/data warehouse design.
- Performance tuning using execution plans, indexing, partitioning, and Oracle diagnostic tools.
- Commercial experience designing, building and supporting Oracle APEX applications on recent releases.
- Confident use of interactive reports and grids, forms, faceted search, dynamic actions, processes, validations and shared components.
- Implementing authentication and authorisation schemes, role-based access and APEX security good practice (e.g. session state protection, preventing SQL injection and XSS).
- Building and consuming REST services using Oracle REST Data Services (ORDS) and APEX REST Data Sources.
- JavaScript, HTML and CSS for customising the APEX user interface; experience with APEX plug-ins is an advantage.
- Managing the APEX application lifecycle: exports, supporting objects, promotion between environments and source control.
- Designing and building ETL/ELT pipelines, including staging, transformation, incremental loading and Change Data Capture (CDC) concepts.
- Scheduling and orchestration with DBMS_SCHEDULER, and loading data using external tables, SQL*Loader, Data Pump or DBMS_CLOUD.
- Integrating data from files (CSV, JSON, XML) and APIs from multiple internal and external sources.
- Implementing pipeline monitoring, logging, and alerting to identify and address issues proactively.
- Designing and implementing data validation rules, constraints and reconciliation checks between source and target.
- Data profiling, cleansing and de-duplication, with clear handling and reporting of rejected or exception records (e.g. DML error logging).
- Understanding of data lineage, auditability and data protection obligations (UK GDPR) when handling personal or sensitive data.
- Version control for database and APEX code using Git (Bitbucket).
- CI/CD for database change, using tools such as SQLcl, Liquibase or similar.
- Automated testing design and set-up, including PL/SQL unit testing (e.g. utPLSQL).
- Jira, Kanban boards and agile delivery methods.
- Excellent organisational, communication and planning skills; proactive and self-motivated.
Skills
- Oracle Database
- SQL
- PL/SQL
- Oracle APEX
- ETL/ELT
- JavaScript
- HTML
- CSS
- Git
- CI/CD
- Automated Testing
- Jira
- Kanban
- Agile
Location
- Rotherham
- Manchester
- London
Work Type
- Hybrid
- Full-time
- Part-time
Experience Level
- Software Engineer III
Education Level
- Oracle certification (e.g. Oracle APEX Cloud Developer Professional or Oracle Database SQL Certified Associate)
Benefits
- 25 days annual leave (increasing by 1 day with every year of continuous service up to 30 days)
- Private pension plan scheme where we pay in double what you contribute, up to 16% depending on your age
- Life, private medical and dental care insurance options, plus free eye tests
- Stock/share purchase options
- Maternity, paternity, and family care leave
- Flexible working policies
- An employee wellbeing assistance programme
- Cycle to work programme
- Volunteering days
- Gym membership concessions in selected office locations
- Retail and leisure discounts
About the Company
- At Pearson we ‘add life to a lifetime of learning’ so everyone can realise the life they imagine. We do this by creating vibrant and enriching learning experiences designed for real-life impact. Our Purpose | Add Life to a Lifetime of Learning. Pearson was founded in 1844 and has been built on our ability to grow with and adapt to a constantly evolving market. Our 20,000+ employees are dedicated to creating high-quality, digital-first, accessible and sustainable resources for lifelong learning.