Data Base Administrator Microsoft SQL

Job description

DBA Development

We are seeking an experienced DBA Developer to join our Analytics team based at our Head Office in Bolton.

The successful candidate will be responsible for planning, developing, and maintaining our SQL Server databases to ensure the efficiency of our reporting functions.

Key Responsibilities:

• Manage the Data warehouse predominately using SSIS/T-SQL

• Act as a gatekeeper & maintainer of our data ecosystem

• Create, develop and maintain SQL Server systems and processes ensuring optimisation and stability

• Develop and maintain SSIS packages for task automation

• Develop and maintain SQL Server Management Studio, SSRS Reports

• Define database schema, tables, indexes, views, stored procedures & triggers

• Test database processes and perform bug fixes

• Write complex SQL scripts from across multiple data sources

• Experience in dealing with Error Handling, Transaction Management and Query optimisation

• Assist in the migration, optimisation and cleaning of data

• Ensure data compliance with GDPR & other relevant regulations

• Complete tasks in line with Department KPIs & business objectives

• Help in out of hours releases

Requirements:

• Extensive experience with Microsoft tech stack including SSIS/SSMS

• Possession of passion and aptitude for database development and new technologies, ADF is an advantage

• Enthusiasm about data and the difference it can make

• Willingness to take ownership of pieces of work and projects from requirement through to delivery

• Strong troubleshooting skills

• Ability to work effectively in a team environment often under pressure

• Good verbal and written communication skills

• Power BI is an advantage

• Microsoft Excel Advanced

• Ability to work office based full time within a commutable distance of our Head Office in Bolton

What We Offer:

• Annual pay reviews

• Town centre location

• Employee Assistance Programme (EAP)

• Progression opportunities

• 2 x Annual bonuses (up to 5% of annual salary based on individual and company performance)

• £350 Refer a friend programme

• Discounts & E-Vouchers

Salary: £35,000 – £45,000 per annum (dependent on experience)