Senior MySQL Database Administrator

Job Description

The Opportunity:

This role will focus on the design, architecture, and operational aspects of MySQL Database Administration, in a hybrid cloud environment (production and non-production). The DBA team is responsible for all areas of database engineering & operations, current and future database environments, and improving performance and stability while decreasing our MTTR.

We are in need of a proactive, driven, forward looking Senior DBA, with extensive AWS Cloud experience.

Responsibilities:

• Develop and execute a migration strategy with PoC’s and Pilots to AWS managed database solutions such as Amazon Aurora
• Define and establish standards and best practices to implement and support MySQL database clusters, and high-performance computing environments, particularly on the AWS Cloud
• Implement an effective cost management strategy for AWS databases
• Champion all database environment builds, including design, capacity planning, cluster setup, upgrades, performance tuning and ongoing monitoring
• Design and support data migrations
• Diagnose, troubleshoot, and resolve data and performance issues, to ensure that database systems meet business and performance requirements, which may include after-hours/weekends
• Develop and deploy alerting, monitoring, and reporting tools and dashboards integrated with other cloud based monitoring tools, to help support business requirements
• Define and implement database backup and recovery strategies
• Work with developers and engineers on all database related changes via code reviews, tuning, testing, and validation
• Performance tuning of databases to support high read/write throughput while minimizing latency
• Assist with data analysis by writing ad hoc queries
• Analyse database access patterns to isolate hotspots, data model problems, and other bottlenecks
• Perform proactive capacity planning and forecasting based on database usage patterns and new business initiatives

Requirements:

• Bachelor’s degree in a related field (Computer Science preferred) or equivalent work experience
• Experience implementing and supporting mission critical/high uptime systems is required
• 10+ years of MySQL DBA experience in managing critical 24/7 applications
• Minimum of 4 years experience architecting solutions with AWS managed database services (RDS, Aurora, etc.)
• Relevant AWS certifications desired
• Stron g understanding of the MySQL data model and architecture including installation, configuration of a cluster, replication, security, and best practices
• Familiarity with other SQL/NoSQL databases such as, MariaDB, MongoDB, Cassandra, etc.
• Expert understanding of complex inner workings of MySQL
• Knowledge of operating relationships between database, business applications, and the operating systems
• Familiarity within Linux Environments, able to write/maintain scripts
• Familiarity with Infrastructure as Code software, such as Terraform, and CI/CD process
• Prior experience working with Agile/Scrum methodologies
• Ability to manage day-to-day tasks independently
• Ability to perform multiple tasks concurrently
• Excellent analytical and problem-solving skills
• Strong knowledge of system security and overall IT security methodologies
• Experience and knowledge of change management principles, methodologies and tools
• Exceptional communication skills, both written and verbal

About Shutterstock, Inc.

Shutterstock, Inc. (NYSE: SSTK ), directly and through its group subsidiaries, is a leading global provider of high-quality licensed photographs , vectors , illustrations , videos and music to businesses, marketing agencies and media organizations around the world. Working with its growing community of over 750,000 contributors, Shutterstock adds hundreds of thousands of images each week, and currently has more than 260 million images and more than 14 million video clips available.

Headquartered in New York City, Shutterstock has offices around the world and customers in more than 150 countries. The company also owns Bigstock , a value-oriented stock media offering; Shutterstock Custom, a custom content creation platform , Offset, a high-end image collection ; PremiumBeat a curated royalty-free music library; and Shutterstock Editorial, a premier source of editorial images for the world's media.

For more information, please visit www.shutterstock.com and follow Shutterstock on Twitter and on Facebook .