Database Administrator in York

About the Role

We are looking for an experienced Database Administrator to join our existing operations and production team.

You will be responsible for the monitoring, maintenance, and optimisation of critical customer production databases.

In addition to this, you will use your extensive database design and development skills to analyse our current data storage, provide suggestions to improve the performance and maintainability and then work closely with our developers to support the on-going software development process in multiple environments.

Hours of work: Flexitime available, core hours of 10am – 3pm Monday – Friday must be worked, and you must work 37.

5 hours per week.

Key Skills and Experience:

• Excellent knowledge of database design, data governance, information security, backup, and recovery best practices
• Excellent troubleshooting skills
• Extensive knowledge of T-SQL, SSIS and SSRS
• Strong verbal and written communication skills
• A curiosity for new technologies and techniques, and actively keeping yourself up to date
• Ability to understand, diagnose and investigate legacy database designs
• Experience in an environment using SQL, Stored Procedures and Entity Framework to access data
• Experience working closely with a software development team with understanding of the software development lifecycle
• Comfortable monitoring and supporting many critical production databases

The ideal candidate will have (by no means essential):

• Experience working with SentryOne
• Familiarity with NoSQL databases, e.g. MongoDB
• Experience with other relational database types, e.g. postgres, MySQL
• Familiarity with distributed search/analysis engines, e.g. Elastic stack
• Working as part of an Agile team
• Experience working in a micro-service architecture

In return, we will provide:

• Hybrid working with offices available in York if you want to come in. You need to work from the office one day per week with one day being our mandatory Thursday which is the last Thursday before payday.
• Learning and development opportunities
• A positive, collaborative working environment
• Quarterly socials
• Holidays starting at 25 days, increasing up to 30 days, 1 day for each year of service
• Vitality Health
• Life Assurance Policy
• Pension scheme (4% employer contribution)
• Modern working facilities
• Pool/ Table Tennis available in the office
• On-site parking
• Pizza Thursdays on the last Thursday of the month
• Cycle to Work Scheme

About Optix:

Optix is the leading provider of business management software for Opticians in the UK.

Our goal is to fulfil all our customer’s technology needs and deliver great software that enables opticians to run profitable businesses and provide excellent clinical care.

This includes the management of clinical processes, sensitive patient data, and integrating with complex medical equipment: alongside delivering comprehensive marketing, stock management, business intelligence, and financial management features.

We are trusted by hundreds of Opticians across the country, from small independent practices to large multi-nationals.

Our success has been built on word-of-mouth from our extremely satisfied client base: we employ no salespeople and focus solely on developing quality products that sell themselves.

We work in a collaborative team where everyone’s input is welcomed and encouraged.

As a member of our development team, you will also be expected to contribute towards the improvement of our organisation by proactively driving improvements in architecture, design, process, tooling, and strategy.

We value and encourage continual personal development within our teams and love learning new tech and are always on the lookout for better ways of doing things.

We also provide training opportunities to help you improve your skills.

Interview Process:

1.

A video or face-to-face interview (preferred) which will be a mix of competency and technical questioning

2.

Depending on the role a technical test may be issued

Diversity Statement:

Optix Software Ltd is committed to equal opportunities in all aspects of our work.

We are committed to treating all colleagues equally regardless of race, gender, disability, age, sexual orientation, religion, or belief.

We are committed to equal opportunities in all aspects of our work.