Product Features
Blog
Contact Us
Sign In
Aspire Cambridge Kettering Milton Keynes
,
Fleet, Hampshire
Database Administrator
|
|
Job Type: Full-time |
|---|---|
|
|
Salary: £48,000 per annum |
Overview
We are looking for a Database Administrator (DBA) to be responsible for the performance, integrity and security of a database, involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. Main Responsibilities: Establish the needs of users and monitor user access and security Map out the conceptual design for a planned database Consider both back-end organisation of data and front-end accessibility for end-users Refine the logical design so that it can be translated into a specific data model Further refining the physical design to meet system storage requirements Install, upgrade and test new versions of the database management system (DBMS) Maintain data standards, including adherence to the Data Protection Act Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata) Control access permissions and privileges Develop, manage and test back-up and recovery plans Ensure that storage and archiving procedures are functioning correctly Carry out capacity planning Work closely with IT project managers, database programmers. Communicate regularly with technical, applications and operational staff to ensure database integrity and security Commission and install new applications and customise existing applications in order to make them fit for purpose Manage the security and disaster recovery aspects of a database. Troubleshooting Designing maintenance procedures and putting them into operation Managing database security/integrity and backup procedures Implementing security measures Providing user training, support and feedback Develop processes for optimising database security. Performance tuning of database systems. Recommend and implement emerging database technologies. Create and manage database reports, visualisations, and dashboards. Be available for on-call support as needed. This role can involve working to tight deadlines and when necessary, long hours. IT professionals working in this area will also need to be available for a call-outs rota (evenings and weekends). Qualifications/Skills: Strong command of SQL Query Language and SQL server tools Advanced knowledge of database security, backup and recovery, and performance monitoring standards Understanding of relational and dimensional data modelling PowerShell and Unix shell scripting skills Familiarity with SSAS, SSIS, SSRS Strong mathematical and statistical knowledge Excellent written and verbal communication skills Impeccable attention to detail Education and Experience Requirements: Bachelor's Degree in computer science or a related field One to three years' of experience in database administration, information technology, database architecture, or a related field MCSE/MCSA certifications preferred Experience with Linux and Windows Server environments Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB) Experience with cloud services Start: Immediate Location: Fleet, Hampshire Salary: Up to £53,000 Benefits: Income protection, Life assurance, Pension, 24 days holiday Bank Holidays If you are interested in this position, feel you have the relevant experience and skills and would like to apply, please call our team on or apply online. Whilst we'd love to get back to every applicant, it is not always possible, so if you haven't heard from us within 3-5 days, please note that your application has not been successful on this occasion. Aspire Cambridge is acting as an Employment Agency in regards to this Permanent opportunity.