CMC TS 3.3 ★

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.Bachelor's degree in Computer Science, Information Technology, or another related field
Minimum of 3+ years' experience in database development and administration
Knowledge of database architecture, data modelling, schema design and development
Strong experience in Database Performance Tuning and Query Optimization
Good experience in SQL Server, MySQL, NoSQL...
Good experience in Reporting tools such as MS Reporting Services, Crystal Reports
Good experience in BI, ETL, Database Analysis and Design skills
Good experience in technologies that match the company's focus.
Good English communication skills (written and oral)
Good interpersonal and collaboration skills combined with a strong teamwork ability.
Experience with Amazon Database services.
Experience working on a commercial project to build a data warehouse.
Experience working in the payments and/or financial services industries is advantageous.
Experience with the data warehouse is an advantage.
Experience in Data Analysis is an advantage.
Experience with Database migration is an advantage.- Fully social insurance according to Vietnam Labor Law- Full salary on probation- 13th month salary and performance bonus- Annual leave: 14 days/ year + 01 day off for birthday leave- Performance review twice a year- Annual health check and vaccination- Premium Health Care Insurance (covering for spouse and children)- Personal Learning & Career Development Program (15.6 millions VND/ year)- Health Scheme Program- Laptop provided (Macbook/Window)- Free parking, coffee, snacks, etc- Attractive career path- Regular team dinners and team building activities- International and friendly working environment