Comcast - Erie, PA

posted 3 months ago

Full-time - Senior
Erie, PA
Broadcasting and Content Providers

About the position

As the Senior Database Administrator at FreeWheel, a Comcast company, you will play a critical role in ensuring the availability, performance, and efficiency of our database systems. Your primary focus will be on the FreeWheel Database, where you will engage in designing, analyzing, and troubleshooting large-scale distributed systems. This position requires a deep understanding of database management, as you will be responsible for monitoring, emergency response, and capacity planning for the database components of FreeWheel platforms. You will work closely with a team that combines software and technology infrastructure expertise, providing subject matter database knowledge and resolving complex database issues as they arise. In this role, you will implement technical solutions aimed at improving the reliability and quality of the FreeWheel platforms' database layer. You will review all database data, schema changes, and application changes that require database access, ensuring that all changes are executed safely and in accordance with our release cadence. Your responsibilities will also include optimizing database parameters for enhanced performance and stability, as well as enhancing the database architecture to support high availability, disaster recovery, data consistency, and security measures. You will be expected to design and implement monitoring and alert systems from both system and database perspectives, fulfilling on-call duties to meet service level agreements. Additionally, you will develop and implement database automation tools to improve operational efficiency and support cybersecurity initiatives, including database patching and vulnerability management. Training and coaching junior team members will also be part of your responsibilities, ensuring that knowledge is shared and best practices are followed across the team.

Responsibilities

  • Be responsible for database reliability and technical operation of FreeWheel Platforms.
  • Implement technical solutions for measurement and improvement on reliability, quality, and 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 high availability, disaster recovery, 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.

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/SQLServer/PostgreSQL/Aerospike/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 knowledge (Router, Switch, Firewall etc.) is a 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 of Nginx, NetScaler, VPLS, GSLB, Storage (like: PureStorage, Cohesity ...) is a plus.
  • Experienced at troubleshooting, designing and building reliable, fault tolerant systems is a plus.
  • Good communication and collaboration skills, within/across team(s) and continents.

Nice-to-haves

  • 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, capacity planning and launch reviews.
  • Technical leadership and influence demonstrated in focused product/tech areas and practices.
  • Prior experience of providing DB technical solutions at an internet company.

Benefits

  • Comprehensive health insurance coverage.
  • 401(k) retirement savings plan with company matching.
  • Paid time off and holidays.
  • Tuition reimbursement for further education.
  • Flexible work hours and remote work options.
  • Employee discounts on Comcast services and products.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service