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:
• Optimise databases to improve performance.
• Maintain and administer databases in the test and staging environment.
• Troubleshoot and provide root cause analysis of major incidents and problems.
• Provide consultation on issues related to data in the production environment.
• Prepare database deployment scripts and assist with production deployment.
• Assist Developers and Testers with database activities.
• Internal team training on anything database related.
• 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.
• Design database schema tables, stored procedures, views, functions, triggers, and indices to meet the application performance requirement.
• 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.
• Write and maintain database design documents.
• Develop, manage, and test database backup and recovery plans.
• Design, develop and maintain ETL solutions for the data warehouse.
QUALIFICATIONS AND EXPERIENCE
• Good experience in SQL Server, MySQL, NoSQL…
• Experience with the data warehouse is an advantage.
• Strong experience in Database Performance Tuning and Query Optimization
• Experience working in the payments and/or financial services industries is advantageous.
• Good interpersonal and collaboration skills combined with a strong teamwork ability.
• Good experience in Reporting tools such as MS Reporting Services, Crystal Reports
• Knowledge of database architecture, data modelling, schema design and development
• Experience in Data Analysis is an advantage.
• Bachelor’s degree in Computer Science, Information Technology, or another related field
• Experience working on a commercial project to build a data warehouse.
• Experience with Amazon Database services.
• Good experience in BI, ETL, Database Analysis and Design skills
• Good experience in technologies that match the company&039;s focus.
• Good English communication skills (written and oral)
• Experience with Database migration is an advantage.
• Minimum of 3+ years’ experience in database development and administration
BENEFITS
• Free parking, coffee, snacks, etc.
• Performance review twice a year.
• Gross salary which includes tax, medical, social and unemployment insurance.
• Annual Health check.
• 13th- month salary and performance bonus.
• Premium healthcare plan.
• Laptop provided.
• International and friendly working environment.
• Regular team dinners and team- building activities.
• Online technical training courses (15.6m/year).
• 14 days annual leave + 01 birthday off.
