Database Developer

Gambaran besar dan Tanggung jawab pekerjaan

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' 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.