Database Administrator
Posted 10/04/2024 by Morgan Fraser Group Limited
Technical Skills:
- Cloud Services (ideally Azure) experience is essential – including Azure Data Factory and Azure DevOps
- Excellent performance tuning skills (experience of Query Tuning, Indexing, Locking etc.)
- Strong T-SQL Experience (creating / administrating stored procedures, scripts, functions, triggers and other objects)
- Experience in the manipulation, transformation, and exploration of large multi-dimensional datasets
- Experience in database installation, backup, restore and maintenance
- BSC or equivalent in a software engineering / DB discipline and / or Professional qualifications appropriate to DB engineering roles is desirable.
- Experience of large transactional databases (100GB+)
- Excellent knowledge of the SQL Database Engine
- Experience of database release / upgrades with product releases
- Extensive experience of working with Microsoft SQL Server 2005/2008/2012/2014
- Data Warehouse development, ETL and transformation into conformed design
- Knowledge of SSIS packages
- Excellent experience and knowledge of the Microsoft stack
- Understanding of relational database design & dimensional Data-modelling
- Some experience of using Visual Studio
- Knowledge of C# and .Net framework desirable
- Knowledge of NOSQL / Document DBs advantageous
- Knowledge of SSRS reports advantageous but not essential
- Knowledge of 3rd party toolkits e.g. RedGate desirable but not essential
- Experience of Source Control (BitBucket/Kiln / Mercurial)
- Strong SQL Skills (SQL server 2012/2016, T-SQL) and development skills in T-SQL, writing scripts, Log Shipping, producing reports (SSRS), performance tuning, automated back-ups, security
- Any experience with Bespoke Software Solutions, ITIL, Agile, Jira and ISO 27001 will be advantageous but not essential
- Domain or Product expertise in IT Healthcare would be advantageous but not essential
- Type:
- Permanent
- Start Date:
- Immediate
- Contract Length:
- Permenant
- Contact Name:
- Login or register to view
- Job Reference:
- DBA
- Job ID:
- 221444601
Remember: You should never send cash or cheques to a prospective employer, or provide any financial information. Please get in touch if you see any roles asking for payments or financial details from you. For more information, visit jobsaware.co.uk.