KEY RESPONSIBILITIES:
Work closely with the Development, Reporting and Infrastructure teams (within I.T) and various business users to ensure:
- Data remains consistent across the various sources.
- Data is clearly classified.
- Audit trails are available to demonstrate security, performance and integrity.
- There is provision for data security and data-protection compliance (GDPR).
- Tasks may involve some or all, of the following:
- Install and configure SQL Servers, manage migrations to Azure SQL.
- Ensure that new database code meets company standards for readability, reliability, performance, and security.
- Monitoring performance and managing parameters to provide fast responses to front-end users, appropriate logging and audit trails, and clear recommendations for the development team.
- Ensuring that storage and archiving procedures are functioning correctly.
- Running file system clean-up projects.
- Further refining the physical design to meet storage requirements.
- Design and implement security and access methods for production environments using the principle of least privilege.
- Writing documentation, including data standards, procedures, and definitions for the data dictionary (metadata).
- Controlling access permissions and privileges.
- Advocate and implement reliable design patterns (high availability, graceful degradation, correct alerting, SPoF mitigation)
- Developing, managing, and testing back-up and disaster recovery plans.
- Ensuring appropriate capacity planning.
- Measure everything, predict outcomes, and proactively work to mitigate failures and sub-par performance
- Aid the strategy and architectural choices around the database and related tooling. Participate in the regular Architectural Review Board (ARB) reviews and contribute relevant technical guidance to support the IT Strategy and Roadmap.
- Experience with Azure, ETL solutions, SSIS, Powershell, DBATools, Ola Hallengren’s Maintenance Solution and Brent Ozar’s First Responder Kit is desirable.
REQUIREMENTS:
Knowledge and Experience
- Good knowledge of the management of various data stores such as file systems and cloud storage
- Experience in Microsoft SQL Server including server administration, mirroring and performance testing. Minimum 3 years.
- Strong skill in managing and monitoring performance and optimizing SQL queries/views.
- Sound understanding of the other Microsoft technologies.
- Understanding of the general principles around data classification and data retention.
Personal Competencies
- Excellent verbal and written communication skills.
- Analytical and logical thinker with good problem-solving skills.
- Ability to work closely with business users and have corresponding knowledge and understanding of their roles.
- Self-driven with ability to take ownership of tasks and to follow through to completion.
- Excellent interpersonal skills and ability to work as part of a team.
- Ability to work in a busy and demanding environment.
- Solid documentation and record keeping ability.
