Get AI-powered advice on this job and more exclusive features.
Direct message the job poster from Maltem Australia
Partner with organisations to design and deliver end-to-end enterprise data platforms and unlock the full potential of their analytics capabilities 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 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 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.
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.
Seniority level Mid-Senior level
Employment type Full-time
Job function Information Technology
Industries IT Services and IT Consulting
#J-18808-Ljbffr