The ideal candidate will be responsible for creating, installing and managing our databases. You will ensure optimal database performance by analyzing database issues and monitoring database performance. Responsibilities: Database Physical Design, Installation, and Implementation: Overseeing the design and setup of physical databases to meet our business requirements. Ensuring optimal index and partition strategies for enhanced performance. Coordinating with development teams to implement database schemas and objects. Database Upgrades and Maintenance: Working with developers to perform regular updates and preventative maintenance to ensure the continued performance and robustness of our databases. Planning and executing database version upgrades and patching with minimal downtime. Monitoring database environments to pre-emptively identify potential issues and initiate corrective measures. Working with IT teams to ensure networking and database security is compliant with company policy. Query Performance Monitoring/Tuning and Capacity Planning: Monitoring and optimising database queries and planning for future database capacity needs. Using performance monitoring tools to analyse and optimise queries and indexing. Conducting regular capacity analysis and forecasting to manage growth and resource requirements effectively. User Account Maintenance and Access Controls: Managing user/service accounts and ensuring proper access controls and security measures are in place. Implementing role-based access controls (RBAC) to manage permissions effectively. Regularly auditing access logs and user activities for compliance and security purposes. Backup, Replication, and Recovery Procedures: Developing and administering effective backup and recovery protocols to safeguard data. Implementing and maintaining replication strategies for high availability and disaster recovery. Testing and validating backup and recovery procedures to ensure data integrity and rapid recovery in case of failures. Qualification and Education: This role demands a hands-on approach, a keen eye for detail, strategic thinking, and a passionate commitment to helping our business grow through the power of a well-maintained and optimised database environment. Strong knowledge of database management systems (DBMS) and experience in physical database design. Proficiency in DBMS tools and utilities for database upgrade, maintenance, and performance tuning. In-depth experience with AWS database services such as RDS, Aurora, DynamoDB, and Redshift. Solid understanding of AWS cloud infrastructure, security, monitoring, and cost management principles. Experience in Managing Production Databases: Proven track record of managing and maintaining production databases, ensuring their availability and reliability. Procedures for Online Updates and Maintenance: Demonstrated ability to perform database updates and maintenance while ensuring minimal or no downtime, using techniques such as rolling updates, database replication, and online schema changes. Experience with user account management, access controls, backups, and recovery procedures. Expertise in data integration, ETL development, and synchronization processes. Ability to troubleshoot and resolve database issues efficiently. Excellent attention to detail and technical documentation skills. Strong problem-solving abilities and capability to work both independently and as part of a team. To apply: Please send your CV and a cover letter addressing the selection criteria to. Employment offer will be subject to satisfactory mandatory compliance checks including National Criminal History Check, employment reference checks and required identity checks. In order for your application to be considered, you will require full working rights in Australia. We are unable to offer sponsorship at this time. Thank you for your interest in the position. Please note that only short-listed candidates will be contacted. #J-18808-Ljbffr