Trilliant offers a universal communications platform that is at the convergence of the smart grid, smart city, and global Industrial Internet of Things (IIoT) applications. We bring together multi-technology solutions, global capabilities, and mission-critical communications to deliver future-proof solutions.
We are a device-agnostic, integrated, multi-technology communication platform that provides flexibility to balance technological capabilities with economic needs. Trilliant is committed to best-in-class solutions that empower our customers and their customers to connect to the world of things.
We are an equal-opportunity employer offering comprehensive benefits and compensation packages with a selection of insurance programs. We have dynamic and collaborative work environments with some of the brightest employees in the world. We invest in people and provide opportunities for our employees to grow hand in hand with our business.
Job Description:
Trilliant is seeking a Senior MySQL Database Administrator with demonstrated expertise in Multisite Clustering to join our dynamic Global Support team. The ideal candidate will be responsible for installing, managing, maintaining, and optimizing our MySQL databases, ensuring high availability, performance, and security. This role requires a deep understanding of MySQL clustering, replication, backup, and recovery processes. This position reports to the VP of Global Support and IT.
Position Responsibilities:
- Install, configure, and maintain MySQL databases and clustering solutions.
- Monitor database performance, identify bottlenecks, and optimize queries and indexes.
- Implement and manage database backup and recovery processes.
- Ensure high availability and disaster recovery solutions for Percona Server for MySQL databases using Percona XtraDB Clustering
- Perform database upgrades, patches, and migrations.
- Close collaboration with development teams to design, implement database schemas and queries as well as application profiling for optimized DB tuning
- Troubleshoot and resolve database-related issues and provide technical support.
- Implement and enforce database security policies and procedures.
- Create and maintain documentation related to database configurations, processes, and procedures.
- Stay up-to-date with the latest MySQL features, best practices, and industry trends
- Database distribution biased toward internal Development and QE on premise and in the cloud but expect some customer interaction with support consultations and customer engagements.
Position Requirements:
- Proven experience as a (Percona) MySQL Database Administrator with 5 years+ of experience in Multisite Clustering.
- Strong knowledge of MySQL database architecture, replication, and clustering technologies.
- Experience with database performance tuning, query optimization, and indexing.
- Must have experience 3+ years of experience with Percona Server for MySQL, Percona XtraDB Cluster, Percona XtraBackup hot backup
- Additional distributions such as Maria DB or MySQL Enterprise with Galera Cluster or MySQL NDB Cluster desirable.
- Experience with other database technologies (e.g., PostgreSQL, Oracle, SQL Server, Orchestrator, ProxySQL, and HAProxy.
- Knowledge of scripting languages (e.g., Python, Bash) for automation.
- Experience with cloud-based database solutions (e.g., AWS RDS, Google Cloud SQL).
- Understanding of DevOps practices and tools (e.g., Docker, Kubernetes).
- Proficiency in backup and recovery processes and tools.
- Familiarity with database security best practices.
- Excellent problem-solving and troubleshooting skills.
- Strong communication and collaboration skills.
- Ability to work independently and as part of a team.
- Oracle, MySQL, MSSQL, In FluxDB experience are a plus.
Education/Certification:
- Bachelor’s degree in Computer Science, Information Technology, or a related field
- Relevant certifications centric in Percona clustering solutions
Trilliant Values-
PASSIONATE-We find the right solutions for customers and exceed their expectations.
ACCOUNTABLE-We work smart and tackle problems with urgency to get the job done.
CONFIDENT We look to the future and partner with each other to deliver world-class solutions.
ENERGIZED-We are excited and support the growth and direction of Trilliant.