Database administrator

Job Description The Database Administrator (DBA) is responsible for providing technical support for the database estate including overseeing the development and organization of the databases, performance tuning, assessment and implementation of new technologies and providing a long-term perspective on the relationship of database technology to the business. It is extremely important to AJ Bell that on-line processing database systems offer the highest reliability and performance possible. The DBA will need to work closely with all the teams within Technology Services to provide support, maintenance, and updates as a result of Service Desk calls, planned maintenance or planned updates and software releases. What does the job involve? The key responsibilities of the role are as follows: Maintenance of all databases across the live, test and DR environments. Performance testing and approval of all SQL Scripts to be run against the database instances, as part of the change management process. Ensure database availability and performance is within internal and external SLAs. Actively monitor the servers and their performance. Independently investigate and resolve database issues with both In-House and Third Party. applications. Perform database upgrades. Apply Third Party upgrade and service packs. Establish and maintain appropriate end-user database access control levels. Ensure backup operations are successful. Capacity and architecture planning. Test and implement data fixes for Service Desk calls assigned to the DBA team. Assist the Enterprise Architecture Team on the best database technology for future database projects. Carry out disaster recovery tests to prove the recovery model works. About you: Strong analytical skills with the ability to understand complex processes. A good understanding of relational and non-relational databases. Good communication skills, both written and verbal. An ability to see the bigger picture and challenge current processes. Effective time management and the ability to prioritise and execute tasks in a high-pressure environment. Self-motivated and directed, with keen attention to detail. Team-oriented, collaborative. 5 years+ experience Microsoft SQL Server. Understanding of relational and non-relational database systems. NoSQL databases such as MongoDB SQL Server clustering, Replication and High Availability. Performance Tuning of SQL Server databases. Upgrades and migrations of legacy systems to new SQL versions. About us: AJ Bell is one of the fastest-growing investment platform businesses in the UK offering an award-winning range of solutions that caters for everyone, from professional financial advisers, to DIY investors with little to no experience. We have 491,000 customers using our award-winning platform propositions to manage assets totaling more than £76.1 billion. Our customers trust us with their investments, and by continuously striving to make investing easier, we aim to help even more people take control of their financial futures. Having listed on the Main Market of the London Stock Exchange in December 2018, AJ Bell is now a FTSE 250 company. Headquartered in Manchester with offices in central London and Bristol, we now have over 1200 employees and have been named one of the UK s Best 100 Companies to Work For’ for five consecutive years. There are opportunities for growth and professional development for employees wanting to progress within their career including induction training and our study support scheme which is part of our benefits package. There is an active programme of social events throughout the year, which are open to all employees. What we offer: Competitive starting salary Generous holiday allowance of 25 days, increasing up to 31 days with service, plus bank holidays Holiday buy/sell scheme Hybrid working policy Casual dress code Discretionary bi-annual bonus Contributory pension scheme Buy as you earn share scheme Free shares scheme Paid study support for qualifications Enhanced maternity/paternity scheme from day one Bike loan Season ticket loan portal Free gym Discounted PMI and Dental Paid volunteering opportunities Free social events and more AJ Bell is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and all employees are empowered to bring their whole self to work. We do not discriminate on the basis of race, sex, gender identity, sexual orientation, age, pregnancy, religion, physical and mental disability, marital status and any other characteristics protected by the Equality Act 2010. All decisions to hire are based on qualifications, merit and business need.