Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

Hi, I’m Leo Yuan. I am a senior database engineer with 21 years of IT experience, including 12 years in database administration. I specialize in Oracle and MySQL, Data Guard, GoldenGate, high availability architectures, SQL optimization, and performance tuning for high-concurrency environments. I also develop shell scripts, Python applications, and Flask-based APIs to support data workflows and analytics. I thrive on designing scalable data architectures, enabling reliable data delivery across enterprise systems, and collaborating with cross-functional teams to drive data-driven decisions. I’m seeking a DBA role in Chengdu that leverages my deep hands-on experience with Oracle, MySQL, PostgreSQL, and hybrid data platforms.…Hi, I’m Leo Yuan. I am a senior database engineer with 21 years of IT experience, including 12 years in database administration. I specialize in Oracle and MySQL, Data Guard, GoldenGate, high availability architectures, SQL optimization, and performance tuning for high-concurrency environments. I also develop shell scripts, Python applications, and Flask-based APIs to support data workflows and analytics. I thrive on designing scalable data architectures, enabling reliable data delivery across enterprise systems, and collaborating with cross-functional teams to drive data-driven decisions. I’m seeking a DBA role in Chengdu that leverages my deep hands-on experience with Oracle, MySQL, PostgreSQL, and hybrid data platforms.

Leo Yuan

Database Developer, Back-End Developer, Web Developer, +2





Hi, I’m Leo Yuan. I am a senior database engineer with 21 years of IT experience, including 12 years in database administration. I specialize in Oracle and MySQL, Data Guard, GoldenGate, high availability architectures, SQL optimization, and performance tuning for high-concurrency environments. I also develop shell scripts, Python applications, and Flask-based APIs to support data workflows and analytics. I thrive on designing scalable data architectures, enabling reliable data delivery across enterprise systems, and collaborating with cross-functional teams to drive data-driven decisions. I’m seeking a DBA role in Chengdu that leverages my deep hands-on experience with Oracle, MySQL, PostgreSQL, and hybrid data platforms.…Hi, I’m Leo Yuan. I am a senior database engineer with 21 years of IT experience, including 12 years in database administration. I specialize in Oracle and MySQL, Data Guard, GoldenGate, high availability architectures, SQL optimization, and performance tuning for high-concurrency environments. I also develop shell scripts, Python applications, and Flask-based APIs to support data workflows and analytics. I thrive on designing scalable data architectures, enabling reliable data delivery across enterprise systems, and collaborating with cross-functional teams to drive data-driven decisions. I’m seeking a DBA role in Chengdu that leverages my deep hands-on experience with Oracle, MySQL, PostgreSQL, and hybrid data platforms.

Available to hire

Hi, I’m Leo Yuan. I am a senior database engineer with 21 years of IT experience, including 12 years in database administration. I specialize in Oracle and MySQL, Data Guard, GoldenGate, high availability architectures, SQL optimization, and performance tuning for high-concurrency environments. I also develop shell scripts, Python applications, and Flask-based APIs to support data workflows and analytics.

I thrive on designing scalable data architectures, enabling reliable data delivery across enterprise systems, and collaborating with cross-functional teams to drive data-driven decisions. I’m seeking a DBA role in Chengdu that leverages my deep hands-on experience with Oracle, MySQL, PostgreSQL, and hybrid data platforms.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Intermediate

Intermediate

Intermediate

Intermediate

Intermediate

Language

Chinese

Fluent

English

Advanced

Work Experience

Senior Database Engineer at Jinju Digital Technology (Chengdu) Information Technology Co., Ltd.

April 1, 2023 - Present

Senior Database Engineer responsible for Earthquake Bureau data migration and maintenance, and database architecture for Shenzhen Metro Line 13 Security Inspection System. Key tasks included maintaining two IBM minicomputers on AIX 5.3 with Oracle 10.2.0.5 ASM RAC; implementing RMAN backup plans (full weekly, incremental daily), and EXPDP exports for three instances daily. Led migration tests and real-time status reporting to the Western Region Technical Director; planned and executed data migration to new storage, added ASM storage, synchronized data, and decommissioned old storage. Also designed and maintained a 16-site master/17-slave MySQL architecture with MHA, deployed MaxScale for read-write separation, and implemented lossless network interruption tolerance so stations can operate offline and access historical and real-time records. Performed data denormalization, secondary partitioning by site/year/month, and wrote procedures and views to support analytics. Provided Linux and

Senior Database Engineer at Chengdu Yuntu Holding Co.

March 1, 2021 - April 1, 2023

