Lead Database Administrator

This is a fully remote position, open to applicants in United States, +2 more locations.

📋 Description

• Assume full responsibility for day-to-day database operations, including managing backups, troubleshooting slow queries, and optimizing performance.

• Design, secure, and maintain the underlying Linux servers that support distributed databases.

• Plan, oversee, and execute database upgrades and migrations.

• Develop detailed execution plans and effectively communicate technical considerations and business implications to non-technical stakeholders.

• Assess incoming tasks, delegate as necessary, and serve as the primary escalation point for database issues.

• Evaluate and enhance system performance.

• Spearhead the automation of management and monitoring of the database platform infrastructure.

• Collaborate with development teams, product owners, and stakeholders to fulfill database requirements.

• Enhance the testability of database components within software deployments.

• Document procedures, best practices, and troubleshooting methodologies.

• Organize, prioritize, and estimate tasks using Jira.

• Provide essential database support during and outside regular business hours.

• Mentor and guide engineers on database design, optimization, and migration techniques.

⛳️ Requirements

• Advanced skills in administering MySQL in production settings, whether on-premise or in the cloud.

• Strong knowledge of Linux system administration and networking concepts.

• Experience as the primary or lead owner for extensive production database infrastructure within a SaaS context.

• Responsibility for database uptime and performance.

• Experience collaborating with external technical stakeholders and following light change management protocols.

• Advanced proficiency in configuring and troubleshooting MySQL replication setups, including primary-replica, multi-master, and GTID configurations.

• Capability to address replication lag, manage failovers, and implement disaster recovery strategies.

• Working knowledge of database monitoring tools and methodologies.

• In-depth expertise in query optimization, slow query analysis, and schema refinement, including normalization, partitioning, query rewrites, and indexing techniques.

• Proven track record of carrying out minimal-downtime upgrades and intricate migrations.

• Highly proficient in automating database processes using Python and/or Bash.

• Experience in securing database infrastructures through SSL/TLS encryption, user access controls, audit logging, and automated backup encryption.

• Willingness to learn necessary technologies.

• Interest in development, emerging technologies, and innovation.

🏝️ Benefits

• Competitive salary.

• Flexible work environment.

• Flexible Time Off Policy – Take the time you need.

• Enhanced parental leave (16 weeks for birth parent, 8 weeks for non-birth parent at full pay).

• Regular company events and activities.

• Comprehensive Company Sponsored Health & Welfare Benefits.

• 401k Plan – 4% employee match.

• Enhanced Wellness Program, including access to EAP, Wellness Coaching & Wellness Fridays program.