Sr. Database Administrator - MySQL

Company: Comcast Corporation
Location: Erie
Posted on: September 5, 2024

Job Description:

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 SummaryAs 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 DescriptionCore 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, 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.Employees at all levels are expected to:
      • Understand our Operating Principles; make them the guidelines for how you do your job.
      • Own the customer experience - think and act in ways that put our customers first, give them seamless digital options at every touchpoint, and make them promoters of our products and services.
      • Know your stuff - be enthusiastic learners, users and advocates of our game-changing technology, products and services, especially our digital tools and experiences.
      • Win as a team - make big things happen by working together and being open to new ideas.
      • Be an active part of the Net Promoter System - a way of working that brings more employee and customer feedback into the company - by joining huddles, making call backs and helping us elevate opportunities to do better for our customers.
      • Drive results and growth.
      • Respect and promote inclusion & diversity.
      • Do what's right for each other, our customers, investors, and our communities.Disclaimer:
        • This information has been designed to indicate the general nature and level of work performed by employees in this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications.
        • *This position is unable to provide work authorization sponsorship or immigration support now or in the future. *Comcast is proud to be an equal opportunity workplace. We will consider all qualified applicants for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, genetic information, or any other basis protected by applicable law. Comcast will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law, including the Los Angeles Fair Chance Initiative for Hiring Ordinance and the San Francisco Fair Chance Ordinance.Salary:National Pay Range: $82,979.72 USD-$194,483.72 USDComcast intends to offer the selected candidate base pay within this range, dependent on job-related, non-discriminatory factors such as experience. The application window is 30 days from the date job is posted, unless the number of applicants requires it to close sooner or later.Additionally, Comcast provides best-in-class Benefits to eligible employees. We believe that benefits should connect you to the support you need when it matters most, and should help you care for those who matter most. That's why we provide an array of options, expert guidance and always-on tools, that are personalized to meet the needs of your reality - to help support you physically, financially and emotionally through the big milestones and in your everyday life. Please visit the on our careers site for more details.EducationBachelor's DegreeWhile possessing the stated degree is preferred, Comcast also may consider applicants who hold some combination of coursework and experience, or who have extensive related professional experience.Relevant Work Experience7-10 Years

Keywords: Comcast Corporation, Erie , Sr. Database Administrator - MySQL, Other , Erie, Pennsylvania