About Us Live Payments is one of Australia&039;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.
Role and Responsibilities
Live Payments is seeking a talented and experienced Database Engineer 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&039; business requirements.
Core responsibilities include:
· Assist Developers and Testers with database activities.
· Prepare database deployment scripts and assist with production deployment.
· 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.
· Internal team training on anything database- related.
· Provide consultation on issues related to data in the production environment.
· Optimize databases to improve performance.
· 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.
· Monitor Quality Acceptance testing and User Acceptance Testing of the database.
· Carry out capacity planning and cost optimisation.
· Design, develop and maintain business reports for other departments.
· Develop, manage, and test database backup and recovery plans.
· Troubleshoot and provide root- cause analysis of major incidents and problems.
· Maintain and administer databases in the test and staging environment.
· Write and maintain database design documents.
Qualifications and experience
· Good experience in Reporting tools such as MS Reporting Services and Crystal Reports
· Good English communication skills (written and oral)
· Strong experience in Database Performance Tuning and Query Optimization
· Experience with Database migration is an advantage.
· Experience with Amazon Database services.
· Experience working in the payments and/or financial services industries is advantageous.
· Good experience in SQL Server, MySQL, NoSQL, etc.
· Good experience in BI, ETL, Database Analysis and Design skills
· Experience working on a commercial project to build a data warehouse.
· Knowledge of database architecture, data modelling, schema design and development
· Minimum of 3+ years’ experience in database development and administration
· Experience in Data Analysis is an advantage.
· Good interpersonal and collaboration skills combined with a strong teamwork ability.
· Experience with the data warehouse is an advantage.
· Bachelor’s degree in Computer Science, Information Technology, or another related field
· Good experience in technologies that match the company&039;s focus.
Benefits
· Annual health check and vaccination
· Free parking, coffee, snacks, etc
· Laptop provided (Macbook/Window)
· 13th month salary and performance bonus
· Performance review twice a year
· Premium Health Care Insurance (covering for spouse and children)
· Fully social insurance according to Vietnam Labor Law
· Annual leave: 14 days year + 1 day off for birthday leave
· Regular team dinners and team- building activities
· Attractive career path
· Full salary on probation
· International and friendly working environment
· Health Scheme Program
· Personal Learning & Career Development Program (15.6 million VND/year)
