Lead Database Administrator

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

📋 Description

• Oversee daily database operations, encompassing backup management, resolution of slow queries, and performance optimization.

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

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

• Develop detailed execution plans and convey technical considerations along with business implications to stakeholders.

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

• Measure and enhance system performance.

• Lead the automation of database platform management and monitoring processes.

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

• Document procedures, best practices, and troubleshooting methodologies.

• Organize, prioritize, and estimate tasks utilizing Jira.

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

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

⛳️ Requirements

• Advanced experience in administering MySQL in production environments, whether on-premise or in the cloud.

• Strong knowledge of Linux system administration and networking concepts.

• Experience as the primary or lead owner of substantial production database infrastructure within a SaaS context, with responsibility for availability and performance.

• Proven experience coordinating with external technical stakeholders and following light change management protocols.

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

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

• Working knowledge of database monitoring tools, performance thresholds, and response protocols.

• Extensive expertise in query tuning, analyzing slow queries, and optimizing schemas, including normalization, partitioning, query rewrites, and indexing strategies.

• Demonstrated experience in executing minimal-downtime upgrades and complex migrations.

• Highly adept at automating processes using Python and/or Bash with well-structured, version-controlled scripts.

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

• Willingness to learn necessary technologies.

• Enthusiasm for development, new technologies, and innovation.

🏝️ Benefits

• 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.

• Flexible work environment.