Database Administrator

**ABOUT CENTRAL INNOVATION**

Central Innovation provides a range of CAD and related software solutions to companies that design, construct, manufacture and assemble products, machinery and buildings in Australia, New Zealand and internationally. Our customers include leading architects, designers, and engineers, who use our software to create amazing new products, construct beautiful homes and major infrastructure, and manufacture market-leading equipment and products.

**ABOUT THE ROLE**

Creatio (CRM) and Database Administrator will be the driving force behind unlocking the potential of the Creatio platform. You will wear many hats - a strategic advisor, a data magician, a user champion, and a technical whiz. Your will be responsible for ensuring Creatio aligns seamlessly with our evolving business needs, empowering users to achieve their goals, and delivers insightful data that fuels informed decision-making. You will be the go-to expert, collaborating with stakeholders across departments to understand their requirements, translate them into actionable solutions, and continuously refine the Creatio platform to drive user adoption and optimise performance. Because Creatio is directly linked with database, you will be managing all the data in database (Microsoft SQL Server).

This role is based in Australian Head Office in Pymble.

**KEY RESPONSIBILITIES**
- Design and implement user profiles, roles, and permissions, ensuring optimal access control and user experience.
- Customise objects, fields, page layouts, and workflows to streamline data capture and enhance user efficiency.
- Implement and maintain robust data hygiene practices through import/export processes, duplicate management, and data validation rules.
- Proactively monitor system performance and health, identifying and resolving potential issues before they impact users.
- Implement and maintain best practices for data security and backup procedures, safeguarding sensitive information and preventing data loss.
- Perform regular database maintenance tasks such as monitoring, tuning, and optimization.
- Troubleshoot and resolve database-related issues, incidents, and outages in a timely manner.
- Support company staff and other IT teams through resolution of queries, internal tickets and change requests.
- Power BI, you will use Power BI, SQL, Tabular, DAX and Data Modelling skills to work on the 'backend' semantic layer of a Power BI Platform to optimise legacy report performance.

**QUALIFICATIONS/ SKILLS/ EXPERIENCE**
- Proven experience in managing SQL database environments, including undertaking upgrades, implementing solutions, and providing support in a managed services context.
- Strong expertise in SQL Server management, database administration, performance tuning, and troubleshooting.
- Experience with database backup and recovery strategies, high availability solutions, and disaster recovery planning.
- Good understanding of Information Systems specifically CRM, standard CRM concepts and understanding of business processes and business process management.
- Hands-on experience of working on MS SQL Server and experience of writing and troubleshooting complex database queries (ANSI SQL, T-SQL)
- Must have good written and verbal communication skills, and interface directly with company users and management.
- Power BI and DAX experience with tabular and data modelling.
- Prior experience of Creatio (CRM), Sage X3 (ERP) will be favourably viewed.

Pay: $95,000.00 - $109,000.00 per year

Ability to commute/relocate:

- Pymble, NSW 2073: Reliably commute or planning to relocate before starting work (required)

Work Authorisation:

- Australia (preferred)

Work Location: In person

Application Deadline: 13/05/2024