Mysql Database Administrator @ Veeva Systems

Mysql Database Administrator

Posted on 2/7/2023

INACTIVE

Locations

Toronto, ON, Canada

Experience Level

Entry

Junior

Mid

Senior

Expert

Desired Skills

AWS

Linux/Unix

Management

MySQL

Perl

Postgres

SQL

Terraform

Python

Ansible

Requirements

BS/BA Degree in Computer Science or equivalent industry experience
5+ years of experience as a MYSQL DBA
2+ years of experience with Linux-based systems
Experience with high-availability database solutions and architectures
Experience implementing a variety of data models, data access, and table maintenance codes
Extensive experience resolving moderate to complex DB performance and capacity issues, replications, etc
Experience in configuration, upgrade, maintenance, and security
Experience executing MYSQL database backups, restores, and replication
Advanced level knowledge of SQL
Extensive experience working within structured change management processes
Experience with process automation as it applies to the provisioning of resources within DB Engineering

Responsibilities

Use backup and recovery best practices to ensure systems are protected from data loss in compliance with established business continuity and DR practices
Define, develop, and deploy system monitoring requirements/thresholds as well as corrective actions
Document all operational processes and procedures to optimize support and management of deployed systems
Production Operations tasks
Provide 24x7x365/On Call support within a rotation
Contribute towards new and ongoing Technology projects in areas of Scalability, Performance, and High Availability
Responsible for space management, backup, monitoring, and DB performance
Collaborate

Desired Qualifications

Scripting skills in any UNIX shell, Perl, and/or Python
Software as a service [SaaS]
Ability to develop requirements for the tool sets needed to streamline and automate system installation and configuration procedures
Experience developing ansible and/or Terraform scripting
Experience building, supporting, and troubleshooting multi-tier, high-volume, production web installations (Load balanced server pools, App/DB, tier, etc)
AWS RDS/Aurora replication, backup, and configuration management
Experience with DB monitoring and log management software
Implementation/authoring of operational procedures
Develop processes for optimizing database security
Postgres administration
Slow query diagnosing

Veeva [NYSE: VEEV] is the leader in cloud-based software for the global life sciences industry. Committed to innovation, product excellence, and customer success, our customers range from the world’s largest pharmaceutical companies to emerging biotechs. Veeva’s software helps our customers bring medicines and therapies to patients faster.

We are the first public company to become a Public Benefit Corporation. As a PBC, we are committed to making the industries we serve more productive, and we are committed to creating high-quality employment opportunities.

Veeva is a Work Anywhere company which means that you can choose to work in the environment that works best for you - on any given day. Whether you choose to work remotely from home or work in an office - it’s up to you.

The Role

Veeva Systems is looking for a bright, energetic, self-motivated Senior Database Administrator focused on customer-facing production infrastructure. This is a hands-on position and will work closely with the Operations, Engineering, and Support teams. You must be a strong team player that thrives working with speed in a fluid entrepreneurial environment. If you have at least 8 years of experience supporting primarily MySQL database and other database flavors servers in Production IT or customer-facing SaaS environments, we want to hear from you!

What You’ll Do

Use backup and recovery best practices to ensure systems are protected from data loss in compliance with established business continuity and DR practices
Define, develop, and deploy system monitoring requirements/thresholds as well as corrective actions
Document all operational processes and procedures to optimize support and management of deployed systems
Production Operations tasks
Provide 24x7x365/On Call support within a rotation
Contribute towards new and ongoing Technology projects in areas of Scalability, Performance, and High Availability
Responsible for space management, backup, monitoring, and DB performance
Collaborate

Requirements

BS/BA Degree in Computer Science or equivalent industry experience
5+ years of experience as a MYSQL DBA
2+ years of experience with Linux-based systems
Experience with high-availability database solutions and architectures
Experience implementing a variety of data models, data access, and table maintenance codes
Extensive experience resolving moderate to complex DB performance and capacity issues, replications, etc.
Experience in configuration, upgrade, maintenance, and security
Experience executing MYSQL database backups, restores, and replication
Advanced level knowledge of SQL
Extensive experience working within structured change management processes
Experience with process automation as it applies to the provisioning of resources within DB Engineering

Nice to Have

Scripting skills in any UNIX shell, Perl, and/or Python
Software as a service [SaaS]
Ability to develop requirements for the tool sets needed to streamline and automate system installation and configuration procedures
Experience developing ansible and/or Terraform scripting
Experience building, supporting, and troubleshooting multi-tier, high-volume, production web installations (Load balanced server pools, App/DB, tier, etc)
AWS RDS/Aurora replication, backup, and configuration management
Experience with DB monitoring and log management software
Implementation/authoring of operational procedures
Develop processes for optimizing database security
Postgres administration
Slow query diagnosing

#LI-RemoteCanada

#BI-Remote

Veeva’s headquarters is located in the San Francisco Bay Area with offices in more than 15 countries around the world.

Veeva is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity or expression, religion, national origin or ancestry, age, disability, marital status, pregnancy, protected veteran status, protected genetic information, political affiliation, or any other characteristics protected by local laws, regulations, or ordinances. If you need assistance or accommodation due to a disability or special need when applying for a role or in our recruitment process, please contact us at [email protected]

1,001-5,000 employees

Website

Cloud computing services for pharmaceutical companies.

Company Overview

Veep's mission is to help R&D, quality, and regulatory teams eliminate inefficiencies and bring high-quality, safe, sustainable products to market without compromising quality. The company builds cloud-based tools for pharmaceutical research.

Benefits

Parental leave
PTO
Free food
Health, dental, & vision insurance
Gym membership reimbursement

Company Core Values

Do the Right Thing
Customer Success
Employee Success
Speed