Database Administrator

Full Job Description

Doo Group is a global fintech company headquartered in Singapore with regional presence around the world including Kuala Lumpur, Hong Kong, Dubai, London, Sydney and more.

With 6 major business lines strategically positioned in global markets, including Brokerage (Doo Clearing, Doo Financial, Doo Prime), Wealth Management (Doo Wealth), Payment Exchange (Doo Payment), FinTech (FinPoints), Financial Education (Doo Academy) and Health Care (Doo Health). Doo Group is actively building a comprehensive financial ecosystem, helping you to achieve an ideal financial life and towards α better future together!

Job objectives:

• You will play a pivotal role in the design, development, and optimization of various financial business systems.
• We are seeking a talented individual with a passion for creating highly scalable systems capable of handling complex business needs.
• Your responsibilities will include enhancing middleware for fintech companies, contributing to a fast-paced, mission-driven organization with endless opportunities to learn and excel.

Responsibilities & duties

• Build a robust database disaster recovery or active-active environment across dual-availability zones in two regions and three centers, aiming for a 99.9% uptime to ensure the reliability of the database system.
• Implement effective preventive measures for data availability and security, including the establishment of homogeneous and heterogeneous backup and recovery processes, reaching levels as granular as 1-minute or even seconds.
• Deploy and maintain database and core middleware cluster environments, addressing technical issues and optimizing SQL statements and overall performance.
• Establish O&M specifications for databases and core middleware, and build CD tools and processes.
• Formulate user data security audit specifications and standards to meet financial compliance requirements.
• Provide guidance and evaluation in database design during the software design stage.
• Improve database and core middleware monitoring and alarming, ensuring a closed loop for monitoring alarm response processing.
• Establish a comprehensive inspection system, including short-term manual inspections and long-term automatic inspections with built-in automatic trend problem awareness capabilities.
• Quantify the output of the DB team's work through SLA/SLO/SLI at the database level, guiding management efforts to enhance the stability of business systems.
• Prepare and share DB-related documents and technical achievements regularly with all employees.
• Undertake other related tasks as assigned.

Job requirements:

• Availability for middle shift hours (14:00 - 24:00).
• Bachelor's Degree or above in computer, communication, or other IT-related majors.
• Over 5 years of practical experience with a spirit of independent experimentation and research.
• More than 3 years of experience in maintaining the production environment of medium and large Internet/financial enterprises.
• Proficiency in both written and spoken Mandarin and English for communication across cross-functional and regional teams.
• Proficient in Xenon MySQL, Redis, OceanBase, ClickHouse, PgSQL, MongoDB, Elasticsearch cluster, master-slave, distributed architecture operating principles, architecture design, and data structure design.
• Familiarity with MySQL and Redis master-slave replication, read/write separation, database sharding, and table design, including knowledge of various MySQL branches such as MariaDB.
• Thorough understanding of various database selection and comparison methods, benchmark stress testing, troubleshooting, and performance tuning.
• Proficient in CentOS/Debian mainstream Linux operating systems, Linux shell, and database performance tuning analysis and troubleshooting.
• Familiarity with mainstream storage types and RAID levels to rationalize the performance of different types of databases.
• Proficiency in at least one programming language like Python, Golang, Java, or C, with a strong focus on network programming.
• Collaborative mindset, working seamlessly with business projects and avoiding isolated technology decisions.
• Keep abreast of the latest trends in SQL and NoSQL technologies, applying them to enhance business systems.

#DooBeyondLimit

#SucceedYourCareerWithDoo

#TogetherWeDooMore