Database Engineer (SQL Server)

ABOUT USLive Payments is one of Australia's leading payment service providers, servicing thousands of businesses across Australia. We continue to innovate our payment solutions and expand our product offering alongside our industry-leading strategic partners, including Qantas Loyalty and Ingenico.Live Payments is seeking a talented and experienced Database Developer to join our growing/ multi-national team. Reporting directly to our Vietnam-based Team Leader, the Database Engineer will work closely with the development team to design and implement database solutions and address stakeholders' business requirements. Core responsibilities include:Design database schema tables, stored procedures, views, functions, triggers, and indices to meet the application performance requirement.Design, develop and maintain ETL solutions for the data warehouse.Design, develop and maintain business reports for other departments.Design and write queries to extract data for ad hoc requests from other departments.Review code and advise and guide developers on best practices for database queries and procedures.Carry out capacity planning and cost optimisation.Write and maintain database design documents.Troubleshoot and provide root cause analysis of major incidents and problems.Internal team training on anything database-related.Prepare database deployment scripts and assist with production deployment.