At a Glance
- Tasks: Support and optimise key database systems for a leading law firm.
- Company: Join A&O Shearman, a top-tier global law firm with a collaborative environment.
- Benefits: Competitive salary, professional development, and opportunities for remote work.
- Other info: Dynamic role with opportunities for growth and learning in a tech-driven environment.
- Why this job: Make a real impact by ensuring the performance of critical applications.
- Qualifications: Experience with SQL, Azure, and strong communication skills required.
The predicted salary is between 63000 - 77000 £ per year.
You will support key databases for applications used by A&O Shearman that keep the firm running. These include the firm's finance and customer relationship management systems, as well as business intake and time capture. You will support other business-critical applications, including file transfer, legal technology, and various application services. You will work with 3rd parties who provide expertise in these systems. The firm's database infrastructure, MS-SQL, will also be supported by you. You will also support the Dynamics365 platform and applications built on it. Application servers and databases are a mixture of on-premises and SaaS/cloud-hosted.
As well as supporting the database stack, you will package, configure, test, and deploy applications to the firm. You will work with other service support teams in I&O, including End-User Compute, Infrastructure, and Networks, to provide a world-class service to our business. You will also work with our global service desk, regional support teams, and the global IT department. You will provide technical database expertise on projects when required.
What you will do:- Provide availability, scalability, and performance of all application database systems through data metrics.
- Capture, analyse database metrics and bring forward improvements of database systems.
- Identify, design, and implement robust monitoring alerts to identify potential issues early.
- Maintain core database infrastructure servers in Azure, AVS, and on-premises.
- Develop backup/restore procedures for major databases to ensure data integrity.
- Develop and leverage automation procedures to turn repeatable actions into automated processes.
- Analyse database capacity metrics on all server infrastructure.
- Provide expertise for database engineering to optimise database migrations, queries, and performance.
- Management and monitoring of SQL availability groups and clustered SQL servers.
- Lead in database-related projects and ensure timely delivery.
- Analyse and use data to identify and prioritise operations to find root causes of major issues.
- Participate in on-call and out-of-hours support for both application and databases.
- Knowledge and use of DevOps and GitHub and other collaboration tool sets.
- Support maintenance reviews, vulnerability assessments of MS SQL.
- Ability to work independently and good communication skills.
- Document and knowledge share learnings to the wider team with the ability to multi-task including team upskilling.
- Experience with programming languages including PowerShell, SQL, Linux preferred.
- Collaborate with other engineering teams on production changes, incidents, and problem management.
- Proficient Microsoft SQL Azure Server and SQL infrastructure.
- AZ-900 Azure Fundamentals and DP-900 Azure Data Fundamentals preferred.
- SQL AG, Clustering, and high availability features experience.
- SQL and PowerShell scripting experience.
- SQL and server performance tuning.
- SQL Replication performance and monitoring tuning.
- Understanding of Linux server management.
Database Administrator TLNT1_NI in Antrim employer: IrishJobs
As a Waste Resource Team Leader with our esteemed local authority client, you will be part of a dedicated team committed to enhancing community sustainability and environmental responsibility. Our organisation fosters a supportive work culture that prioritises employee development, offering training opportunities and a clear path for career progression. With competitive remuneration, including pension and holiday pay, along with the chance to make a meaningful impact in your community, this role is an excellent opportunity for those seeking rewarding employment in the public sector.
StudySmarter Expert Advice🤫
We think this is how you could land Database Administrator TLNT1_NI in Antrim
✨Tap into Local Tech Meetups
Get yourself to local tech meetups or database management conferences. It's a really great way to meet industry professionals and potentially uncover unadvertised full-time roles. When chatting with people, mention your skills and interests in database management; you never know who might be looking for someone just like you!
✨Contribute to Open Source Projects
Diving into open-source projects can not only sharpen your database skills but also get you noticed by employers. Many companies look for candidates who actively contribute to projects – it shows initiative and a real passion for the field. Plus, it's a perfect excuse to connect with other developers and expand your professional network.
✨Utilise Professional Bodies
Sign up for professional bodies related to database management, like the British Computer Society. They often host events and networking opportunities that can lead directly to job openings in the full-time market. Plus, it adds a nice touch to your professional profile!
✨Showcase Your Skills in a Public Portfolio
As you’re on the hunt for that full-time role, make sure to have a public portfolio that displays your best database projects. This can easily set you apart from the competition. And when you apply for roles, definitely mention it – it shows employers you mean business and are proud of your work!
We think you need these skills to ace Database Administrator TLNT1_NI in Antrim
Some tips for your application 🫡
Show off your database skills:When applying for a full-time role in database management, it’s super important to highlight your skills with specific database technologies like SQL, NoSQL, or any relevant data visualisation tools. We want to see how you've used these tools in real projects, so don't shy away from detailing your hands-on experience!
Tailor your CV for data:Make sure your CV is structured clearly, focusing on your previous experience in database management. Use specific metrics to demonstrate your impact, like how you improved data retrieval times or reduced errors. This isn't just about what you've done; it’s about what you’ve achieved with your skills!
Craft a compelling cover letter:In your cover letter, share what excites you about database management and how you can contribute to IrishJobs. Mention any relevant projects where you tackled challenges or implemented new solutions. Let us know why you want to join our team and how your passion aligns with our goals.
Document your projects:If you've worked on interesting database projects—maybe during your studies or in previous roles—be sure to include those in your application. If you can, link to a portfolio or GitHub repo where we can see examples of your work. Having a tangible showcase of your skills will really make your application stand out!
How to prepare for a job interview at IrishJobs
✨Brush Up on Database Tools
Make sure you're well-versed with popular database management systems like MySQL, PostgreSQL, or MongoDB. Incorporating real-world examples of how you've used these tools in past projects will show that you can put theory into practice, which is something IrishJobs will definitely appreciate.
✨Know Your SQL Inside Out
Get ready for some technical questions focused on SQL queries and database design. We should anticipate coding challenges where you might need to optimise queries or design a database schema on the spot. Practising these problems will build our confidence to impress in the interview.
✨Demonstrate Problem-Solving Skills
Besides just technical know-how, be prepared to answer scenario-based questions that test your critical thinking and problem-solving abilities. Think about how you would approach data integrity issues or handle performance bottlenecks — IrishJobs will want to see your analytical side!
✨Show Your Collaboration Spirit
Since this is a full-time role, it's crucial to highlight how you've collaborated with cross-functional teams or contributed to team projects in the past. Emphasising our interpersonal skills will demonstrate that you’re not just a tech wizard, but also a team player who fits well with IrishJobs's culture.
