Database Administrator

Job Description

The Team & Focus of the RoleWe have an exciting opportunity for a new Database Administrator to join our Systems team. Your focus would initially be on the day-to-day lifecycle management of our core system databases; however, the individual will be central to the implementation ofa new data warehouse planned for the business.Simplification and Integration is key as we have legacy solutions based on different database technologies along with complex integrations between our transactional systems and our core applications.This role will really suit you if you have a background in multiple database systems; extract, load and transform (ETL) solutions and have an ability to create normalised data sets for reporting with BI tools such as PowerBI.This role will be based in Ashby and although we do offer a hybrid working policy, it’s essential that you’d be commutable to Ashby weekly. Our standard hours are 8.45am - 5.15pm (37.5 hours) however we’re open to discussing flexible working requirementswith a minimum working week of 30 hours per week.In return, beyond your base salary you will be included in:

• A discretionary bonus scheme
• A generous holiday scheme which commences at 25 days with a sliding scale up to 30 days plus your birthday off and two extra half days allocated for Christmas Eve & New Years Eve
• Enhanced maternity, paternity, adoption and shared parental leave
• An online money saving portal and access to a 24/7 mental health & wellbeing service.
• Volunteering Leave equating to 2 days per year (pro rata if you’re part-time)

Duties will include:

• Maintaining and monitoring existing databases
• Creating new data repositories as the need arises
• Developing innovative approaches to storing data via warehousing
• Managing update processes and creating data backups
• Restoring lost data
• Helping to model data for new applications within the business
• Developing and maintaining procedures and documentation for databases
• Identifying, evaluating, and managing the adoption of appropriate database administration tools and processes, including automation
• Contirbuting to the setting of standards for definition, security and integrity of database objects and ensuing conformance to those standards
• Implementing a security-first approach to storing and retrieving data
• Building test versions and testing
• Designing efficient queries for analytics and reporting access the business

The successful candidate will have...

• Database administration and design
• Relational and non-relational database architectures
• Maintaining and developing self-hosted and DBaaS Cloud databases (AWS/AZURE)
• Data warehouse solutions (e.g., Redshift, Panoply, Snowflake)
• Structured Query Languages (e.g., MySQL, MariaDB, MSSQL)
• NoSQL Technologies (e.g., MongoDB, Elasticsearch, CouchDB)
• Using access control policies and management systems (Active Directory & SSO technologies for instance)
• Business intelligence, reporting and dashboarding tools (e.g., PowerBI)
• Excellent verbal and written communication

In addition, the following would be desirable:

• Data model design (UML, Entity Relation) and related documentation
• Working within an Agile environment
• Working within a team and independently
• Integrating and exposing data from multiple services (for example Microsoft Power Platform)

Why Fisher GermanWe’ve been around for a while, but it doesn’t mean we are behind the times! Across our office network we offer a hybrid working approach to help our colleagues design their working day to suit their diaries. Some days you might be in the office enjoyinga collaborative team day, and other days might see you focussing on project work at home. Wherever you choose to work, you’ll be part of a social and digitally connected workforce with the chance to get involved in a variety of activities, like sports events,pop-up bars, BBQs, CPD days, live leadership updates on Zoom, picnics in the park and lots more.What’s not to love We work hard but we also have lots of fun! If that sounds like something you would enjoy, then please get in touch.We have a history going back as far as 1830 but have been Fisher German since 2000. We operate UK wide advising and managing a range of client portfolios with national visibility across all the 6-property market sectors; rural, commercial, development, residential,infrastructure services and sustainable energy.Bring Yourself to WorkIt’s simple really, we are passionate about what we do, and we want you to be driven to succeed with us. For this to happen, you need to feel supported and included which is why we’re proud to be an Equal Opportunities Employer.