Job Title
A Data Platform Administrator is responsible for maintaining high-performing and highly available Microsoft SQL Server environments, including scheduled patching, version upgrades, and platform migrations.
* Maintaining high availability configuration, performance optimization, and operational support of Microsoft SQL Server environments.
* Managing backup, restore, and disaster recovery strategies for on-premises and cloud-based SQL Server databases.
* Troubleshooting and resolving issues related to SQL Server Agent jobs, SSIS packages, and other scheduled or automated processes to ensure consistent data operations and minimize downtime.
* Administering database security, including data access and role-based access control (RBAC), credential management, and audit logs.
* Maintaining and supporting existing integrations and data flows between core business systems, ensuring consistent and reliable data movement across platforms.
* Maintaining and optimizing Microsoft Fabric data solutions, including lakehouses, dataflows, and notebooks, to ensure secure, reliable, and high-performing operations.
* Migrating legacy or existing data integration solutions into the Fabric environment, aligning with architectural standards, governance frameworks, and business requirements.
* Monitoring and managing fabric capacity usage, ensuring efficient utilization and proactive scaling where required.
* Troubleshooting and resolving issues within the fabric environment to minimize disruption and maintain data integrity and availability.
Required Skills and Qualifications
The ideal candidate will possess the following skills and qualifications:
* Tertiary qualification in Information Technology, Computer Science, or a related discipline.
* Relevant Microsoft certifications or equivalent, such as DP-600: Microsoft Fabric Analytics Engineer Associate and DP-900: Microsoft Azure Data Fundamentals.
* Minimum 5+ years' experience managing Microsoft SQL Server environments, including high availability configuration, performance optimization, and operational support.
* Minimum 2 years' hands-on experience designing, developing, and maintaining data pipelines and integration solutions using Microsoft Azure or Microsoft Fabric.
* Strong knowledge of data warehousing methodologies, including dimensional modeling, ETL best practices, and scalable architecture design.
* Proficient in T-SQL and SQL development, including writing and maintaining stored procedures, functions, and views.
* Experience with Azure DevOps, Git, and version control practices for managing code, pipelines, and deployment workflows.
* Working knowledge of Python scripting and PowerShell for automation, data flows, and operational tasks.
* Demonstrated experience working with a variety of data sources, including on-premises systems, cloud platforms, and APIs to efficiently extract, transform, and integrate data for analytics and reporting purposes.
* Demonstrated experience with Microsoft SQL Server stack, including: SSIS (Integration Services), SSRS (Reporting Services), SSAS (Analysis Services).
* Demonstrated ability to work independently and collaboratively, showing initiative, integrity, and accountability.
* Strong analytical and problem-solving skills, with effective time management and the ability to meet deadlines.
* Excellent communication skills, with the ability to explain technical concepts clearly to both technical and non-technical audiences.