At a Glance
- Tasks: Manage and optimise Progress OpenEdge databases for performance and security.
- Company: Join Riverside, a leading housing association making a real difference in communities.
- Benefits: Enjoy competitive pay, generous holidays, flexible working, and personal development opportunities.
- Other info: Diverse and inclusive workplace with guaranteed interviews for underrepresented groups.
- Why this job: Be a key player in enhancing lives through innovative database management.
- Qualifications: Experience with OpenEdge databases and Pro2 replication is essential.
The predicted salary is between 47596 - 52606 ÂŁ per year.
Contract Type: Fixed term contract 18 months
Salary: ÂŁ47,596 Per annum (ÂŁ52,606 is achieved after 12 months successful performance in the role)
Working Hours: 35 Hours per week
Working Pattern: Monday-Friday/Hybrid
Location: Liverpool
If you share our values and are excited about making a significant impact at Riverside, please ensure you 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 on the job description.
The difference you will make as a Progress Open Edge Database Administrator:
- 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.
About you:
- Proven experience, including proutil, rfutil, dbanalys, AI/BI management, storage areas, and index maintenance.
- Pro2 expertise: Proven experience deploying and supporting Pro2 replication at scale (thousands+ tables, near real-time SLAs), including trigger management, agent tuning, and 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; evidence of DR testing and RTO/RPO accountability.
Why Riverside?
At Riverside, we’re a housing association with a difference – enhancing the everyday for all our customers. For 90 years, we’ve been revitalising neighbourhoods and supporting communities by providing the homes they need to live full, fulfilling and rewarding lives. We have a portfolio of over 75,000 affordable residential and retirement homes across the UK. Our work ranges from homelessness services to social care, employment support to retirement living, and we need the best people on board to help us.
Working with us, you’ll enjoy:
- Competitive pay & generous pension
- 28 days holidays plus bank holidays
- Flexible working options available
- Investment in your learning, personal development and technology
- A wide range of benefits
Diversity and Inclusion at Riverside:
We are inclusive. At Riverside, we value diversity in all its forms. We foster a workplace where all individuals are respected, empowered, and heard. Our commitment to inclusivity drives our success and enriches the lives of our customers and colleagues. Riverside is a Disability Confident Employer and operates a Guaranteed Interview Scheme for any applicant who declares they have a disability. If the applicant meets the minimum requirements for the role (as set out in the role profile and/or person specification) they will be guaranteed an interview. This role also falls under our Ethnic Diversity guaranteed interview scheme. If you are Ethnically Diverse and demonstrate you meet the minimum criteria for the role you will be guaranteed an interview. Applications may close before the deadline, so please apply early to avoid disappointment.
Role profile:
- Core OpenEdge Database Administration:
- Environment ownership: Install, configure, and patch OpenEdge RDBMS (v12+) on the Microsoft Windows platform; 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, stats (e.g., dbanalys), 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 where needed; align with GDPR and internal security standards.
- Automation: Script routine operations (PowerShell), implement idempotent provisioning (Ansible/Terraform where applicable), and codify DBA 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 “How we run” service documentation.
- Pro2 Replication (OpenEdge RDBMS Targets):
- Architecture & setup: Design and implement Pro2 topologies (real-time/change-trigger based or batch), ensuring schema mapping, key strategy, and target platform alignment (SQL Server/Oracle/PostgreSQL).
- Build & configuration: Configure Pro2 components (replication agents/services, brokers, queues), table inclusion/exclusion, transformation rules, and load initial data (seeding).
- Change capture: Manage trigger-based CDC, maintain trigger health and performance; monitor replication tables, queues, and latency.
Progress OpenEdge Database Administrator in Liverpool employer: Riverside Group
Contact Detail:
Riverside Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Progress OpenEdge Database Administrator in Liverpool
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or at industry events. Let them know you're on the hunt for a Progress OpenEdge Database Administrator role. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Prepare for interviews by brushing up on your technical skills and understanding of Pro2 replication. Practice common interview questions related to database management and performance tuning. Confidence is key, so show them you know your stuff!
✨Tip Number 3
Don’t just apply anywhere; focus on companies that align with your values, like Riverside. Tailor your approach to highlight how your experience can make a difference in their mission. Remember, they’re looking for potential, not just skills!
✨Tip Number 4
Finally, apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re genuinely interested in joining the team. Don’t wait too long, as applications may close early!
We think you need these skills to ace Progress OpenEdge Database Administrator in Liverpool
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Progress OpenEdge Database Administrator role. Highlight your relevant experience with OpenEdge databases, Pro2 replication, and performance tuning. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're excited about the role and how you can make a difference at Riverside. Be genuine and let your personality come through – we love to see that!
Showcase Your Achievements: When detailing your experience, focus on specific achievements rather than just listing duties. Did you improve database performance or successfully manage a complex backup strategy? We want to hear about it!
Apply Early Through Our Website: Don’t wait until the last minute to apply! Applications may close early, so get your CV and cover letter in as soon as possible through our website. We’re excited to see what you bring to the table!
How to prepare for a job interview at Riverside Group
✨Know Your OpenEdge Inside Out
Make sure you brush up on your knowledge of Progress OpenEdge databases. Be ready to discuss your experience with proutil, rfutil, and dbanalys. Prepare examples of how you've handled performance tuning and backup strategies in past roles.
✨Showcase Your Pro2 Expertise
Since Pro2 replication is a key part of the role, be prepared to talk about your experience deploying and supporting Pro2 at scale. Highlight specific instances where you managed trigger health, agent tuning, or conflict handling to demonstrate your hands-on expertise.
✨Demonstrate Problem-Solving Skills
Interviewers will want to see how you approach challenges. Think of a few scenarios where you had to perform root cause analysis or manage major incidents. Be ready to explain your thought process and the steps you took to resolve issues effectively.
✨Prepare Questions About Company Culture
Riverside values diversity and inclusion, so it’s a good idea to ask questions that show you’re interested in their culture. Inquire about their commitment to employee development or how they foster an inclusive environment. This shows you’re not just focused on the technical side but also on being a good fit for the team.