SQL DBA (NHS)
Senior SQL DBA (NHS)
London – hybrid working
£350.00 – £400.00 per day
IR35 – outside
Start asap
Initially 3 months
Are you an experienced Senior SQL DBA looking for your next assignment? My client is a NHS organisation based in London. They require a skilled DBA to join their team for an initial 3 month assignment. This role is outside of IR35, hybrid working and starting ASAP.
The role:
To work with the team as an experienced Advanced SQL Database Administrator to be responsible for creating and supporting the SQL Farm and improving the availability and resilience of the IT Infrastructure. The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.
Expertise required:
- Performance Tuning and Optimization:
- Analysing and optimizing database performance using SQL Profiler, Execution Plans, and Dynamic Management Views (DMVs).
- Implementing indexing strategies, query optimization, and troubleshooting performance bottlenecks.
- High Availability and Disaster Recovery:
- Designing and implementing high availability solutions such as SQL Server Always On Availability Groups, Failover Clustering, and Database Mirroring.
- Setting up and maintaining disaster recovery plans, including database backups, log shipping, and point-in-time recovery.
- Security Management:
- Ensuring database security through user roles, permissions, and encryption techniques.
- Implementing auditing and compliance measures to meet regulatory requirements.
- Automation and Scripting:
- Automating routine tasks and maintenance using PowerShell, T-SQL scripts, and SQL Server Agent Jobs.
- Developing scripts to automate the deployment of database changes and monitor database health.
- Dashboard Implementation for all SQL farms for monitoring performance and issues
- Database Design and Architecture:
- Involved in database schema design, normalization, and indexing strategies.
- Collaborating with developers especially BI team to design efficient and scalable database solutions.
- Capacity Planning and Monitoring:
- Forecasting future database growth and resource needs.
- Setting up monitoring tools and alerts for database health and performance.
- Data Integration and ETL Processes:
- Designing and managing ETL processes using SQL Server Integration Services (SSIS).
- Ensuring data integrity and consistency across different systems.
- Upgrades and Patching:
- Planning and executing SQL Server upgrades and applying patches.
- Testing and validating the impact of upgrades on applications and performance.
- Troubleshooting and Support:
- Providing advanced support for complex database issues.
- Analysing and resolving incidents related to database availability, integrity, and performance
- Collaboration and Communication:
- Working closely with development teams, network administrators, and other stakeholders.
- Communicating complex technical issues to non-technical stakeholders effectively.
- Documentation and Standards:
- Maintaining comprehensive documentation of database configurations, processes, and policies.
- Establishing and enforcing database standards and best practices.
- Knowledge Transfer:
- Staying updated with the latest SQL Server features, tools, and best practices.
- Participating in knowledge transfer, team workshops, and providing professional development activities.
Overall, advanced Windows SQL DBA roles require a mix of technical expertise, problem-solving skills, and a proactive approach to managing and optimizing database environments.
Please apply via the link to be considered.
Talent International UK Limited and it’s subsidary Rethink Digital Gurus Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this opportunity, you accept the T&C’s, Privacy Policy and Disclaimers which can be found at talentinternational.co.uk