|Job Ref:||204716084||Employer:||cv-library.co.uk||Job Type:||Permanent||Country:||United Kingdom||County/State:||Berkshire||City:||Reading||Address:||Salary:||£40000 - £50000/annum + great benefits||Post Date:||30/09/2016 04:12|
SQL Database Administrator and Developer ? based in Reading|
Permanent position, paying up to £50,000 + great benefits
My client is one of the UK's leading specialist resourcing and consultancy firm in the areas of governance, compliance and complaints. Their ambition is to enhance the reputation of their clients with their customers, people and regulators.
My client's success relies on its computing facilities being available, effective and efficient during its core hours. The DBA is responsible for the effective and efficient operation & management of the company's databases; This Involves monitoring scheduled maintenance tasks, performance tuning as well as effectively responding to daily requests.
The DBA is responsible for recommending database improvements to ensure maximum performance and security of the company's databases and after following the Internal Change Process required to implementing them.
The DBA is also responsible for producing accurate and professional management information (MI) and reports to defined specifications or providing one-off or automated solutions for data provision to business operations staff (client PMO's usually). They are also the subject matter expert (SME) following the principles of ?Master Data Management? to ensure the company uses its data in the most efficient way possible and complies with Client retention and usage requirements.
My client takes information security serious and has achieved certification to ISO27001:2013. The Database Administrator ensures that the business's computing facilities are kept secure and that new proposals, installations, upgrades and changes do not breach the company's security policy or expose us to unnecessary risk.
â€¢ Day-to-day responsibility for the maintenance of the company's databases and managing third party organisations that could deliver some of the work.
â€¢ Day-to-day monitoring of database usage and growth.
â€¢ Produce regular MI and reports on database use, growth and status.
â€¢ Produce professional and efficient SQL code and reports as requested by the business.
â€¢ Database design and build where necessary as part of a project team, dealing with all levels of the business.
â€¢ Troubleshooting issues and problems with the database servers to the successful identification; implementing well thought-out corrective and preventive actions.
â€¢ Ensure that identified issues and problems are descriptively logged and kept up to date on the company's call logging system.
â€¢ Ensure the company's computing facilities are kept secure to reduce the risk of breaches of confidentiality, integrity and availability.
â€¢ Support solution design from a data and database perspective.
â€¢ Gain agreement for and deliver data integrity, data security and data loss prevention solutions
â€¢ Participate proactively and broadly in the Technology roadmap and client requirements from a data perspective
â€¢ Experience with MS SQL Server (2000/2005/2008/2012/2014) and upgrading live databases
â€¢ Experience using TSQL, SSIS & SSRS
â€¢ Experience Implementing & Supporting High Availability/ DR, , Database Encryption
â€¢ Experience troubleshooting and resolving database problems
â€¢ Experience in performance tuning and optimisation from database and OS point of view
â€¢ Experience in Corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analytics engine, advanced data mining)
â€¢ Experience with backups, restores and recovery models
â€¢ Experience with source control systems e.g. TFS
â€¢ Knowledge of Windows server and Active Directory
â€¢ Provides technical assistance and mentoring to staff in all aspects of database management.
â€¢ Ability to speak confidently with senior stakeholders, as well as talk "techy" with DevOps teams.
â€¢ Performs DB support activities in partnership with internal and external service providers.
â€¢ Willingness and ability to become Microsoft SQL Server Certified (MCSA)
â€¢ Advanced knowledge of Microsoft Office especially Excel.
â€¢ Basic knowledge of Microsoft Windows Server and Active Directory.
â€¢ Aptean Respond experience
â€¢ Epicor ERP experience
â€¢ SQL Server Analysis Services
â€¢ High Availability database solutions other than SQL Server
â€¢ Microsoft Dynamics CRM experience
â€¢ Microsoft SharePoint experience
â€¢ Microsoft Cloud (Azure, Office 365) experience
â€¢ Cherwell experience
â€¢ ETL Processes experience
â€¢ An active MCSA Microsoft SQL Server Certification
â€¢ Tableau Business Inelegance (BI) or equivalent dash boarding software experience
â€¢ Knowledge of Microsoft Operating Systems, Windows Server 2008/2012
â€¢ Knowledge of VMWare ESX Server