Sr. Database Administrator - MySQL

FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we’re making it easier for buyers and sellers to transact across all screens, data types, and sales channels. As a global company, we have offices in nine countries and can insert advertisements around the world.

Job Summary

As the Senior Database administrator, you will be responsible for the database availability, latency, performance, efficiency, change management, monitoring, emergency response, and capacity planning for the DB part of FreeWheel platforms. You will focus on the FreeWheel Database will engage in designing, analyzing and troubleshooting large-scale distributed systems, debugging /optimizing existing code, and automating routine tasks. You will be part of a team consisting of a healthy mix between software and technology infrastructure backgrounds, provide subject matter database expertise, resolve complex database layer break/fix scenarios and engage broader teams as necessary, partner with engineering, vendors and client services to deliver successful database technical solutions. You shall work with limited supervision and direction while executing associated functions and responsibilities, follows operational practices and independently determines/develops approaches for non-routine solutions.

Job Description

Core Responsibilities

• Be responsible for database reliability and technical operation of FreeWheel Platforms.
• Implement technical solutions for measurement and improvement on reliability / quality / efficiency of FreeWheel platforms’ DB layer.
• Review all DB data, schema changes, and application changes requiring database access.
• Safely execute all DB changes according to release cadence and ad-hoc needs.
• Optimize database parameters for better performance and stability.
• Enhance DB architecture evolution, including HA, DR, data consistency, security, version selection & upgrade, cost analysis, and control.
• Enforce security measures, support, review, and implement all DB-related processes.
• Design, implement, and enhance monitoring & alert systems from system and DB perspectives.
• Fulfill 12X7 (potentially extend to 24x7 as needed) on-call duties to meet SLA/SLO.
• Develop and implement DB automation tools to boost operational efficiency.
• Provide support for the Cybersecurity program needs such as DB patching, vulnerability cleanup, secure server configuration, testing and validation, technical controls implementation and cybersecurity DB incident remediation efforts.
• Provide training and coaching to peers and more junior SRE team members.
• Regular, consistent and punctual attendance. Must be able to work nights and weekends, variable schedule(s) and overtime as necessary.
• Other duties and responsibilities as assigned.

Minimum Requirements

• Bachelor’s degree in computer science, a related engineering field, or equivalent practical experience.
• 7+ years managing, tuning, backing up (full/incremental) MySQL databases (or other popular RDBMS) replication cluster
• Expert level MySQL DB knowledge required & preferred experience with Aurora/DynamoDB/MongoDB/Cassandra/ClickHouse/SQL Server/PostgreSQL/Areospike/Snowflake/Hive/HBase/Elasticsearch/NEO4J
• Open for and interested in extending your knowledge and scope to new DB types per FreeWheel business requirement
• Must have software development experience in GoLang or Python. Experience with Ansible, VUE.js, CSS, JavaScript, java, C/C++ is a plus.
• Must have AWS Cloud platform experience. GCP & Azure experience is a plus.
• Knowledge and experiences of Linux/Unix like: Redhat, Debian, CentOS, RockyLinux, and very basic network knowledges (Router, Switch, Firewall etc.) is must to have.
• Familiar with monitoring tools such as Prometheus, Kibana/Grafana, ELK, Nagios etc.
• Experienced at working with geographically distributed (WAN based) systems
• A working knowledge Nginx, NetScaler, VPLS, GSLB, Storage (like: PureStorage, Cohesity ...)
• Experienced at troubleshooting, designing and building reliable, fault tolerant systems is a plus
• Good communication and collaboration, within/across team(s) and continents.
• Work / Shift Timings: Be able to work during on-call schedule: usually 12.5 hours a day including weekend.
• Selected candidate will be expected to work Eastern Standard hours.

Preferred requirements

• Prior experience in supporting business-critical DB services before they go live through activities such as DB system design consulting, developing software platforms and frameworks, capaci