Senior Database Administrator
Sorry, this job was removed at 5:33 p.m. (EST) on Tuesday, August 20, 2019
By clicking Apply Now you agree to share your profile information with the hiring company.
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
- Analyze 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
- 5+ years of MySQL DBA experience in managing critical 24/7 applications
- Minimum of 2 years experience architecting solutions with AWS managed database services (RDS, Aurora, etc.)
- Relevant AWS certifications desired
- Strong 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
Read Full Job Description