Job Description
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