At a Glance
- Tasks: Provide senior support for Microsoft SQL databases in a dynamic 24/7 environment.
- Company: Join a leading financial services firm in London with a focus on innovation.
- Benefits: Competitive salary, flexible working hours, and opportunities for professional growth.
- Other info: Collaborative team culture with opportunities for continuous learning and development.
- Why this job: Make a real impact by optimising database performance and supporting critical business operations.
- Qualifications: Strong experience in Microsoft SQL Server and operational support in enterprise environments.
The predicted salary is between 60000 - 80000 £ per year.
Department - Infrastructure Management
Report to - Nigel Cantrell
Location - London
What you will be doing:
- Provide senior support for the database team and operational support for the CLS internal Microsoft SQL database infrastructure and systems in the company’s 24x7 hosted environment.
- Provide remote and on-site support as part of the on-call support Rota.
- Work closely with other support teams to ensure that the database environments are fully supported and maintained in order to meet the needs of the business.
Strategic
- Ensure CLS internal database systems are managed to the highest standard by following industry best practice.
- Identify database best practices to meet internal customer requirements that maximise the performance and reliability of the database management systems.
- Recommend performance and efficiency improvements for databases systems across the organisation.
- Assist in the research and review of new database feature-functionality, support proof-of-concept evaluations and enhancements to existing solutions.
- Demonstrate good problem management ownership and prevention of SLA breach under Incident / Problem Management processes.
- Actively contribute to the development of existing and new IT process and procedures to enhance service transition and service operation lifecycle stages.
- Demonstrate self-starter capabilities identifying areas of improvement and taking action in order to address.
Operational
- Provide Senior Operational Support for the Windows / SQL Server and Postgres database environment.
- Responsibilities include - Database monitoring, backup / restores, develop, and maintain daily automated checks/maintenance tasks, performance, and capacity management, creating optimisation plans and building new database instances, applying service packs and planning/performing database migrations.
- Manage and escalate as appropriate.
- Provide technical leadership and represent team on design and solutioning meetings.
- Investigate and progress Incident, Service Request and Problem tickets. Manage and escalate as appropriate.
- Monitor, Support, and deploy ETL jobs and SSIS packages.
- Configure and manage RDS instances (AWS).
- Work with internal CLS teams (including ETL team and Quantitative Analysis Group) and external vendors to identify/propose solutions and support any fixes that are required as part of service improvement.
- Implement and maintain security policies and auditing compliance at the database level to ensure the protection of the firm’s sensitive data.
- Develop and adhere to patch management and upgrade strategies.
- Follow the CLS Change Management procedure and other standard practices in installing, configuring and supporting databases and related items in Test and Production environments.
- Ensure that the BAU Service is prioritised and all faults, incidents and problems are responded to in an efficient manner without negatively impacting SLAs and reporting metrics in place.
- Upgrade or maintain software at a time when the impact to the business is minimised.
- Execute the failover for the database and application services as required. Maintain failover scripts and propose performance and efficiency improvements.
- Participate in regular on-site Disaster Recovery testing activities (up to 4 tests per year).
- Create, maintain, and review operational process and support documentation.
- Provide 24/7 on-call cover on a rotational shift basis. Participate in planned weekend work as required.
- As required, provide representation for DBA team’s Changes at the daily stand-up and weekly CAB meetings. Ensure other team’s Changes do not have an impact on the delivery of the database services.
What we’re looking for:
- Must have strong Operational Support experience of Microsoft SQL Server in an Enterprise Windows environment.
- Must have a solid understanding of database disaster recovery technologies including SAN / Mirroring / Always-On / SQL replication.
- Knowledge of database structure languages, such as SQL.
- Experience working in AWS platform and utilising RDS, SQL Server and Postgres.
- Operational DBA support experience on PostgresSQL.
- Experience assigning BAU and project work to team ensuring deadlines are met.
- Ability to plan and implement technical changes without unexpected disruption to the service and with minimal oversight.
- Experience of providing production support activities for business-critical databases / applications.
- Strong documentation and technical writing skills.
- Must have excellent analytical and problem-solving skills.
- Experience in working with ticket systems such as ServiceNow and a solid understanding of service priorities and SLAs.
- Strong experience of providing cross training on technologies and operational processes to colleagues.
- Ability to collaborate effectively with other technical and business teams to support the service.
- Have excellent time management and organisational skills.
- Knowledge of ITIL framework (good understanding of Incident, Problem, Change processes).
- Knowledge of Banking systems and related industry standard practices.
- Experience in working and configuring monitoring systems such as Dynatrace.
- PowerShell scripting experience.
- Experience with Microsoft SQL Server Integration Services (SSIS).
- Knowledge of EMC Networker / Rubrik.
- Bachelor’s degree or equivalent.
- Prior IT Operational Support experience across business-critical Production infrastructure, applications, and database services.
- Microsoft SQL 2016, 2019, 2022 certification.
Assistant Vice President, Infrastructure DB Support employer: CLS Group
At CLS, we pride ourselves on being an exceptional employer, offering a dynamic work environment in the heart of London where innovation and collaboration thrive. Our commitment to employee growth is evident through continuous training opportunities and a culture that encourages proactive problem-solving and strategic thinking. With a focus on maintaining the highest standards in database management, we provide our team with the tools and support needed to excel in their roles while enjoying the benefits of a 24/7 operational environment.
StudySmarter Expert Advice🤫
We think this is how you could land Assistant Vice President, Infrastructure DB Support
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or at industry events. We all know that sometimes it’s not just what you know, but who you know that can help you land that dream job.
✨Tip Number 2
Prepare for those interviews! Research the company and the role thoroughly. We want you to be able to showcase how your skills in operational support and database management make you the perfect fit for the team.
✨Tip Number 3
Practice makes perfect! Do mock interviews with friends or use online platforms. We suggest focusing on common questions related to SQL Server and operational support to boost your confidence.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Assistant Vice President, Infrastructure DB Support
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the role of Assistant Vice President, Infrastructure DB Support. Highlight your operational support experience with Microsoft SQL Server and any relevant projects you've worked on that align with the job description.
Showcase Your Skills:Don’t forget to showcase your technical skills! Mention your experience with AWS, Postgres, and any disaster recovery technologies you’ve worked with. We want to see how you can contribute to our database environments.
Be Clear and Concise:When writing your application, be clear and concise. Use bullet points where possible to make it easy for us to read through your qualifications and experiences. We appreciate a well-structured application!
Apply Through Our Website:Finally, make sure to apply through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to see what you bring to the table!
How to prepare for a job interview at CLS Group
✨Know Your Databases Inside Out
Make sure you brush up on your knowledge of Microsoft SQL Server and Postgres. Be ready to discuss your operational support experience, including disaster recovery technologies and performance optimisation strategies. This will show that you’re not just familiar with the systems but can also contribute to their improvement.
✨Demonstrate Problem-Solving Skills
Prepare to share specific examples of how you've tackled database issues in the past. Think about incidents where you prevented SLA breaches or improved service delivery. This will highlight your analytical skills and ability to manage problems effectively.
✨Familiarise Yourself with AWS and RDS
Since the role involves working with AWS and RDS instances, make sure you understand how these platforms work. Be ready to discuss any relevant experience you have, especially around monitoring and deploying ETL jobs. This will show that you can hit the ground running.
✨Show Your Team Spirit
Collaboration is key in this role, so be prepared to talk about how you've worked with other teams in the past. Highlight any experiences where you’ve provided cross-training or supported colleagues in achieving their goals. This will demonstrate your ability to work well within a team environment.
