Cloud Engineer - MySQL Focus

Belfast

Contrast Security logo
Contrast Security
Apply now Apply later

Posted 2 weeks ago

Contrast Security named to Inc.'s “Best Workplaces of 2020”
Contrast Security is the world’s leading provider of security technology that enables software applications to protect themselves against cyberattacks, heralding the new era of self-protecting software. Contrast's patented deep security instrumentation is the breakthrough technology that enables highly accurate assessment and always-on protection of an entire application portfolio, without disruptive scanning or expensive security experts. Only Contrast has sensors that work actively inside applications to uncover vulnerabilities, prevent data breaches, and secure the entire enterprise from development, to operations, to production.
About the Position
As a member of the Cloud Engineering team, you are part of a team responsible for ensuring availability, reliability, responsiveness and scalability across all Contrast production services. You are deeply hands-on with our cloud-based infrastructure, database systems, automation, monitoring and systems telemetry. 
You work with our engineering team to design and build system infrastructure that is automated, elastic, and reliable. You support our databases in such a way that our colleagues in application engineering see you as a reliable subject matter expert for performance, modeling and data integrity. In a teammate, we expect you to challenge conventional wisdom and encourage everyone to have simpler solutions. It is your nature to share what you know so that everyone you encounter is just a bit better at using MySQL.
Ideal candidates have expertise in maintaining and improving the use of MySQL. You’ll work with these systems through infrastructure as code using Terraform, Cloudformation and Helm Charts. All of our work is currently done in the AWS ecosystem. Cloudformation will leave our stack this year.
Please include a link to your Github or BitBucket account, as well as any links to some of your projects if available. We enjoy looking at your code.

Responsibilities:

  • Operate, tune and improve multiple RDS instances (MySQL & Aurora).
  • Collaborate with Application Engineering teams to profile instance resource usage, optimize and tweak both query and schema.
  • Collaborate with the Architecture team on the use of alternative strategies for handling and storing data (S3/EMR/Athena etc.).
  • Plan, coordinate and schedule upgrades, migrations and schema redesign efforts along with business stakeholders.
  • Own and maintain appropriate documentation (code & Confluence) around specification, runbooks, etc.
  • Participate as an equal partner in the Infrastructure team's on call rotation.
  • Your are joining a team. We have others with SME level MySQL experience. So, working on a team and to the benefit of that team and its stakeholders is your overarching mission.

MySQL:

  • You assist application engineers in writing and tuning SQL queries on MySQL 5.7 and later.
  • You have demonstrable experience tuning the MySQL server through an RDS parameter group. 
  • You have experience and opinions about the use of MySQL features such as stored procedures, triggers and the event scheduler.
  • You have demonstrable experience making multiple schema changes on large tables in a busy environment.
  • You understand some of the limitations of MySQL and have experience with common workarounds when such limitations are reached.
  • You have set up, tuned and monitored MySQL replication.

Cloud Engineering:

  • You have managed infrastructure with code (Terraform, Cloudformation, Ansible, Chef, etc.).
  • You have written a job or two to automate away toil and have a fun story to tell us.
  • You submit pull requests for small changes frequently.
  • You enjoy reviewing others’ PR’s as a means of improving your understanding of the operational environment.
  • You plan your work to avoid service interruptions whenever possible.

About You:

  • You have been working in a cloud engineering capacity for 5+ years.
  • 1+ years of your experience has been database focused, but not necessarily exclusive.
  • You have demonstrable experience planning, executing and delivering a project on your own and with one or more other team members.
  • You possess experience managing multiple production database instances via code. (Cloudformation, Terraform, etc.).
  • You have a strong desire to grow your infrastructure as code skills.
  • You can share stories about the mistakes you've made throughout your career and what you have done to recover from them (and not repeat them).
  • Ideally, you have worked in a fast growing start up.
  • Ideally, you have an AWS Database, AWS Solutions Architect, AWS SysOps or AWS Developer certification. Maybe even a MySQL database or developer certification.
  • If not, you are keen to take advantage of our support in earning some of these.
  • Ideally, you have a strong familiarity with common Java DB libraries such as connection pools (e.g. Hikari, C3P0) and ORMs (e.g. Hibernate), or you will happily exchange your expertise with developers for a better understanding of these libraries and frameworks. (Note, you will not be asked to write Java code, but may find yourself reading it along with application engineers in order to tune a process.)

  • We are focused on building a diverse and inclusive workforce. If you’re excited about this role, but do not meet 100% of the qualifications listed above, we encourage you to apply.

What we offer:

  • Competitive compensation package (salary + equity)
  • A fun and dynamic environment where you work with other like minded people on products which make a real difference to the security of our customers
  • Healthcare packages
#LI-ST1
We are changing the world of software security. Do it with us.  We believe in what we do and are passionate about helping our customers secure their business.If you’re looking for a challenge and want to enjoy where you work, you’ll love Contrast Security.
Contrast Security is committed to a diverse and inclusive workplace. Contrast Security is an equal opportunity employer and our team is comprised of individuals from many diverse backgrounds, lifestyles, and locations.
By submitting your application, you are providing Personal Information about yourself (cover letter, resume, email address, etc.) and hereby give your consent for Contrast Security, Inc. and/or our HR-related Service Providers, to use this information for the purpose of processing, evaluating and responding to your application for current and future career opportunities. If you are a resident of the European Economic Area or are applying for a position in the European Economic Area, Contrast’s Privacy Statement reflects our policies around compliance with the General Data Protection Regulation (“GDPR”) and your rights respective to GDPR as a California resident, you are entitled to certain rights under CCPA: The California Consumer Privacy Act of 2018 (“CCPA”) will go into effect on January 1, 2020. Under CCPA, businesses must be overtly transparent about the personal information they collect, use, and store on California residents. CCPA also gives employees, applicants, independent contractors, emergency contacts and dependents (“CA Employee”) new rights to privacy.
We do not accept resumes from agencies, headhunters, or other suppliers who have not signed a formal agreement with us.
* We could support remote work in most states except CO.
Job tags: Ansible AWS Chef CloudFormation Go Java MySQL S3 SQL Terraform Vulnerabilities
Job region(s): Europe
Job stats:  0  0  0
  • Share this job via
  • or