Job Description
Overview
The 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.
Key Accountabilities and Main Responsibilities
Accountable:
• 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 Attributes
• Demonstrable knowledge of database administration (design, installation & 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
Desirable
• Database performance and optimisation experience
• Experience working with automation deployment tools.
• Ability to develop and implement data security guidelines while making data available to those authorised to have access
• Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies
• Ability to database design, implementation and performance tune
• Experience in automated testing of all database releases
• Experience in support for all database releases.
• Experience of supporting large scale critical production databases.
Competencies
• Innovation, change and continuous improvement
• Communication
• Results focused
• Technical awareness
• Commercial awareness
Desirable
• Leadership and performance
• Customer service
• Team working
• Risk and conduct management
Link Group is a leading fund administration and share registry specialist. We are a market leading provider of technology-enabled administration solutions, continually developing our offerings to expand with our clients' needs. Since our inception, Link Group has been entrusted by clients to handle sensitive data in a secure and confidential manner. Our core businesses of fund administration and securities registration are complemented by our expertise in digital solutions and data analytics.
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, ****** 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
The 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.
Key Accountabilities and Main Responsibilities
Accountable:
• 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 Attributes
• Demonstrable knowledge of database administration (design, installation & 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
Desirable
• Database performance and optimisation experience
• Experience working with automation deployment tools.
• Ability to develop and implement data security guidelines while making data available to those authorised to have access
• Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies
• Ability to database design, implementation and performance tune
• Experience in automated testing of all database releases
• Experience in support for all database releases.
• Experience of supporting large scale critical production databases.
Competencies
• Innovation, change and continuous improvement
• Communication
• Results focused
• Technical awareness
• Commercial awareness
Desirable
• Leadership and performance
• Customer service
• Team working
• Risk and conduct management
Link Group is a leading fund administration and share registry specialist. We are a market leading provider of technology-enabled administration solutions, continually developing our offerings to expand with our clients' needs. Since our inception, Link Group has been entrusted by clients to handle sensitive data in a secure and confidential manner. Our core businesses of fund administration and securities registration are complemented by our expertise in digital solutions and data analytics.
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, ****** 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
💡 Quick Summary
Seeking a career-building opportunity? The SQL DBA position is now open for candidates interested in the Database Administrator sector. This role in Mumbai offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
