Job Description
As part of our clients IT Architecture & Engineering team, the SQL DBA/Developer is responsible for support, maintenance and administration of the SQL database servers and databases of our key applications and services, bringing their experience to ensure that business needs are met.
Role Responsibilities
– Management of the database server architecture, including, configuration and maintenance of SQL databases [e.g., SQL Server, Azure SQL].
– Performing DBA administrative tasks including performance monitoring, optimisation and tuning databases for optimal performance, ensuring smooth operation of applications and overall database health.
– Implementing robust security measures to protect sensitive data, including user access control and encryption
– Inputting to Corporate backup and recovery strategies to minimize data loss and downtime in case of emergencies.
– Collaborating with the planning and implementing disaster recovery procedures to ensure quick database restoration in case of system failures.
– Collaborating with our engineering and infrastructure colleagues to identify and implement beneficial/best practice maintenance plans that are appropriate for the required business need for on premise and clouds based platforms (e.g., Amazon RDS, Microsoft Azure SQL Database).
– Additionally, you will be involved in: Working closely with application developers to understand their data needs and assist in designing appropriate database solutions.
– The analysis, design, specification, development, testing and documenting of new and amended programs in accordance with agreed standards to meet defined business needs, retaining compatibility with enterprise and solution architectures.
– The provision of system support to ensure business processing is completed in accordance with agreed service agreements.
Skills & Experience Required
– Thorough knowledge of the systems development life cycle, from inception through analysis, development & testing, to implementation
– Experience, across a range of platforms and disciplines, of more than 2 concurrent projects each of more than 6 months duration
– Experience of Microsoft SQL Server is essential, including experience of T-SQL, SSIS, SSAS, SSRS, SQL performance tuning & fault analysis
– Previous experience of cloud-based database platforms Amazon RDS, Microsoft Azure SQL extremely beneficial.
– Previous experience of Microsoft Data platform tools (Azure Databricks, Microsoft Fabric) beneficial.
– Education to graduate level or relevant work experience
Related Jobs (3)
-
Salary Negotiable
