|
 |
|
|
| Junior SQL Database Administrator |
|
 |
 |
|
 |
|
The role of the SQL Server DBA is based within the ITG Software and Database Administration Team. Reporting to the Senior Database Administrator, the Role is to assist all Senior DBA’s with the Lloyd’s DBA function:
•To provide day to day SQL support and Administration for all Lloyd’s Applications.
•To assist with the management of the Lloyd’s SQL Server Database Environment.
Main responsibilities:
•Provide day to day administration and support of SQL applications from the ITG Application Support team as required.
•Ensure robustness, data integrity, ownership and control of Lloyd’s database assets.
•Assist with the development of the main functions to be performed in SQL Database Management
•Assist with the management of the ‘division of duties’ involved in SQL
•Assist with authorising exceptions to the above on a case by case basis (i.e. for each database)
•Assist with providing SQL administration across the Corporation
•Accountable to the ITG Senior SQL Server Database Administrator
Associated responsibilities:
•Assist with documenting ‘division of duties’ at Instance / database level.
•Input to SQL Server decommissioning as required.
•Input to new SQL Database installations (should they be part of consolidated environment, which instance, stand alone etc)
•Input to Server Operations administration and Security model for Lloyd’s SQL Server environment (and agree exceptions on case by case basis)
•Interaction with third party database support and suppliers (where appropriate)
•Assist with determining levels of support required for Business Unit databases
•Assist with ensuring DBA cover as required
•Contribute to the development of tools and identify any new tools that would bring efficiencies
•Where databases interact / support Information Management, assist with identifying interactions and procedures
•Assist with establishing appropriate toolset to supplement SQL Server administration
Maintain and develop Lloyd’s ‘DBA Central’ system.
Staff responsibilities:
•Assist Application Support staff as necessary |
|
  |
|
 |
|
|
|
|
Bachelors
|
|
5 years + |
|
|
|
English : Speak / Write Fluently
|
|
|
|
open-ended |
|
|
|
unspecified |
|
|
|
EU National |
|
|
|
London |
|
|
|
 |
|
 |
|
|
•Must have an understanding of MS SQL database design and operating principles.
•Must have experience of multiple MS SQL 2000/2005/2008 instances on large systems across
•Production, Test and Development environments.
•Must have experience of Transactional SQL, DTS / SSIS, stored procedures, script writing.
•Excellent problem solving skills
Knowledge/experience of SQL Server Clustering, Replication, SSRS, SSAS Log shipping, Installation and configuration of SQL Server and advantage
•Proven experience of working in a support capacity, providing support to both internally developed and third party provided applications.
•Awareness of the ITIL framework, specifically Change and Configuration Management
•Proven technical experience of Microsoft Windows Server technologies, Microsoft Windows PC technologies, Microsoft Office technologies, SQL Server
•Knowledge of the Lloyd’s environment an advantage
•IBM Rational ClearCase / Clearquest
•Quest Products
•Redgate SQL tools
•Powershell
•Programming language experience (c#, .net)
•MOM, SCOM |
|
|
|
Lloyd's is the world's leading insurance market providing specialist insurance services to businesses in over 200 countries and territories. |
|
|
|
|
