SQL Database Administrator

Arcas Technology is partnered with a leading healthcare provider based in Ipswich. They are seeking a skilled SQL Database Administrator to join their team on a permanent basis.

You will be fully responsible for overseeing the implementation, configuration, upkeep, and optimisation of essential SQL Server systems, ensuring that applications remain available and perform consistently.

Responsibilities

• Oversee the management of SQL Server databases across various stages of the product lifecycle, from development through to production.
• Handle SQL backups, restores, and collaborate with IT teams as needed to ensure data integrity.
• Manage SQL replication processes, adhering to industry best practices.
• Configure and maintain database servers and associated processes, monitoring system health and performance to ensure optimal operation, availability, and security (covering aspects like memory, CPU, storage, and server uptime).
• Assist in troubleshooting, debugging, and resolving issues related to SQL Servers and T-SQL.
• Streamline and automate routine database maintenance tasks, while tracking and documenting any changes or issues.
• Manage and maintain SSIS, T-SQL scripts, stored procedures, database agent jobs, Windows scheduled tasks, and SQL maintenance plans.
• Provide support to developers by optimising complex queries and refining database schemas.

Skills

• Proficient in MS SQL Server administration.
• Strong understanding of relational database design principles.
• Experience with performance tuning and optimization, utilising SQL Server Profiler and other diagnostic tools.
• Expertise in backup, restore, and recovery processes.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) strategies for SQL Server.
• Familiarity with SQL Server Integration Services (SSIS) and SQL Server Agent jobs.
• Experience with data visualization tools like Power BI.
• Strong SQL programming skills.
• Proficient with Microsoft Office Suite.
• Solid understanding of SQL Server Reporting Services (SSRS).
• Familiarity with additional programming languages, such as R or Python.
• Experience working with Windows Server and SQL Server environments.

If you believe that you are well-suited for this role, we kindly request you to submit your CV to Andy Dale at Arcas Technology.