SQL DBA

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

SQL DBA

City of London

£30,000 - £37,000 per annum + benefits

Spring Technology is currently working in partnership with a leading institute to recruit a SQL DBA based in the City of London. Within this role you'll be responsible for maintaining and improving the Corporate Databases along with managing and implementing new systems, in line with the institute's strategy and agreed service levels.

The Responsibilities:

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

*Actively monitor and manage priority database systems, taking responsibility for the effective running of databases.

*Ensure that back-ups are taken and verified as valid.

*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

*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

*Create and support interfaces amongst ITS systems and with other corporate systems

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

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

*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

*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

*Support, as required in the event of a major incident, the restoration of essential systems (e.g. in the server rooms) using agreed procedures

The Requirements:

*Specialist knowledge of MSSQL Server including infrastructure, backup/restore, availability management, performance tuning & query optimisation and capacity planning.

*Experience of implementing and support of diverse systems from a technical perspective

*Experience of creating, implementing and undertaking technical administrative procedures to ensure a robust service to end users

*Experience of providing support using pre-defined procedures including documentation of issues and prioritisation of workload

*Strong SQL Server Skills (SQL server 2008/2012, T-SQL) and development skills in T-SQL

*Ideally experienced in one or more of the following;

oSQL Server 2008r2 or above

oSSRS SQL 2008r2 or above

oSSIS SQL 2008r2 or above

*SQL server administration knowledge

*Knowledge of rational database principles, indexing, SQL Plan, Database optimisation etc.

*Ability to investigate new systems, understand their technical requirements and provide recommendations in their management

*Effective communication skills (verbal and written) with all levels of staff

*Ideally a degree or an equivalent recognised qualification

*An understanding of ITIL service management standards and procedures and the ability to apply them

Sound interesting? Apply now for my immediate consideration!

Spring acts as an employment agency for permanent recruitment and an employment business for the supply of temporary workers. The Spring Group UK is an Equal Opportunities Employer.

By applying for this role your details will be submitted to Spring. Our Candidate Privacy Information Statement explains how we will use your information - please copy and paste the following link in to your browser: www.spring.com/candidate-privacy-information-statement