Date Posted: 2019-02-10 | Date Modified: 2019-02-10 | Expires: 2019-03-12

SQL Database Administrator

Job Description

Job Purpose and Main Responsibilities

• Installation, Administration and Maintenance of SQL Server Instances.
• Setup Test, Dev, Staging and Production Environments.
• Create Users and assign permissions based on the level of database access the user would need.
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc.
• Design database Backup and Restoration Strategy.
• Once created the database Backups, monitor those backups are being performed regularly.
• From time to time recover the databases to a specific point of time, as per the requests.
• Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication)
• Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)
• Documenting major changes to the SQL Servers.
• Apply Service Packs & patches.
• Database security administration.
• Writing SQL queries, procedure, packages, trigger and understanding of PL/SQL code.
• Tunning SQL queries
• Designing DB objects ie. Tables/indexes/views etc and constraints designing & deployment.

Key Skills/Knowledge:

Good to have:
• Knowledge on Workflow and Plant Floor Applications
• Automotive domain Knowledge

Requirements

Please note - We can consider applications who does have valid work permit or British/EU nationality only. No Sponsorship Provided.Any one who are Authorized to work in the EU can apply, No Sponsorship Provided.

Skills

Oracle PL/SQL SQL SQL Server

Language Requirements

English

Education Degree

Other

Visa Support

No

Accepting only candidates from:

United Kingdom
Email Job

Job Criteria

Job Type

Contract

Industries

#Information Services, #Information Technology and Services

Job Location

United Kingdom - Liverpool

Functions

Information Technology

Salary

Negotiable

Companies will apply to you too

Fill in your resume and companies will send you invitations to apply on their jobs and we will notify you directly on your email box.