Maintain multiple enterprise data platforms including Oracle 11g DataGuard, 19c ADW, and GoldenGate pipelines for EKP OA, Holly CRM, SAP; perform physical machine upgrades and database migrations to new hardware and hyper-converged infrastructure. Manage two Oracle 11g DataGuard master-slave setups and a 19c ADW data warehouse, plus GoldenGate replication scenarios and RMAN-based backups with weekly full and daily incremental/differential backups. Migrate and optimize MySQL environments (5.6/5.7) to trustable master-slave setups with MHA, achieve strong consistency via binlog replication, and implement multi-tier backups (local/NAS/EXPDP). Oversee 365-field PostgreSQL 12 with physical replication and assist developers with SQL development, optimization, and data warehousing workflows. Coordinate system integration with SQL Server and orchestrate data docking between multiple systems.

Senior MySQL DBA at Shanghai Action Information Technology Company Limited (Chengdu Office)

June 1, 2018 - February 28, 2021

Provide MySQL technical support for Chongqing Mobile DBAs, including read-write separation (Atlas), MySQL proxy support, xtrabackup-based backups, and MHA-based master-slave failover. Support cloud docking for China Mobile Suzhou Research Institute (RDS integration), implement resource isolation and performance tuning with cgroups, and migrate production MySQL instances to cloud environments. Manage large-scale DBLE clusters (10 TB+), including shard deployment, partitioning, and pre-sharding strategies; ensure high availability, data integrity, and production reliability. Build monitoring with SNMP-based alerts and assist developers with SQL optimization and data model improvements.

Senior DBA at Laiyi Financial Technology (Shanghai) Co.

February 1, 2017 - May 31, 2018

Plan and implement MySQL backup and recovery systems (master-slave, cross-machine, off-site), automate backup and monitoring with shell and Python, and validate backup integrity. Optimize MySQL performance with slow query tuning, partitioning, and Percona Toolkit usage (pt-archiver, pt-table-sync, pt-summary). Build automated monitoring for databases and business metrics using Zabbix and custom scripts; manage Redis and Mongo clusters for data analytics. Deploy and maintain Oracle 11g Dataguard, design RMAN backups, and support developers with Oracle procedure and view development. Lead junior DBAs and guide architecture decisions for scalable DB clusters.

DBA at Spring Airlines Co.

September 1, 2014 - February 28, 2017

Build and maintain high-concurrency MySQL platforms with master-slave replication (MMM), implement Redis/Sentinel-based high-availability and data sharding, and manage a Hadoop-based data layer with MySQL integration. Set up monitoring with Nagios and Cacti, optimize SQL with EXPLAIN and slow query analysis, and guide developers on SQL design and performance improvements. Implement off-site disaster recovery with Shanghai-Wuxi failover and develop data reporting workflows.

Operation and Maintenance Supervisor at Beijing Dot Play Weiye Software Technology Co.

August 1, 2013 - September 30, 2014

Oversee O&M for multiple Oracle/MariaDB/MYSQL databases across external and internal environments. Implement RMAN and EXP/EXPDP for Oracle backups, build remote backup via NFS/SCP with SSH keys, and monitor backups and scripts. Optimize Oracle memory, connections, and character sets; apply performance improvements to MySQL/MariaDB, and implement master-master and master-slave clusters with proxies and MMM. Develop monitoring scripts (SNMP, Nagios, Cacti) and create dashboards for uptime and performance. Guide development teams on database design, SQL optimization, and integration with Oracle and SQL Server systems.

System Engineer at Shanghai Asia Pacific Computer System Co.

June 1, 2009 - August 31, 2013

Maintain ETC clearing center network and servers, establish high availability for apps (Heartbeat) and databases (RoseMirreHA), implement dual NIC binding, and manage data flow with Radware load balancing. Design and implement disaster recovery networks and documentation, including topology diagrams and project budgets. Oversee network security, server integrity, and database availability; support a multi-site, high-availability environment with Oracle and MySQL systems.

System Engineer at Shanghai He jia Shopping Co.

August 1, 2004 - May 31, 2008

Plan and implement network architecture for headquarters and branches, manage Windows domain services and user policies, and oversee servers and Oracle databases. Build and maintain redundancy, backup strategies (RMAN, NetBackup), and network security (VPN, firewalls). Configure monitoring and alerting, automate installations, manage Red Hat, Apache, Oracle 9.x, and PHP stack environments, and support IT operations for an enterprise-scale e-commerce system.

System Engineer at Guangdong Yi xun Technology Co.

May 1, 2008 - June 30, 2009

Develop and optimize system architecture for Shanghai Telecom projects. Manage SAN storage networks, backup strategies, and high-availability setups using Linux/Unix/Windows, Hitachi storage, Dell tape libraries, and NetBackup. Implement load balancing with Apache and RosaMirrorHA, ensure system reliability through automated bash scripts and alerting, and perform Oracle 10g SQL scripting, patching, RAC maintenance, RMAN backups, and recovery procedures.