Progress Open Edge Database Administrator – Liverpool. Fixed‑term 18‑month contract. Salary £47,596 per annum, increasing to £52,606 after 12 months of successful performance. 35 hours per week, Monday‑Friday hybrid schedule.
Role Overview
You will own the stability, performance, security, and lifecycle of Progress OpenEdge databases and the Pro2 replication estate. You will design, build, tune, and operate mission‑critical Progress environments (PASOE/AppServer‑backed) and ensure robust data movement into downstream systems (e.g., SQL Server, Snowflake) through Pro2 for analytics, integration, and reporting. You will be the subject‑matter expert for OpenEdge database internals, after‑imaging, backup/recovery, and replication patterns, enabling high availability, business continuity, and secure‑by‑design operations.
Responsibilities
* Environment ownership: install, configure, patch OpenEdge RDBMS (v12+), and maintain PASOE/AppServer where relevant.
* Operational excellence: manage database startup parameters, AI/BI areas, storage areas, extents, and block/record settings for performance and resilience.
* Backup & recovery: design and run probkup/prorest strategies (cold, online, incremental); manage AI archiving, roll‑forward recovery, and DR runbooks.
* Performance engineering: baseline and tune buffer pools, latch/lock contention, schema & index design, scatter factor, statistics, index rebuilds, and system‑level parameters.
* Capacity & lifecycle: forecast growth, plan storage and upgrades, and lead version uplift programmes (including PASOE migrations, 12.x+).
* Monitoring & observability: implement and maintain monitoring (e.g., ProTop/OpenEdge Management), alerting, and trend analysis; track latency, I/O, and replication health.
* Security & compliance: enforce least privilege (OpenEdge users/roles, SQL‑92 permissions), encryption (at‑rest/in‑flight), audit trails, data masking, and align with GDPR and internal standards.
* Automation: script routine ops (PowerShell), implement idempotent provisioning (Ansible/Terraform), and codify runbooks.
* Incident/problem management: root‑cause analysis, major incident support, post‑incident reviews, and resilience improvements.
* Documentation: maintain architecture diagrams, SOPs, DR playbooks, replication maps, and service documentation.
Pro2 Replication
* Architecture & setup: design and implement Pro2 topologies (real‑time/change‑trigger or batch), ensuring schema mapping, key strategy, and target platform alignment (SQL Server/Oracle/PostgreSQL).
* Build & configuration: configure Pro2 components, queues, transformation rules, and load initial data (seeding).
* Change capture: manage trigger‑based CDC, monitor trigger health and performance, and track replication tables, queues, and latency.
* Operations & reliability: monitor lag, detect and clear bottlenecks, handle restarts, and manage conflict resolution and retries.
* Performance tuning: optimise commit sizing, batching, parallelism, indexing on targets, and network throughput to reduce source overhead.
* Schema evolution: coordinate schema changes with Pro2 mappings, versioning, and backward compatibility; automate migration steps.
* DR & failover: align Pro2 with wider HA/DR strategy, test and document failover and backfeed processes.
* Data quality & reconciliation: implement checksums, row counts, exception queues, and reconciliation jobs; work with BI/data teams to validate downstream integrity.
Qualifications
* OpenEdge RDBMS: proven hands‑on Progress DBA experience with proutil, rfutil, dbanalys, AI/BI management, storage areas, and index maintenance.
* Pro2 expertise: proven deployment and support at scale (thousands+ tables, near real‑time SLAs), trigger management, agent tuning, conflict handling.
* Performance tuning: deep understanding of locking, latching, buffer management, scatter/clustering, and workload profiling.
* Backup/DR: online backups, AI roll‑forward, PITR, replication to secondaries; evidenced DR testing and RTO/RPO accountability.
* Scripting & automation: PowerShell; familiarity with CI/CD for infra‑as‑code and runbook automation.
* OS & platforms: Windows Server.
* Networking & security: TLS, certificates, firewalling, least privilege, key management, audit requirements.
* Tooling: ProTop or OpenEdge Management; experience with Prometheus/Grafana, Splunk/ELK for logs is a plus.
* App server awareness: PASOE/AppServer basics and session model.
* Stakeholder collaboration: partner with application, BI, SecOps, and SRE/Platform teams.
* Compliance: understanding of GDPR, data retention, and secure data handling in production.
Desirable
* OpenEdge replication warm standby administration.
* SQL‑92 engine tuning and JDBC/ODBC connectivity patterns.
* Tuning on Microsoft SQL Server.
* Cloud experience: OpenEdge in IaaS, backup object storage (S3/Blob), cloud networking, managed monitoring stacks.
* Automation stack: GitHub Actions/Azure DevOps pipelines.
* Languages: Progress ABL/4GL, Python, Go for ops utilities.
* Certifications: Progress OpenEdge or vendor training; cloud/platform (Azure) certifications.
* Experience with the OpenHousing Housing Management System.
Benefits
* Competitive pay & generous pension.
* 28 days holidays plus bank holidays.
* Flexible working options.
* Investment in learning, personal development, and technology.
* A wide range of other benefits.
Diversity & Inclusion
Riverside is a Disability Confident Employer and operates a Guaranteed Interview Scheme for eligible applicants. This role also falls under our Ethnic Diversity guaranteed interview scheme.
Application
If you share our values and are excited about making a significant impact at Riverside, please attach a current CV and covering letter. At Riverside we recruit to potential, not just on skills and experience, so we encourage you to apply even if you don’t meet all the essential criteria.
#J-18808-Ljbffr