SQL DBA London, England
Job description
Overview
As a SQL DBA will provide full lifecycle production assistance to development, infrastructure, testing and ultimately production. The SQL DBA will be managing and maintaining the SQL Server database environments across IaaS and PaaS platforms, ensure development and testing database environments are kept up to date, work on performance tuning and enhancements, troubleshooting, maintenance, health checks and investigations of production system problems, carrying out peer review and enforcing coding standards whilst being conversant in the automation approach associated in a DevOps environment.
The SQL DBA will also be required to provide support and assistance to the wider Data Services team across alternate database technologies to support the day-to-day operation through BAU activities, ensuring data integrity is maintained and the best possible service available to support business processes, including the provision of out of hours on call.
- Providing operational support and continuous improvement of the SQL estate, processes for Development and Test environments (System, Load, Performance, UAT), up to and including production
- Ensuring automation, process efficiency and appropriate tooling (Code/Branch Management and Deployment/Configurations) are utilised to reduce cycle times and improve reliability, audit and traceability for all system deployments across multiple applications
- Implementing best practice and ensuring database build standards are consistently applied and improved upon
- Undertaking database health checks, backups and implementing DBA best practice
- Developing and merging processes and methodology, ensuring they are correctly defined and applied to software and systems to minimise risk in Production environments caused by poor code management techniques and skills
- Providing strong governance for the management and access of live data in environments where required and ensuring obfuscation technologies/practice is embedded
- Ensuring that the Development Team, whilst working with the DevOps, have the correct environment to maximise their efficacy, obstacles are removed, and automation introduced where appropriate
- Protecting production environments by governance, good practice and process design, ensuring ‘fit for purpose’ environments, to the left or Pre-Prod and supporting all project and change activity
- Ensuring project and change release(s) are packaged to the right quality, repeatable between environments without change or modification and deployed to the target environments – ultimately to Production without detriment or issue and within agreed timescales
- Addressing any weak points in process, technology and service through a culture of continual improvement
- Correctly documenting software and processes to ensure single points of knowledge do not become a problem and that skills are distributed across the team and department
- Ensuring that software deliverables/artefacts as part of any Change or Project, are progressed providing appropriate statues reporting and updates as requested by the Line/project/Change Manager
- Demonstrable knowledge of database administration – design, installation and troubleshooting – of current MS SQL Server and Windows Server enterprise platforms
- Comprehensive knowledge and experience of Current Microsoft SQL Server versions, IaaS and PaaS
- Proven knowledge and experience of Database Mirroring, Log Shipping, Clustering, Availability Groups, Transactional Replication, ETL
- Excellent communication skills with the ability to liaise with a variety of stakeholders at different levels
- The ability to plan and prioritise your own work, whilst working as part of the wider team
- Experience of working with automation deployment tools, in addition to database performance and optimisation experience
- The ability to develop and implement data security guidelines whilst making data available to those authorised to have access
- Experience in support and automated testing of all database releases, in addition to experience supporting large scale critical production databases
- The ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing back-up/recovery strategies
Link Group works in partnership internationally with almost 7,000 clients including asset managers and investors, business managers, asset owners, trustees, issuers and borrowers. We provide the infrastructure through which assets are secured or deployed in both regulated and unregulated markets.
We offer industry-leading shareholder services through Link Market Services to a wide range of corporates, issuers and business managers. We are the largest UK share registrar providing services to more than 1,300 companies large and small across the UK.
We administer share plans for over 200 clients and have worked on more than 50% of UK IPOs since 2005. Our unique place in the market, combined with our partnership and relationship management approach, enables us to play a vital role in connecting issuers with 5 million shareholders around the world.
- A very competitive basic salary plus benefits.
- 23 days’ holiday to start, (rising to 25) plus Bank Holidays, with the opportunity to buy extra leave.
- Company matched pension scheme, life assurance, a cycle2work scheme, fully paid maternity, adoption and shared parental leave, paternity pay of two weeks…and plenty more.
- Voluntary benefits designed to suit your lifestyle – from discounts on retail and socialising, to health & wellbeing, travel and technology.
- The possibility of working from home, flexible working or working part-time options are available.
- You’ll get the chance to follow your chosen career path anywhere in Link Group. You’ll be joining a network of 7,000 experienced, innovative and dedicated individuals across multiple teams and countries. There are countless opportunities to learn new skills and develop in your career and we’ll provide the support you need to do just that.
What we hope you’ll do next:
Choose ‘Apply now’ to fill out our short application, so that we can find out more about you.
We’re an equal opportunity employer, which means we’ll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and their passion and we’re committed to creating an inclusive environment for all employees.
Candidates must have the relevant work rights to be considered for an opportunity at Link Group. Successful applicants will be required to complete background screening prior to commencement of employment.
Our continued investment in our proprietary technology platforms allows us to automate wealth management workflows, manage large consumer and member bases, and provide insights through predictive analytics.
By focussing on product and service innovation, our Technology division has evolved to become an innovative provider of solutions, identifying and anticipating the needs of clients across Link Group.
Link Group is building a dynamic, client focused, caring and inclusive culture that is built on the foundations of an entrepreneurial spirit, effective risk management, empathy and trust, and underpinned by its core values.
We are an inclusive employer whose people work collaboratively. We encourage, support and value the various talents and perspectives of our people and promote a flexible and blended work environment where our people can thrive and their wellbeing is supported. We know that diversity drives better client outcomes, continuous improvement, and growth. Be part of the Link Group journey and together we will achieve our full potential.
We treat all individuals fairly and equitably and do not discriminate on the basis of diverse characteristics including, but not limited to gender, gender identity, sexual orientation, age, ethnicity, cultural background, physical abilities/disabilities, religious or political belief, marital or family status or carers responsibilities.
Candidates must have the relevant work rights to be considered for an opportunity at Link Group. Successful applicants will be required to complete background screening prior to commencement of employment.
