At a Glance
- Tasks: Manage and optimise Progress OpenEdge databases for performance and security.
- Company: Riverside, a leading housing association with a community focus.
- Benefits: Competitive salary, generous holidays, flexible working, and personal development opportunities.
- Other info: Join a diverse team committed to inclusion and community support.
- Why this job: Make a real difference in communities while advancing your database skills.
- Qualifications: Experience with OpenEdge databases, Pro2 replication, and performance tuning required.
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.
The difference you will make as a Progress Open Edge Database Administrator:
- Own the stability, performance, security, and lifecycle of Progress OpenEdge databases and the Pro2 replication estate.
- 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.
- 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.
- 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. Riverside is a Disability Confident Employer and operates a Guaranteed Interview Scheme for any applicant who declares they have a disability. This role also falls under our Ethnic Diversity guaranteed interview scheme. 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; 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: 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: 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.
Database Administrator - SQL /oracle in Liverpool employer: Riverside Group
Riverside is an exceptional employer that prioritises the well-being and development of its employees, offering competitive salaries, generous pension schemes, and 28 days of holiday plus bank holidays. With a strong commitment to diversity and inclusion, Riverside fosters a supportive work culture where every individual can thrive, while also providing flexible working options and significant investment in personal and professional growth. Located in Liverpool, this role as a Progress Open Edge Database Administrator not only allows you to make a meaningful impact in the community but also offers unique opportunities to work with cutting-edge technology in a mission-driven environment.
StudySmarter Expert Advice🤫
We think this is how you could land Database Administrator - SQL /oracle in Liverpool
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or at industry events. We all know that sometimes it’s not just what you know, but who you know that can help you land that dream job.
✨Tip Number 2
Prepare for those interviews by practising common questions and scenarios related to database administration. We recommend doing mock interviews with friends or using online platforms to get comfortable with the process.
✨Tip Number 3
Showcase your skills! Create a portfolio or GitHub repository where you can demonstrate your database projects and achievements. This gives potential employers a tangible look at what you can do.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are genuinely interested in joining our team at Riverside.
We think you need these skills to ace Database Administrator - SQL /oracle in Liverpool
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the role of Progress Open Edge Database Administrator. Highlight your experience with Pro2 replication, performance tuning, and backup strategies. 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 this role and how you can contribute to Riverside. Be sure to mention specific experiences that relate to the job description.
Showcase Your Technical Skills:Don’t forget to showcase your technical expertise in your application. Mention your familiarity with tools like proutil, rfutil, and your experience with database management. We love seeing candidates who know their stuff!
Apply Early Through Our Website:We encourage you to apply early through our website to avoid missing out! Applications may close before the deadline, so don’t wait too long to submit your CV and cover letter.
How to prepare for a job interview at Riverside Group
✨Know Your Stuff
Make sure you brush up on your OpenEdge database knowledge, especially around performance tuning and backup strategies. Be ready to discuss your experience with tools like proutil and rfutil, as well as your understanding of Pro2 replication.
✨Showcase Your Problem-Solving Skills
Prepare to share specific examples of how you've tackled challenges in database management. Think about times when you had to handle conflict resolution in Pro2 or optimise performance under pressure.
✨Understand the Company Culture
Riverside values diversity and community impact, so be ready to discuss how your personal values align with theirs. Show enthusiasm for their mission and how you can contribute to enhancing everyday lives through your role.
✨Ask Insightful Questions
Prepare thoughtful questions that demonstrate your interest in the role and the company. Inquire about their current database challenges or how they measure success in the DBA role. This shows you're not just interested in the job, but also in being part of their team.
