At a Glance
- Tasks: Manage and optimise Progress OpenEdge databases for performance and security.
- Company: Riverside, a leading housing association enhancing communities across the UK.
- Benefits: Competitive salary, 28 days holiday, flexible working, and personal development investment.
- Other info: Join a diverse team committed to inclusion and community support.
- Why this job: Make a real impact in a role that supports community living and wellbeing.
- 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:
- 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.
- 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 - Microsoft in Liverpool employer: Riverside Group
Riverside is an exceptional employer that prioritises the well-being and development of its employees, offering competitive pay, a generous pension scheme, 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 on communities but also offers a unique opportunity to work within a dynamic and innovative environment.
StudySmarter Expert Advice🤫
We think this is how you could land Database Administrator - SQL - Microsoft in Liverpool
✨Tip Number 1
Network like a pro! Reach out to current or former employees at Riverside on LinkedIn. A friendly chat can give us insider info and might just get your CV noticed by the right people.
✨Tip Number 2
Prepare for the interview by brushing up on your OpenEdge database knowledge. We want to see your expertise shine, so practice explaining complex concepts in simple terms. It’ll show you know your stuff!
✨Tip Number 3
Show your passion for the role! When you get that interview, let us know why you’re excited about working with Riverside. Share how your values align with ours and how you can contribute to our mission.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets into the right hands. Plus, it shows you’re serious about joining our team at Riverside.
We think you need these skills to ace Database Administrator - SQL - Microsoft in Liverpool
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the role of Progress OpenEdge 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 your passion for database management and any relevant projects you've worked on.
Showcase Your Expertise:Don’t hold back on showcasing your expertise in OpenEdge databases. Include specific examples of how you've managed database performance, security, and lifecycle. We love seeing real-world applications of your skills!
Apply Early Through Our Website:We encourage you to apply early through our website to avoid disappointment. Applications may close before the deadline, so don’t wait! We’re excited to see what you bring to the table.
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. Real-life scenarios will impress the interviewers!
✨Understand Their Values
Riverside is all about enhancing communities and supporting diverse needs. Familiarise yourself with their mission and values, and be ready to explain how your personal values align with theirs. This shows you're not just a tech whiz but also a good cultural fit.
✨Ask Smart Questions
Prepare insightful questions that show your interest in the role and the company. Ask about their current database challenges or how they envision the future of their data strategy. This not only demonstrates your enthusiasm but also helps you gauge if it's the right fit for you.
