Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support and maintain Microsoft SQL Server databases, focusing on query optimisation and programming.
- Company: FNZ is a leading provider of technology and administration services in wealth management globally.
- Benefits: Enjoy opportunities for professional development, flexible working options, and a collaborative team environment.
- Why this job: Join a mission-driven company that empowers individuals to invest in their future with innovative technology.
- Qualifications: Experience with Microsoft SQL Server, performance troubleshooting, and strong problem-solving skills are essential.
- Other info: Work in a dynamic environment with a focus on continuous improvement and innovation.
The predicted salary is between 36000 - 60000 £ per year.
Job Title: SQL DBA
Location: Edinburgh or London
Role Description
This role is technical in nature and focuses on supporting and maintaining Microsoft SQL Server databases. The role has significant query optimization and database programming components as part of the custom FNZ platform development.
Organisational Design
This position is part of the Platform Services – Infrastructure department and reports to the regional Head of Platform Services in the global CIO function.
Team Responsibilities
Availability – applications that are available when the users need them
Performance – applications that scale with user demand
Security – applications that are protected from unauthorised access and data loss
Reliability – applications that are fault tolerant with no single points of failure
Value for money – shared core infrastructure improves application delivery and reduces costs per application
Projects – new system delivery is high quality, on time and within budget
Specific Role Responsibilities
Areas of responsibility: Maintaining and supporting all FNZ platform databases; query optimization; building and supporting new platform instances.
Availability: Ensuring that uptime SLA\’s are met every month; performing scheduled maintenance to minimise disruption; managing third party support contracts where required to provide support levels.
Performance: Ensure that performance SLA\’s are met every month by monitoring system performance, capacity and growth; monitor and optimize queries in test and production environments; suggest and implement performance improvements and hardware refreshes.
Information Security: Ensure that the FNZ databases are internally and externally secure by following existing policies and procedures; implementing security projects; completing risk assessments and build guides for new and existing systems; managing database security and access controls.
Business Continuity: Ensure that FNZ-held data is secure and backed up by ensuring that regular backups have been made; ensuring that any new build is in line with company requirements and departmental policy for resilience and availability; participating in an on-call rota ; contributing to out of hours work
Training: Develop professional and technical knowledge and skills via networking, seminars and other forms of training to meet continuing professional development requirements; work with developers to optimise database performance and operation.
Project Work: Build new platform database instances to a high level of quality, within budget and within deadline; provide regular updates to the Head of Infrastructure.
Budget: Follow the budget approval process; suggest items for budget approval; reduce costs per transaction.
Performance Assessment
Availability – uptime during core and non-core hours
Performance – performance metrics during core and non-core hours
Information Security – quality of documentation and documented proof of adherence to policy
Business Continuity – performance during real DR and recovery events; documented proof of contribution to continuity of service
Training – achieve base skill training targets, cross training within team on SME skills and core systems knowledge as per skills matrix
Projects – planning and documentations; adherence to change principles; number of issues post-implementation, planned vs actual completion time
Budget – cost innovation; automation and process improvement
Experience Required
-
Database administration experience with all recent versions of Microsoft SQL Server (including administration, maintenance, programming, upgrades, installations).
-
Performance troubleshooting in SQL Server and Windows environments.
-
Backup and recovery methods including SQL Server and disk snapshot technologies.
-
HA solutions including database mirroring, logshipping and failover clusters.
-
Administering and maintaining security groups within Windows and SQL Server.
-
Assisting internal teams with SQL Server environmental problems (performance, security, capacity issues etc).
-
Providing consultancy and advice to internal teams with regard to configuration, capacity planning and performance.
-
Work package management including organising resources and obtaining sign off from key stakeholders.
-
Proven ability to work as an individual, with excellent self-management and time management skills.
-
Problem solving capabilities and the ability to multitask and re-prioritise work in a rapidly changing environment.
-
Experience in a dynamic, highly available mission critical production environment.
About FNZ
FNZ is the market leading provider of technology and administration services to major financial institutions in the platform and wealth management sectors across the globe. We partner with life companies, banks, asset managers and discretionary wealth managers to enable them to develop and distribute financial products and services to their customers across all major distribution channels.
About FNZ
FNZ is committed to opening up wealth so that everyone, everywhere can invest in their future on their terms. We know the foundation to do that already exists in the wealth management industry, but complexity holds firms back.
We created wealth’s growth platform to help. We provide a global, end-to-end wealth management platform that integrates modern technology with business and investment operations. All in a regulated financial institution.
We partner with over 650 financial institutions and 12,000 wealth managers, with US$1.7 trillion in assets under administration (AUA).
Together with our customers, we help over 26 million people from all wealth segments to invest in their future.
#J-18808-Ljbffr
Database Administrator (SQL DBA) employer: FNZ
Contact Detail:
FNZ Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database Administrator (SQL DBA)
✨Tip Number 1
Familiarise yourself with the latest versions of Microsoft SQL Server, as well as the specific features mentioned in the job description, such as query optimisation and backup methods. This knowledge will help you stand out during discussions.
✨Tip Number 2
Network with current or former employees of FNZ to gain insights into the company culture and expectations for the Database Administrator role. This can provide you with valuable information that may not be available in the job description.
✨Tip Number 3
Prepare to discuss your experience with high availability solutions like database mirroring and failover clusters. Be ready to share specific examples of how you've implemented these solutions in past roles.
✨Tip Number 4
Demonstrate your problem-solving skills by preparing scenarios where you've successfully managed performance issues or security breaches in SQL Server environments. This will show your ability to handle the challenges outlined in the job description.
We think you need these skills to ace Database Administrator (SQL DBA)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Microsoft SQL Server, including administration, maintenance, and performance troubleshooting. Use specific examples that demonstrate your skills in query optimisation and database programming.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your background aligns with the responsibilities outlined in the job description, particularly in areas like availability, performance, and information security.
Showcase Relevant Experience: When detailing your work experience, focus on your achievements in database administration, especially in high-availability environments. Highlight any projects where you successfully implemented performance improvements or managed security protocols.
Proofread Your Application: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. A polished application reflects your attention to detail, which is crucial for a technical role like this one.
How to prepare for a job interview at FNZ
✨Know Your SQL Inside Out
Make sure you have a solid understanding of Microsoft SQL Server, including its recent versions. Be prepared to discuss your experience with administration, maintenance, and performance troubleshooting, as these are crucial for the role.
✨Demonstrate Problem-Solving Skills
Be ready to showcase your problem-solving capabilities. Prepare examples of how you've tackled performance issues or security challenges in past roles, as this will highlight your ability to handle the dynamic environment of database administration.
✨Understand Business Continuity
Familiarise yourself with backup and recovery methods, as well as high availability solutions like database mirroring and failover clusters. Discussing your knowledge in these areas will show that you can ensure data security and uptime.
✨Showcase Your Teamwork and Communication Skills
Since the role involves working with internal teams and stakeholders, be prepared to talk about your experience in collaboration and communication. Highlight instances where you've provided consultancy or advice to help optimise database performance.
