Job Description
YOUR RESPONSIBILITIES
- Build a new best practice MS SQL environment for the BI teams use
- Convert our SSIS, SSAS, SSRS and Power BI objects to the new environment and best practice principles.
- Create and enforce governance rules and tools in place to ensure best practice endures.
- Document data warehouse lineage and dependencies.
- Document the environment for ongoing support via the development team.
- Monitor servers and services with a continuous improvement focus to ensure that they are optimised, efficient, and responsive.
- Provide database support to development teams and business teams through peer review of changes, providing advice to developers.
- Develop, implement, forecast and drive the strategic direction, performance and sustainability of databases.
- 5 + years of years of experience in SQL Database Administration in a complex and fast-moving environment.
- Knowledge in supporting the SQL Server full-stack. (SSIS / SSRS / SSAS / Power BI)
- Experience in setting up a brand-new BI toolset environment from scratch and running a migration project.
- Skilled in explaining technical concepts to technical people.
- Experience in the creation and later ensuring adherence to governance standards.