At a Glance
- Tasks: Manage and optimise MS SQL Server databases for financial systems.
- Company: Join an international bank located in the vibrant Canary Wharf, London.
- Benefits: Enjoy a competitive salary of £55K - £70K plus additional perks.
- Why this job: Be part of a dynamic team enhancing financial applications with cutting-edge technology.
- Qualifications: 5-7 years of experience as a MS SQL Server DBA is essential.
- Other info: Opportunity to work in a fast-paced environment with a focus on data integrity.
The predicted salary is between 55000 - 70000 £ per year.
Our Client is an International Bank with offices in Canary Wharf London. They are now looking to recruit a Senior MS SQL Server DBA with at least 5 years expertise. Although the role is for a Senior MS SQL Server DBA, the Client would like you to have a background in Data Warehousing.
As MS SQL Server DBA with Application Support, you will be involved with developing and implementing solutions for the bank's financial systems. The role will involve the following:
- Ensure the integrity, security and accuracy of production database environment, ensuring good performance of the dependent applications.
- Plan and implement operating procedures for backup of database and recovery of database information.
- Develop database-related application development standards covering database creation, software placement, storage and auditing.
- Ensure the integrity of the recovery system at all times.
- Initiate formal testing of the recovery system.
- Develop database procedures as necessary to enhance the application suite as required.
- Respond to, resolve and document support calls for the production and test applications.
- Maintain to a high standard documentation supporting the build, maintenance and operational procedures of the database environment.
- Act as the technical liaison between database operations and vendor support.
- Perform other related duties as assigned.
You must have at least 5 to 7 years solid expertise as a MS SQL Server DBA – Database Administrator. Must have the Microsoft SQL Server Administration (Enterprise Edition) experience. High Level T-SQL programming (SP, Functions, Triggers). Operation, design and implementation experience of Mirroring, Log Shipping and SQL Server Replication. SQL Reporting services and Analysis services maintenance and tuning. Configuration and operation of clustered database Servers using external storage. Scripting stored procedures. Security concepts of database management. Change management concepts and application.
The role will be to work as a MS SQL DBA with an element of supporting financial applications. Salary for this role is negotiable - but is expected to be in the range £55K - £70K + benefits. Please send your CV’s to us in MS Word format.
MS SQL Server DBA Database Administrator – Investment Bank – Canary Wharf - London employer: Jas Gujral
Contact Detail:
Jas Gujral Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land MS SQL Server DBA Database Administrator – Investment Bank – Canary Wharf - London
✨Tip Number 1
Make sure to brush up on your T-SQL programming skills, especially with stored procedures, functions, and triggers. Being able to demonstrate your expertise in these areas during discussions will set you apart from other candidates.
✨Tip Number 2
Familiarise yourself with the specific database technologies mentioned in the job description, such as Mirroring, Log Shipping, and SQL Server Replication. Having practical examples of how you've implemented these in past roles can really impress the hiring team.
✨Tip Number 3
Network with professionals in the investment banking sector, particularly those who work with MS SQL Server. Engaging in conversations about industry trends and challenges can provide valuable insights and potentially lead to referrals.
✨Tip Number 4
Prepare to discuss your experience with database security concepts and change management. Be ready to share specific instances where you've successfully managed these aspects, as they are crucial for the role.
We think you need these skills to ace MS SQL Server DBA Database Administrator – Investment Bank – Canary Wharf - London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience as an MS SQL Server DBA, particularly focusing on your 5 to 7 years of expertise. Include specific examples of your work with Data Warehousing, T-SQL programming, and any relevant projects that demonstrate your skills.
Craft a Strong Cover Letter: Write a cover letter that addresses the key responsibilities mentioned in the job description. Emphasise your ability to ensure database integrity, security, and performance, and mention your experience with backup procedures and recovery systems.
Highlight Relevant Skills: In your application, clearly list your technical skills related to Microsoft SQL Server Administration, including Mirroring, Log Shipping, SQL Server Replication, and any experience with SQL Reporting Services and Analysis Services. This will show you meet the specific requirements of the role.
Proofread Your Application: Before submitting your application, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a role involving database management.
How to prepare for a job interview at Jas Gujral
✨Showcase Your SQL Expertise
Be prepared to discuss your experience with MS SQL Server in detail. Highlight specific projects where you implemented solutions, focusing on T-SQL programming, mirroring, log shipping, and replication. This will demonstrate your technical proficiency and relevance to the role.
✨Understand Data Warehousing Concepts
Since the client values a background in data warehousing, brush up on key concepts and practices. Be ready to explain how you've applied these principles in past roles, particularly in relation to database integrity and performance.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving skills. Think of examples where you had to troubleshoot database issues or implement backup and recovery procedures. This will show your practical knowledge and ability to handle real-world challenges.
✨Emphasise Documentation Skills
The role requires maintaining high standards of documentation. Be ready to discuss your approach to documenting processes and procedures. Providing examples of how your documentation has improved team efficiency or compliance can set you apart.