Senior Database Administrator

About the role

Energy Bay, which designs, integrates and operates distributed energy infrastructure, is looking for an experienced Senior Database Administrator based in Sydney. Reporting to the Head of IT, you will own the SQL Server and Microsoft Fabric data platform, including data, pipelines, refreshes and ETL and transformation layers. You will also lead the database side of the move to the cloud with the Senior Infrastructure Engineer, ensuring secure, reliable and well-governed data for core systems and BI reporting.

Key responsibilities

• Own the SQL Server estate, including performance, availability, backup, recovery and security
• Own Microsoft Fabric workspaces, including data, pipelines and scheduled refreshes
• Monitor capacity and cost across SQL and Fabric, and tune queries and indexes
• Plan and deliver the migration of SQL Server databases to Azure SQL or Managed Instance with the Senior Infrastructure Engineer, testing, validating and cutting over with no data loss
• Design, build and maintain ETL pipelines, dataflows and notebooks in Fabric and Data Factory
• Define and manage raw, cleansed and curated data layers so reporting draws from governed data
• Monitor pipeline and refresh runs and resolve failures quickly
• Set data standards, naming conventions, access controls and data quality checks, and maintain data dictionaries and lineage
• Work with the Dev team on schema design, releases and data requirements, and provide reliable data for BI reporting while recording all changes in the IT change log

Required profile

• Bachelor's degree in IT, Computer Science or a related field; DP-300 desirable
• 5+ years with Microsoft SQL Server in a senior DBA or data platform role, covering administration, performance tuning, backup and recovery and security
• Experience migrating databases to Azure (Azure SQL or Managed Instance) and building ETL pipelines in Fabric or Data Factory
• Strong T-SQL and data modelling skills, with Power BI experience to support reporting
• Experience setting data standards, access controls and data quality processes
• Strong experience in the electricity or energy industry, with exposure to wholesale market environments

Required skills

• Microsoft SQL Server and T-SQL
• Azure SQL or Azure Managed Instance
• Microsoft Fabric and Data Factory
• Data modelling and Power BI

What we offer

• Comprehensive training and mentorship from experienced professionals
• A fast-growing, entrepreneurial company with a diverse and inclusive workplace