At a Glance
- Tasks: Manage and optimise SQL Server databases for a leading investment bank.
- Company: International bank located in the vibrant Canary Wharf, London.
- Benefits: Competitive salary, negotiable between £55K – £70K, plus additional benefits.
- Why this job: Join a dynamic team and enhance your skills in a fast-paced financial environment.
- Qualifications: 5-7 years of experience as an MS SQL Server DBA with strong T-SQL skills.
- Other info: Opportunity to work on cutting-edge database technologies and grow your career.
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–7 years of 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 an MS SQL Server DBA with Application Support you will be involved with developing and implementing solutions for the bank’s financial systems.
Responsibilities
- Ensure the integrity, security and accuracy of the 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.
- Configuration and operation of clustered database servers using external storage.
- Scripting stored procedures.
- Security concepts of database management.
- Change management concepts and application.
Qualifications
- At least 5 to 7 years of solid expertise as a MS SQL Server DBA – Database Administrator.
- Experience with Microsoft SQL Server Administration (Enterprise Edition).
- High level T‑SQL programming (SPs, Functions, Triggers).
- Operation, design and implementation experience of Mirroring, Log Shipping and SQL Server Replication.
- SQL Reporting Services and Analysis Services maintenance and tuning.
Salary and Benefits
Salary for this role is negotiable and is expected to be in the range £55K – £70K + benefits.
Application
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
Network like a pro! Reach out to your connections in the finance and tech sectors, especially those who work in investment banks. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Prepare a portfolio or a presentation that highlights your experience with MS SQL Server and any successful projects you've worked on. This will help you stand out during interviews and discussions.
✨Tip Number 3
Practice makes perfect! Brush up on your T-SQL programming and database management concepts. You never know when a technical question might pop up, so being prepared can give you the edge you need.
✨Tip Number 4
Apply through our website! We make it super easy for you to submit your application directly. Plus, it shows you're serious about the role and want to be part of our team at StudySmarter.
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 a MS SQL Server DBA. We want to see how your skills match the job description, so don’t be shy about showcasing your 5-7 years of expertise and any relevant projects you've worked on.
Showcase Your Skills: When writing your application, emphasise your T-SQL programming skills and any experience with database management concepts like Mirroring and Log Shipping. We love seeing specific examples that demonstrate your technical prowess!
Keep It Professional: Even though we’re keeping it informal here, your written application should maintain a professional tone. Use clear language and avoid jargon unless it’s relevant to the role. Remember, first impressions count!
Apply Through Our Website: We encourage you to apply directly through our website. It makes the process smoother for both you and us, and ensures your application gets to the right place quickly. Don’t forget to send your CV in MS Word format!
How to prepare for a job interview at Jas Gujral
✨Know Your SQL Inside Out
Make sure you brush up on your MS SQL Server skills, especially T-SQL programming. Be ready to discuss your experience with stored procedures, functions, and triggers, as well as any specific projects where you've implemented these skills.
✨Understand the Bank's Needs
Research the investment bank's operations and how they use databases. Familiarise yourself with concepts like data warehousing, mirroring, log shipping, and replication, as these are crucial for the role. Showing that you understand their business will set you apart.
✨Prepare for Scenario Questions
Expect questions about how you would handle database integrity, security, and performance issues. Think of real-life examples from your past experiences where you successfully resolved similar challenges, and be ready to explain your thought process.
✨Documentation is Key
Highlight your experience in maintaining high-quality documentation for database environments. Be prepared to discuss how you ensure that operational procedures are clear and accessible, as this is vital for collaboration and support within the team.