Database Administrator in AUSTRALIA

Company Overview:

Maltem Australia is a boutique consulting firm specialising in data and analytics. We excel in helping organizations design and build their data architecture and modern data stack, as well as in establishing or accelerating their data science, MLOps & AI initiatives. Our team of 50+ consultants work with well-established organisations and SMEs across various industries including financial services, insurance, energy, education, and government. We also offer offshore capabilities and expertise in technologies like Databricks, Snowflake, Dbt, and Azure/AWS cloud services.

Mission:

Your mission is maintaining and managing Microsoft SQL servers critical to business operations. You will ensure the optimal performance and reliability of database systems, promptly troubleshoot and resolve database-related issues, and continuously monitor and enhance database performance. You will collaborate with development teams to design and optimize database solutions, develop and maintain SSIS packages for data integration and workflow automation, and document current processes and SQL transformations. Additionally, you will assist the DCS team in addressing data quality issues for reporting and support the Snowflake project, focusing on extracting raw data and historian data. You will also work closely with the other Maltemian in the project, and be under our Director's leadership within the project as well.

Experience Required:

• Minimum 7+ years of experience in MS SQL or Microsoft SQL
• At least 3+ years of experience with SQL Server Integration Services (SSIS)
• Strong SQL, including proficient in stored procedures, temporary tables, views, and the ability to write complex queries
• Excellent communication skills
• Proven ability to analyze, understand, and enhance existing systems
• Experience with SQL Server Reporting Services (SSRS) and Power BI is desirable
• Familiarity with Azure SQL and Snowflake is a plus

Role and Responsibilities:

• Maintain and manage Microsoft SQL servers critical to business operations
• Ensure the optimal performance and reliability of the database systems
• Troubleshoot and resolve database-related issues promptly
• Perform routine maintenance tasks, including backups, indexing, and updates
• Monitor database performance and implement improvements
• Collaborate with development teams to design and optimize database solutions
• Develop and maintain SSIS packages for data integration and workflow automation
• Generate reports and data visualizations using SSRS and Power BI, if needed
• Stay up-to-date with the latest database technologies and best practices
• Document current processes and SQL transformations
• Assist the DCS team in addressing data quality issues for reporting
• Support our Maltem team on the Snowflake project, focusing on extracting raw data and historian data

Key Competencies:

• In-depth knowledge of Microsoft SQL Server administration
• Proficiency in SSIS, with the ability to design and implement complex ETL processes
• Strong analytical and problem-solving skills
• Effective verbal and written communication abilities
• Capable of working independently and as part of a team
• Experience with Azure SQL and Snowflake is advantageous

Location:

The role can be performed fully remotely, but it would be ideal if the consultant could go 1-2 days a week at their office in North Sydney if based in Sydney.

Interview process:

• One discussion to access your soft skills and culture-fit
• A second round interview with our Director of Data, AI & Cloud services to gauge if you're a good fit for our advisory project

If you are a highly skilled SQL/DBA professional with a passion for database management and optimisation, we invite you to apply and join our talented team at Maltem.