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.
Functional title - Infrastructure DB Support
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 in London 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 in London
✨Tip Number 1
Network like a pro! Get out there and connect with people in the industry. Attend meetups, webinars, or even just grab a coffee with someone who works in database support. You never know who might have a lead on your dream job!
✨Tip Number 2
Show off your skills! If you’ve got experience with SQL Server or AWS, don’t be shy about it. Create a portfolio or a personal project that highlights your expertise. This can really set you apart when chatting with potential employers.
✨Tip Number 3
Prepare for those interviews! Research common questions related to operational support and database management. Practice your answers, especially around problem-solving scenarios. We want you to feel confident and ready to impress!
✨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. So, what are you waiting for? Get applying!
We think you need these skills to ace Assistant Vice President, Infrastructure DB Support in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Assistant Vice President role. Highlight your operational support experience with Microsoft SQL Server and any relevant projects you've worked on. We want to see how your skills match what we're looking for!
Showcase Your Problem-Solving Skills:In your application, don’t shy away from sharing examples of how you've tackled complex database issues. We love candidates who can demonstrate strong analytical skills and a proactive approach to problem management.
Be Clear and Concise:When writing your cover letter, keep it clear and to the point. Explain why you're interested in the role and how your experience aligns with our needs. We appreciate straightforward communication!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
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.
