Database Engineer
Spearhead Staffing Llc
Montebello, CA, United States
3 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.thejobnetwork.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours
Job source
Tech stack
Amazon Web Services
Microsoft Azure
Cloud Computing
Databases
Scientific Data Archiving
Data Centers
Data Governance
Data Loss
Data Structures
Database Schema
Shard (Database Architecture)
Elasticsearch
+14 more
Python (Programming Language)
MongoDB
MySQL
Online Databases
Oracle Databases
Oracle (Applications)
Performance Tuning
Redis
SQL Databases
Management of Software Versions
System Availability
Database Migration
Kubernetes
Vertica
Job description
- 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
We are currently seeking a 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., * 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., * 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
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.thejobnetwork.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…