To excel in this role you must have Experience as a Postgres DBA with advanced hands-on knowledge ofWho familiar in either of this Database will be consider also Oracle My SQL MariaDBDatabase Setup Security Replication Performance Tuning Disaster Recovery SQL Stored ProceduresExperience with database testing tools such as pgTAPExperience with data extraction and reporting for data warehouse cubeKnowledge of Linux system administration including configuration and automation tools such as Chef as well as Shell scripting is preferredKnowledge of scripting language and Perl in particular is a plusYour role As our PostgreSQL Database Administrator you will plan implement and manage the database systems that are essential to the architecture of our high-traffic trading platform You will Plan install and configure world-class database systems that meet business objectives and the needs of end usersAssist backend developers in writing production-ready SQL codePlan and carry out the upgrade and migration of databases as neededDevelop implement and test database backup and recovery plansManage database security by controlling access to data through authentication authorisation and auditingPerform tests to ensure database performance and security as well as data integrityDocument and administer database policies procedures and standardsPlan and execute data extraction for efficient loading in data warehouse and ensure extracted data is useful and properly formattedTroubleshoot and debug problems in existing database systems and find new ways to improve their speed functionality and scalabilityTo be successful in this role you will need to haveCandidate must possess at least Bachelor s Degree Post Graduate Diploma Professional Degree in Engineering Computer Telecommunication Computer Science Information Technology or equivalent Required languages MandarinAt least 4Years of working experience in the related field is required for this position Preferably Senior Executive specialized in IT Computer - Network System Database Admin or equivalent Required languages know write and read inMANDARIN IS A MUSTCandidate must bewilling to travelwhen requireetc Local OverseaTo help you succeed in this role we will assist in supporting you in Oversea allowance and all the expenses etc air ticket accommodation if you are required to travel
Type : Company job
Role : Senior Executive
Industry : Computer/Information Technology (Software)
Salary : MYR 6,000 - 8,000
Established in 2014, we are an IT Company with overseas investment and establishment. The company mainly provides consultancy and IT oursourcing for online gaming industry and building small business web portal and mobile products. We are the people behind the internet.
Our customers are generally from China, Philipines and Malaysia. We have engineers stationed in China working on our products. Our data center is located in USA, Hong Kong and Malaysia. The company is looking into customer expansion into other countries.