Database Developer (Sign-On Bonus) - Up to $2000 gross

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. Optimise databases to improve performance. Develop, manage, and test database backup and recovery plans. Review code and advise and guide developers on best practices for database queries and procedures. Provide consultation on issues related to data in the production environment. Carry out capacity planning and cost optimisation. Write and maintain database design documents. Monitor Quality Acceptance testing and User Acceptance Testing of the database. Troubleshoot and provide root cause analysis of major incidents and problems. Internal team training on anything database related. Maintain and administer databases in the test and staging environment. Prepare database deployment scripts and assist with production deployment. Assist Developers and Testers with database activities.