Senior Data Engineer
We have a great opportunity for a Senior Data Engineer to join a fast paced, expanding Nottingham Tech Firm.
Act as a key member of the Engineering Department, working directly with various stakeholders from across the business, designing stable and reliable databases, proactively monitoring the company's existing databases and participating in the design and implementation of the associated database software development.
PRINCIPLE DUTIES AND RESPONSIBILITIES
The role holder will be responsible for:
Developing the data platform, testing, improving and maintaining new and existing databases, and working closely with developers to ensure system consistency. Also collaborating with administrators and product developers to provide technical support and identify new requirements.
Your duties will include:
? Designing stable, reliable and effective databases
? Designing and developing database related products and solutions for the engineering team
? Liaising with developers, Product Owners and other Operations teams to deliver engineering roadmaps showing key items such as upgrades, technical refreshes and new versions
? Schema design and database modelling
? Supporting the Operations DBAs in the operational functionality, availability, efficiency, backup / recovery and the security of the company's MS SQL server databases
? Troubleshooting potentially ineffective queries and optimising them
? Managing solutions across distributed data centres and data platforms
? Maintaining all relevant documentation and knowledge bases
? Mentoring and training other members of the Engineering teams to share knowledge and provide training sessions where necessary
? Escalating application problems and following up to resolution
? Research and suggest new database products, services and protocols
? Working in a 24x7 always-on environment
? Providing on call support including out-of-hours incident support
? Mentoring and supporting other team members
? Microsoft SQL Server versions, 2016, 2014, 2008
? Ability to quickly understand new schemas
? Ability to reverse Engineer legacy reports and devise improvement plans
? Performance tuning
? Working with large database tables
? Developing end to end ETL solutions using SSIS, Stored Procedures and other ETL techniques
? An ability to apply measured self-restraint, empathy and courtesy to others during challenging situations, for example, when dealing with a difference of opinion.
? Ability to produce production-quality T-SQL code complete with internal documentation
? In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
? Experience/Knowledge of working in an agile environment and experience with agile methodologies such as TDD, Scrum, Kanban
? A good understanding of Azure hosted data solutions (including SQL and NOSQL technologies)
? Experience of working with development teams and product owners to understand their requirements
? Microsoft BI Stack (SSIS / SSRS)
? Familiarity with C#.NET and the data access options of the language
? Experience of mentoring team members in professional and personal development
? Always On Availability Groups
Along with a very competitive salary, our Client offers fantastic company benefits with clear direction for development. Apply today should you have the necessary experience.
This job was originally posted as www.totaljobs.com/job/83163411