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