SQL DBA
-
Job ref:
1171723/001_1610121621
-
Location:
England
-
Sector:
-
Job type:
-
Salary:
£440 - £480 per day
-
Contact:
Phil Johnson
-
Email:
-
Published:
3 months ago
-
Duration:
3 months +
-
Start date:
18/1/2021
-
Consultant:
#
SQL DBA
+ Working form home project
+ Travel to Manchester
+ Rate will be £440 to £480 per day
+ 3 month initial contract - likely to extend
+ SQL Server 2008R2 - 2019
The successful candidate will join a highly skilled team of project delivery engineers responsible for delivery of complex projects across multiple secure clients. The role will require a flexible working ethic and a pragmatic approach to IT project delivery.
Successful candidates will have experience in the delivery of infrastructure projects along with a broad understanding across a range of capabilities. They will have a keen interest in innovation combined with a willingness to implement new ways of working and automation. This role predominantly requires an in-depth knowledge of the implementation of SQL technologies.
Responsibilities
Designs database activity and file usage, and ensures necessary resources are present.
Determines data to be collected and analyses information as appropriate.
Builds for operations to ensure high quality performance of databases post implementation by considering informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for more complex databases. Recommends and implements tuning opportunities to improve system response and run times.
Defines logical attributes and data inter-relationships and designs complex data structures to accommodate database production implementation, storage, maintenance and accessibility to enhance performance.
Optimises database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes. Implements automation to limit database accessibility based upon information security level and ensures data spillage from more secure to less secure databases does not occur.
Implements database security regulations, policies, and guidelines. Proactively monitors security bulletins to obtain information of potential threats for consideration in new services
Plans and installs first-of-type upgrades of database management systems (DBMS) software as necessary to enhance database performance. Researches various hardware and software products; recommends solution and implements approved products.
Functions as a technical complex project leader for our portfolio of databases, including installations and upgrades of DBMS software and backup/recovery strategies. Reviews and approves application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.
Essential Knowledge and Skills Required:
5 years experienced working in DB environment with a least 2 years in a project delivery role
Must have analytical skills and be able to solve technical problems across different platforms.
Certified industry courses
Agile/DevOps/Scrum project delivery
Good programming skills for database management and general software
Good communication skills
Leadership skills to guide work teams
Ability to work in a team environment
Ability to anticipate problems and take decisive action
SQL Server 2008R2 - 2019
Clustering experience
Transact SQL Processing Language
Stored Procedure Development
Transaction Processing
Configuration and Security Maintenance
Reporting Services
Data Warehousing
