Sr. Database Administrator

Who We Are

Solera is a global leader in data and software services that strives to transform every touchpoint of the vehicle lifecycle into a connected digital experience. In addition, we provide products and services to protect life’s other most important assets: our homes and digital identities. Today, Solera processes over 300 million digital transactions annually for approximately 235,000 partners and customers in more than 90 countries. Our 6,500 team members foster an uncommon, innovative culture and are dedicated to successfully bringing the future to bear today through cognitive answers, insights, algorithms and automation.  For more information, please visit solera.com.

The Role
This 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 Do

• Ensure 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 Bring

Bachelor’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)
• Demonstrable skills in configuration, maintenance, and administration of MySQL or Postgres systems and applications
• 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 SQL Monitoring and Alerting Management systems
• In-depth knowledge of MySQL or Postgres HA (Stream, Clusters)
• Project Management skills
• Ability to manage 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
• Ability to communicate clearly and effectively with various departments such as Engineering, IT Infrastructure, Project Management, etc...
• Solid experience with MySQL or Postgres in Kubernetes, VMware platforms
• Agile Methodology familiarity
• Experience using Bash, Python, Perl scripting techniques to manage a large environment
• ANSI SQL
• In-depth Windows operating system knowledge

Physical Demands (Travel, etc.)

• Attend training conferences and sessions that may require travel
• While on-call be available by phone 247 and be able to get online immediately should an outage occur

It is impossible to list every requirement for, or responsibility of, any position.  Similarly, we cannot identify all the skills a position may require since job responsibilities and the Company’s needs may change over time.  Therefore, the above job description is not comprehensive or exhaustive.   The Company reserves the right to adjust, add to or eliminate any aspect of the above description.  The Company also retains the right to require all employees to undertake additional or different job responsibilities when necessary to meet business needs.