Job title: DBA database management engineer
Work location: Philippines
Need Status : Moderate
Recruitment requirements
1. More than 3 years experience in large database maintenance
2. Familiar with the working principle of Linux operating system, skilled in using CentOS operating system.
3. Familiar with at least one language such as shell/python, and can use scripts to complete related work.
4. Familiar with Oracle, MySQL installation backup, troubleshooting.
5. Familiar with database optimization technology.
6. Familiar with database patch maintenance, including Oracle upgrade PSU, One-off patch, MySQL major version upgrade, OEM upgrade, etc.
7. Familiar with the establishment and maintenance of high-availability technologies for databases, such as Oracle using DG and MySQL using master-slave replication technology.
8. Familiar with Oracle Goldengate.
9. Master database monitoring tools, including Zabbix, OEM.
10. Good working attitude, strong sense of responsibility, rigorous thinking, serious work.
Job Responsibilities
1. Undertake the SLA of the responsible database, and design and optimize the existing architecture
2. Responsible for daily upgrade tasks, including temporary upgrades, fixed maintenance window upgrades, and collaborative development to troubleshoot data-related issues.
3. Responsible for daily online database alarm processing and fault recovery.
4. Build a new environment, evaluate the space and performance of the new environment, coordinate with development and operation and maintenance personnel, and plan the table structure reasonably.
5. Responsible for routine maintenance operations, including offline script deployment, historical data offline, garbage table cleaning, table defragmentation, disk space increase, lvm maintenance, etc.
6. Output database maintenance standard operation documents and database-related technology sharing
7. Responsible for database migration, including migration tasks caused by performance that cannot meet the needs and other factors of the business.
8. Responsible for routine database machine room switching, and verify the high availability of the database.
9. Responsible for database patch maintenance, including Oracle upgrade PSU, One-off patch, MySQL major version upgrade, OEM upgrade, etc.
10. Construction and maintenance of high-availability technologies for existing databases, such as Oracle using DG, and MySQL using master-slave replication technology.
11. Maintain online database backup, use RMAN technology for full and incremental backup of database files and archives, maintain database flashback database functions, etc.
12. Monitor and maintain the online OGG environment.
13. Maintain online big data, including troubleshooting, filling in lost data, and adding table operations.
14. Optimize the online database, including operating system configuration, database parameters and SQL optimization.
15. Maintenance operations for online database monitoring, including Zabbix, PMM, OEM, Grafana monitoring.
16. Maintain database automation tasks, such as daily data retrieval.
company benefits
【Basic benefits】
1. Diet : four meals a day, breakfast - lunch - dinner - supper
2. Accommodation : 2 people per room in the dormitory of the apartment hotel;
3. Line : the company arranges a shuttle bus
4. Annual benefits: 13-16 salary, outstanding ones can also share dividends
【Health / Safety and Compensation】
1. Provide annual insurance of 125,000 P to 175,000 P medical insurance (medical insurance card)
2. High personal accident compensation , more peace of mind when going out
3. Passport / salary is not suppressed , visa compensation is clear , and compensation is paid on a monthly basis ( 100,000 P/2 years, one less and one, no other compensation). 9G work visa is applied for according to the law to protect legal work rights and interests
4. Apply for Philippine Social Security ( SSS )
【Working hours and holiday benefits】
1. 9 hours / day, 7 days off per month + Regular holiday
2. Enjoy a travel subsidy of more than 5,000P per year based on the length of service (starting at the job)
3. 1,000P monthly departmental activity fee (departmental arrangement and use)
4. Provide USD400 air ticket subsidy every six months (at the end of the year)
5. Provide a total of 15,000 P in festive gifts every year (Christmas, Spring Festival, Dragon Boat Festival, Mid-Autumn Festival)
6. There are also birthday gift money, wedding gift money, and birth gift money
7. 15 days paid annual leave, 2 days paid sick leave
To apply for a position, please contact:
Email : grace@funjobs.careers
WeChat : grace5348
Telegram: @grace5348
Contact Number : +6011 5755 4203