We are currently seeking a Sr. Database Engineer for our Logistics client in Montebello, CA. This person will need to be fluent in Manderine, have 5+ years of experience as a DBA, deep MYSQL, Oracle familiarity, and large scale migration experience. The position is fully on-site with some travel as needed.
Responsibilities Core Database Operations:
Responsible for high-availability deployment, daily monitoring, backup and recovery, and troubleshooting of the company's MySQL, OceanBase, Redis, MongoDB, and Oracle databases.
Large-Scale Migration & Upgrades:
Lead TB-level online database migrations across data centers and across clouds, such as Azure / AWS, version upgrades, and data archiving projects, ensuring zero business interruption and zero data loss.
Performance Optimization & Stability:
Analyze slow queries and design appropriate indexes; optimize Redis cache hit rate and MongoDB aggregation pipeline performance; resolve high-concurrency bottlenecks such as logistics trajectory write peaks and inventory deduction.
Architecture Design & Standards:
Participate in business database schema reviews; develop sharding solutions, such as ShardingSphere / Proxy, and read-write separation solutions; refine DBA operations SOPs and full-lifecycle data governance.
Automation & Cost Management:
Develop automated operations tools, including backup verification, health inspection, and capacity forecasting.
Collaborative Support:
Work with development and operations teams to diagnose and fix database-related issues for the logistics order system, POS / DMS, real-time dashboards, and more. Requirements Bachelor's degree or above in a computer-related major, with 5+ years of DBA experience, including at least 3 years of DBA experience in large-scale online production environments with average daily QPS > 10,000.
Deep MySQL expertise:
familiar with InnoDB internals, GTID replication, Orchestrator high availability, and hands-on sharding experience.
Redis proficiency:
familiar with 5+ data structures, persistence mechanisms such as RDB / AOF, cluster scaling, hot-key governance, and big-key governance.
Oracle familiarity:
daily operations and performance optimization.
Large-scale migration experience:
led at least 2 TB-level cross-data-center / cross-cloud smooth database migration projects using tools such as DTM, OMS, or gh-ost.
Performance tuning ability:
able to independently perform deep optimization across hardware, operating system, database parameters, SQL, and architecture, and produce quantifiable reports.
Preferred Qualifications:
DBA experience with cross-border logistics, e-commerce, or financial transaction systems, with an understanding of multi-region data compliance such as GDPR. Familiarity with other databases, including TiDB, ClickHouse, and Elasticsearch. Proficiency in Python / Go / Shell, with experience building automated DBA tool platforms. Cloud vendor certifications, such as AWS SAA / DOP or Alibaba Cloud ACP / ACE, or database certifications such as OCP or MCDBA. Experience operating stateful databases in Kubernetes environments
Review key factors to help you decide if the role fits your goals.