At a Glance
- Tasks: Manage and support SQL databases, ensuring performance, availability, and security.
- Company: Join a leading global law firm with a strong reputation in the legal sector.
- Benefits: Enjoy a permanent role with opportunities for professional growth and development.
- Other info: Ideal for tech-savvy individuals looking to make a difference in a prestigious firm.
- Why this job: Be part of a dynamic team, contributing to impactful projects in a collaborative environment.
- Qualifications: Proven experience with SQL 2019/2022 and database administration in enterprise systems required.
The predicted salary is between 36000 - 60000 £ per year.
Job Description
Database Administrator - SQL, SQL Server, SQL Server 2019/2022, SSIS
Our leading global law firm client are looking to recruit a Database Administrator (SQL, SQL Server, SQL Server 2019/2022, SSIS) on a permanent basis to be responsible for taking ownership and managing and supporting the Firm’s SQL databases, ensuring performance, availability and security, working under the direction of the Senior Database Administrator.
As the firms SQL DBA you will also provide high level database administration expertise to the Application Development, Application Support, Finance Systems, Data Architecture and Insights and Infrasutructre Teams.
What you'll do as the firms Database Administrator - SQL, SQL Server, SQL Server 2019/2022, SSIS:
- Responsible for ensuring availability and performance of the databases that the support the Firms systems.
- Ensure that the associated hardware resources allocated to the databases are constantly measured to ensure high availability and optimum performance.
- To proactively monitor the database systems to ensure secure services with minimum downtime.
- Review trend analysis to enable informed decisions regarding resource management.
- Promote data consistency and standardization.
- Assist project teams with applying coding standards to Stored Procedures, SSIS
- Packages and scripts and assist in resolving integration issues.
- Maintain a backup and recovery strategy for database information and restore the database as required.
- Develop database support utilities, scripts and tools.
- Plan for future storage capacity requirements for the server and databases.
- Responsible for improvement and maintenance of the databases to include rollout and upgrades.
- Review and recommend new technologies and best practices to ensure consistent and stable databases and servers.
Essential skills required for this Database Administrator - SQL, SQL Server, SQL Server 2019/2022, SSIS opportunity:
- Proven SQL 2019/2022 database administration experience.
- Experience of managing multiple SQL RDBMS on large enterprise systems.
- Practical experience in monitoring and tuning a database to provide a high availability service.
- Excellent SQL Server 2019/2022 in a Windows 2022/2025 environment, with experience in T-SQL including Views, Stored Procedures, etc.
- Sound knowledge of SQL Reporting Services, PowerBI, SSIS & SSAS.
- Extensive knowledge of SQL Availability groups (including contained availability groups).
- Extensive knowledge of SQL features including query store, SSIS Catalog, encryption and enhanced security.
- Ability to develop SSIS packages using Visual Studio.
- Proven experience developing data extraction processes to external SFTP sites.
- Good knowledge of Windows, Windows Clustering and Active Directory.
- Any other RDBMS experience or Azure
- Experience of SQL monitoring tools such as Redgate.
- Knowledge or experience of legal solutions such as iManage, Aderant, IntApp.
- Experience of working in a global law firm.
Database Administrator - SQL, SQL Server, SQL Server 2019/2022, SSIS in London employer: Precise Placements
Join a prestigious global law firm that values innovation and excellence, offering a dynamic work environment where your expertise as a Database Administrator will be pivotal in ensuring the performance and security of critical SQL databases. With a strong commitment to employee development, you will have access to continuous learning opportunities and the chance to collaborate with diverse teams across the organisation, all while enjoying a supportive culture that prioritises work-life balance and professional growth.
StudySmarter Expert Advice🤫
We think this is how you could land Database Administrator - SQL, SQL Server, SQL Server 2019/2022, SSIS in London
✨Tip Number 1
Familiarise yourself with the specific SQL Server versions mentioned in the job description, particularly SQL Server 2019 and 2022. Having hands-on experience or relevant projects to discuss can really set you apart during interviews.
✨Tip Number 2
Network with professionals in the legal tech industry, especially those who work with SQL databases. Attend relevant meetups or webinars to gain insights and potentially get referrals that could help you land the job.
✨Tip Number 3
Showcase your problem-solving skills by preparing examples of how you've improved database performance or resolved issues in past roles. Be ready to discuss these scenarios in detail during your interview.
✨Tip Number 4
Stay updated on the latest trends and best practices in database administration, particularly around security and performance optimisation. This knowledge will not only help you in interviews but also demonstrate your commitment to continuous learning.
We think you need these skills to ace Database Administrator - SQL, SQL Server, SQL Server 2019/2022, SSIS in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with SQL Server 2019/2022, SSIS, and any relevant database administration skills. Use specific examples of your past work to demonstrate your expertise in managing SQL databases.
Craft a Strong Cover Letter:In your cover letter, explain why you are interested in the Database Administrator position and how your skills align with the job requirements. Mention your experience with high availability services and any relevant technologies like SQL Reporting Services or PowerBI.
Showcase Relevant Projects:If you've worked on projects involving database management, include them in your application. Detail your role, the technologies used, and the outcomes achieved, especially if they relate to the legal sector or large enterprise systems.
Proofread Your Application:Before submitting, 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 Database Administrator role.
How to prepare for a job interview at Precise Placements
✨Showcase Your SQL Expertise
Be prepared to discuss your experience with SQL Server 2019/2022 in detail. Highlight specific projects where you managed databases, focusing on performance tuning and high availability. This will demonstrate your technical proficiency and relevance to the role.
✨Understand the Firm's Needs
Research the law firm and its operations. Understand how their database systems support their business processes. Tailor your answers to show how your skills can directly benefit their specific needs, especially in terms of security and data consistency.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving abilities. Prepare to discuss scenarios where you had to troubleshoot database issues or implement backup strategies. Use the STAR method (Situation, Task, Action, Result) to structure your responses effectively.
✨Demonstrate Team Collaboration Skills
As a Database Administrator, you'll work with various teams. Be ready to share examples of how you've collaborated with application development or support teams in the past. Emphasise your ability to communicate technical concepts clearly to non-technical stakeholders.
