Job description
As a DBA you will manage MS SQL and Postgres database estates, operating natively on cloud VM installations, as well as cloud DBaaS namely, CloudSQL (GCP) and RDS (AWS).
Please note - there is an on-call rota for this position on a rotational basis and is compensated.
Responsibilities
- Maintain a performant, optimised and secure database estate, keeping production systems operating to SLA through the high availability of the database infrastructure to minimise the duration and impact of any outages.
- Perform scheduled maintenance activities, including production systems out-of-hours patching, and to provide support for product deployments, including implementation of schema changes across all database environments.
- Undertake system health-checks, performance monitoring and diagnosis to identify and to investigate poorly performing production database SQL queries. Work with Developers to remove technical debt to improve the efficiency of systems.
- Support the development teams to ensure good database design and assist in approval/optimisation of the DB change release processes.
- Assist with day-to-day management of the database architecture covering production and non-production environments. Build and manage repeatable infrastructure using automation and proactive monitoring.
- Maintain database applications and configurations to meet security standards, including data risk analysis.
- Manage data storage and retention include data backup, archiving and secure deletion.
- Manage data replication and DR environment, perform regular DR testing and proving.
- Work closely with colleagues from the Operations Support and Data teams to run ad hoc reports and to provide assistance and advise on database querying
Required Skills
- Excellent problem-solving skills and the ability to identify and resolve complex performance issues.
- Experience in SQL Server DB administration with a focus on design, performance tuning, optimisation, profiling, and analysis. Good knowledge of database architecture sizing and capacity planning.
- Strong communication skills, both written and verbal, with the ability to present technical information to non-technical stakeholders.
- Ability to work independently and as part of a team, managing multiple tasks and priorities effectively.
- In-depth understanding of database and data security and its application across multiple environments.
- Background in Infrastructure/ IT Operations.
- Knowledge of BI reporting packages.
- Infrastructure as code, CI/CD concepts, managing SQL Server in a cloud environment.
Benefits
- You will be entitled to 25 days’ holiday + 8 bank holidays increasing with length of service.
- Birthday off work
- 2 Volunteer days a year.
- The option to purchase additional days holiday.
- We operate a contributory pension scheme which you will be auto-enrolled into from day one of employment.
- Free Gym Membership with Pure Gym or Wellbeing Allowance
- Enhanced maternity, paternity and adoption leave
- Share option scheme after probation
- Cycle to work scheme after probation
- Health cash plan
- Free breakfast & lunch food when in the Manchester office
- Discounted Parking in Manchester
- Access to training – both internal and external
About AccessPay
Head quartered in Manchester we have a diverse, supportive and inclusive workplace culture. We provide people with the balance of remote of office working they need to thrive. Whilst AccessPay continues to grow, we remain a start up at heart but continue to grow agile teams, working cross functionally, learning from each other and not being afraid to take on ambitious challenges.
AccessPay is proud to be named a Great Place to Work® to Work-Certified™ company.
Apply Now
Our Hiring Process
Stage 3:
Stage 4:
Stage 5:
Stage 1:
Stage 2:
Stage 3:
Stage 4:
Stage 5:
Stage 1:
Stage 2:
Stage 3:
Stage 4:
Stage 5:
1
2
Not quite right? Register your interest to be notified of any roles that come along that meet your criteria.
Application Deadline
August 11, 2023
Department
Operations
Employment Type
Full Time
Location
Manchester
Workplace type
Hybrid
Compensation
£50,000 / year
Reporting To
David Ensor