Douglas Jarquin douglasjarquin

Checklist - Ideal Ops

In a perfect world, where things are done well, not just quickly, I would expect to find the following when joining the company:

Documentation

Accurate / up-to-date systems architecture diagram
Accurate / up-to-date network diagram
Out-of-hours support plan
Incident management plan

Operations Engineer

About Zumba

Zumba® Fitness is a global lifestyle brand that fuses fitness, entertainment and culture into an exhilarating dance-party workout. Founded in 2001, the company is now the largest branded fitness program in the world — reporting more than 12 million weekly class participants, in over 110,000 locations, across more than 125 countries. The Zumba® fitness lifestyle is rounded out by the company’s many consumer product offerings, including DVD sets, music collections, multi-seasonal apparel and footwear, video games, Fitness-ConcertTM events and a lifestyle magazine. All of our rapid growth means that we have many interesting and challenging problems to solve, most critically in operations. Zumba Instructor's bet their businesses on the availability of our platform. This is why we’re looking to add two experienced Operations Engineer's to our technical operations team.

Skills

3+ years of Linux administration

	#!/usr/bin/env ruby

	# Usage: ops rds-rotate-slowlog <absolute_path_to_log>
	# Summary: Use this command to rotate the slow log of on RDS instance.
	# Help: Queries the slowlog database table maintained by Amazon RDS and outputs it in
	# the normal MySQL slow log text format. The log file path defaults to
	# /var/log/mysql/slow_query.log, and can be overriden with a command line argument.
	#
	# Examples:
	#

	require 'rubygems'
	require 'mysql'

	@database = {
	'host' => '',
	'user' => '',
	'password' => '',
	'name' => ''
	}

	require 'rubygems'
	require 'mysql'

	@database = {
	'host' => '',
	'user' => '',
	'password' => '',
	'name' => ''
	}

	require 'rubygems'
	require 'mysql'
	require 'redis'

	# start your engines
	mysql = Mysql.new('host', 'username', 'password', 'database')
	redis = Redis.new('host' => '', 'port' => , 'password' => '')

	sessions = mysql.query("select * from cake_sessions where expires > '#{Time.now.to_i - 10800}' LIMIT 10")

	#!/bin/sh -e

	rds_db_instance_identifier() {
	echo "$@" \| sed -e 's/[^-0-9A-Za-z]/-/g'
	}

	rds_describe_db_instance() {
	if test $# -lt 1; then
	return 1
	fi

	bash -c '

	#
	# make sure sudo users have the full path...
	#
	# sudo visudo
	# Defaults env_keep += "PATH"
	# Defaults !secure_path

	#

	rds-modify-db-parameter-group {param-group-name} \
	--parameters="name=character_set_server, value=utf8, method=pending-reboot" \
	--parameters="name=collation_server, value=utf8_general_ci, method=pending-reboot" \
	--parameters="name=tmp_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
	--parameters="name=max_heap_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
	--parameters="name=query_cache_type, value=1, method=pending-reboot" \
	--parameters="name=query_cache_size, value=131072, method=pending-reboot" \
	--parameters="name=table_open_cache, value=2500, method=pending-reboot" \
	--parameters="name=join_buffer_size, value={DBInstanceClassMemory/64}, method=pending-reboot" \
	--parameters="name=thread_cache_size, value={DBInstanceClassMemory/12582880}, method=pending-reboot" \