Senior Database Administrator

| Greater NYC Area | Hybrid
Sorry, this job was removed at 5:33 p.m. (EST) on Tuesday, August 20, 2019
Find out who's hiring in Greater NYC Area.
See all Data + Analytics jobs in Greater NYC Area
Apply
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
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Location

We have multiple NYC locations, each in easy commuting distance to the subways and metro transportation. Each location is just steps away from shopping, galleries, coffee, and great food!

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about ADPFind similar jobs