SQL DBA

Job Description

Company DescriptionLink Group connects millions of people with their assets including equities, pension and superannuation, investments, property and other financial assets. We do this by partnering with thousands of financial market participants to deliver services, solutionsand technology platforms that enhance the user experience and make scaled administration simple. We help manage regulatory complexity, improve data management and provide tools to help people connect to their assets, leveraging analysis, insight and technology.Our core businesses are complemented by our expertise in digital solutions and data analytics, and enable us to provide a complete service to our global network of clients and partners. (Link Asset Services is a member of Link Group.)Our dedicated Technology & Operations division manages day-to-day operations, data processing and information analysis, utilising innovative technology to provide our clients with end to end solutions as well as a range of value-added services. Our continuedinvestment in our proprietary technology platforms allows us to automate wealth management workflows, manage large consumer and member bases or provide insights through predictive analytics. By focussing on product and service innovation, our Technology &Operations division has evolved to become an innovative provider of solutions, identifying and anticipating the needs of clients across Link Group.OverviewThe 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 developmentand 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 whilstbeing 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 possibleservice available to support business processes, including the provision of out of hours on call.Key Accountabilities and Main ResponsibilitiesAccountable:

• For the operational support and continuous improvement of the SQL estate, processes for Development and Test environments (System, Load, Performance, UAT) up to, and including Production;
• Automation, process efficiency and appropriate tooling (Code/Branch Management and Deployment/Configurations) is utilised to reduce cycle times, and improve reliability, audit and traceability for all system deployments across multiple applications;
• Process, best practice and database build standards are consistently applied and constantly improved upon;
• Database health checks, backups and implementation of DBA best practise.

Responsible:

• Development and merging process/methodology is correctly defined and applied to software and systems to minimise risk in Production environments caused by poor code management techniques/skills;
• Provide strong governance for the management, and access, of live data in environments where required (Client Data Take Up) and to ensure obfuscation technologies/practice is embedded;
• Ensuring that, working with DevOps, the Development Team has the right environment to maximise their efficacy and obstacles are removed and automation introduced where appropriate;
• Production environments are protected by governance, good practice/process, design and fit for purpose environments, to the left of Pre-Prod, 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 in agreed timescales;
• Weak points in Process, Technology and Service is addressed through a culture of continual improvement;
• Software and processes are correctly documented to ensure single points of knowledge do not become a problem and skills are distributed across the team and department;
• Ensuring that software Deliverables/Artefacts, as part of any Change/Project, are progressed providing appropriate status reporting and updates as requested by the Line/Project/Change Manager;

Experience & Personal AttributesDemonstrable knowledge of database administration (design, installation & troublesh...