1+ months

Senior Database Administrator - 1169589

New York, NY 10007
  • Job Code
    1169589

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 PoCs 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:

  • Bachelors 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

Categories

Posted: 2019-07-18 Expires: 2019-09-06

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior Database Administrator - 1169589

ADP
New York, NY 10007

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast