Comcast - Norristown, PA

posted 4 months ago

Full-time - Senior
Norristown, 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 reliability and performance of our database systems. Your primary responsibilities will include managing database availability, latency, performance, efficiency, change management, monitoring, emergency response, and capacity planning for the FreeWheel platforms. You will engage in designing, analyzing, and troubleshooting large-scale distributed systems, as well as debugging and optimizing existing code. Automation of routine tasks will also be a key focus of your role. You will be part of a diverse team that combines software and technology infrastructure expertise, providing subject matter database knowledge and resolving complex database layer issues. Collaboration with engineering, vendors, and client services will be essential to deliver successful database technical solutions. You will work with limited supervision, independently determining approaches for non-routine solutions while adhering to operational practices. Your core responsibilities will include implementing technical solutions to enhance the reliability, quality, and efficiency of the FreeWheel platforms' database layer. You will review all database data, schema changes, and application changes requiring database access, ensuring safe execution of all database changes according to release schedules. Additionally, you will optimize database parameters for improved performance and stability, enhance database architecture, enforce security measures, and design monitoring and alert systems. You will also be responsible for fulfilling on-call duties to meet service level agreements and developing automation tools to boost operational efficiency. Training and coaching of peers and junior team members will be part of your responsibilities as well.

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

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 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
  • 401k retirement savings plan
  • Paid time off and holidays
  • Tuition reimbursement
  • Professional development opportunities
  • Employee discounts on Comcast services
  • Flexible work hours and remote work options
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service