Who We AreThe RoleThis position is responsible for acting as a primary technical resource for the support and administration of MySQL or Postgres in both large-scale production and development environments across multiple products.
This position continually evaluates the entire MySQL or Postgres topology to identify and create plans to address performance issues, architectural shortcomings, and other opportunities for improvement.
The fundamental goal is to ensure the production environment is always operational and performing optimally.
This position requires strong organizational and collaboration skills and partnering with numerous distributed teams is a must for success.This position is a key resource contributing to the technical growth and development of the SQL DBA team through mentoring and training of other team members.What You'll DoEnsure production MySQL or Postgres maintain the company's requirements for HADR, Security, and RPORTO.Provide on-call support (as part of a rotation) for production alerts or issues both during and outside normal working hours.Provide support during maintenance windows or deployment/release activities.Join war-room calls to triage and troubleshoot outages as they occur, including after-hours and weekends.Build and improve automation around configuring and administering MySQL or Postgres.Optimize performance of MySQL or Postgres and determine the most effective ways to increase performance including hardware purchases, server configuration changes, or index/query changes.Continuous evaluation and implementation of proactive measures to improve performance and stability of MySQL or Postgres.Create and maintain procedural and technical documentation.Collaborate with other teams in enterprise-level projects and provide support guidance as needed.Lead assigned quarterly projects from initial concept and drive to successful completion.Identify technical developmental opportunities and provide guidance to Mid and Junior Level DBA team members.What You'll BringBachelor's Degree in Information Systems, Computer Science or related field or related experience.Experience Requirements: Experience in large MySQL or Postgres environments (8+ years preferred).Excellent communication and collaboration skills, excellent organizational skills, proven ability to prioritize multiple activities and objectives to thrive in a rapidly changing environment.Ability to write effective technical documentation with attention to detail and accuracy.Familiarity with SQL Monitoring and Alerting Management systems.In-depth knowledge of MySQL or Postgres HA (Stream, Clusters).Project Management skills.Ability to manage and maintain ETL & DW processes.On-call troubleshooting within a 24/7 production environment and providing escalation support as necessary.Expert knowledge of MySQL or Postgres 10 and up.#J-18808-Ljbffr