Job Summary:
To be a part of the their Customer Support SQL Server Team to improve, maintain and support their Microsoft SQL Server databases. This will include performance tuning of production databases, designing new database structures, data migration, initial database configuration and operational support of live systems.
Essential Job Duties and Responsibilities:
- Responsible for all Business system SQL Servers, and associated test and development systems.
- Identify opportunities for automation, optimisation of operational processes to improve the reliability and efficiency of the SQL Server team.
- Support and maintenance of mission critical SQL Server databases.
- Providing support to the application development team for review of SQL, stored procedures, database structures and processes.
- SQL Server upgrades and migrations.
- Integration of different business systems to form automated data flows.
- Disaster recovery design, planning and testing. Supervision of system backups. Experience with SQL High Availability, AlwaysOn and Windows Clustering.
- Manage, implement and test Business Continuity and disaster recovery strategies.
- Proactively monitor production and test systems to identify system issues (e.g. SCCM).
- Analyse and troubleshoot production faults and determine the most effective course as a subject matter expert in an expedited manner.
- Managing the security of database systems and working with security auditors where required.
- Perform day to day system administration (such as user creation, resolving alerts, troubleshooting, etc.) of both SQL Server and reporting systems.
- Maintaining IT documentation.
- To ensure all work is carried out with reference to their Customer Support department work instructions and standards following industry best practice.
- In addition to the duties and responsibilities listed, the job holder is required to perform other duties assigned by the Supervisor/Manager from time-to-time, as may be reasonably required of them.
- The candidate may be required to occasionally work on other company sites.
- Provide support, including out-of-hours support in critical incidents and participation in an on-call support rota. The on-call support responsibility is typically a whole week at a time and is one week in four. Holidays must be arranged around on-call support responsibilities.
Minimum Job Requirements:
Skills knowledge and experience:
- 4 Years experience of SQL Server up to SQL 2016, preferably SQL 2019
- MS SQL Server MCTSMCSE
- Formal training in Database Administration
Optional knowledge and experience:
Any knowledge of MySQL, DB2 andor Postgres