SQL DBA

This job has now expired please search on the home page to find live IT Jobs.

SQL DBA

London

£36,000 - £40,000 + perm benefits

A leading educational institute based in London is currently recruiting for a SQL DBA to be responsible of maintaining and improving our Corporate Databases along with managing and implementing new systems, in line with the strategy and agreed service levels. The SQL DBA requires strong solid SQL server development experience and skills; good knowledge of rational database principles, development of bespoke data integration and reporting packages, database optimisation and SQL server administration.

Responsibilities

*To ensure the good maintenance of databases; providing patches, upgrades and configurations as needed to ensure their integrity is maintained and they are secure, highly available and fit for purpose

*To actively monitor and manage priority database systems, taking responsibility for the effective running of databases, ensuring that their performance has appropriate availability & response times and providing capacity to deal with the demands as needed at different times of the year and as demanded by corporate growth

*To ensure that back-ups are taken and verified as valid, working with colleagues across ITS as needed to this end and that there are robust and effective restore procedures in place

*Gather and interpret relevant data and information. Clean and prepare data required for all external reporting requirements using existing auditing reports and tools.

*Provide interaction with development and end-user personnel to determine data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases and reports

*To advise development staff in appropriate techniques for their systems to ensure performance and availability needs can be met; to similarly advise staff implementing new systems with a database component or interface

*To provide and maintain appropriate documentation for database systems, including details of underlying infrastructure & configuration settings to ensure they can be effectively supported. To provide knowledge share with colleagues and collaborate with external experts on databases & related systems

*To manage MSSQL Databases, MI reporting using SSRS and creating policies and procedures to support the database environment.

*To ensure that standards and procedures for the effective support / maintenance / monitoring of database systems are developed, maintained & adhered to in line with the corporate standards

*To assist in maintaining existing databases and corporate systems and the development of any new software systems as required to achieve corporate strategy and business efficiencies

*Write and understand Microsoft Transact SQL. Write TSQL statements, stored procedures and views using industry best practices for security and efficiency. Create, test and execute SQL language code