Oh Snap!
This job is no longer active - but you can still view the details below.

Senior Database Administrator

| Greater NYC Area

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

Location

Our office is a converted loft space in Chelsea steps away from shopping, galleries, coffee, and great food (that is, if you want to skip free lunch).

An Insider's view of Lifion by ADP

What are some social events your company does?

There are lots of events constantly going on at Lifion! From meetups to tech talks to our weekly Thursday happy hours, there's a good mix of work and play. We also do outings: in my one year of working here we’ve done laser tag, Barcade, happy hour on a boat, the vessel, a picnic in central park, escape the room, VR world, and more.

Kelsey

Application Developer

What's the biggest problem your team is solving?

The People Ops Team is in full swing for FY19 Performance Reviews. It's an exciting time for the business, but requires a lot of backend work & support for our associates. We're drafting communications and timelines for management & associates, and creating the right process to gather ratings and self-assessments for a great associate experience.

Quinton

Director, People Operations

How has your career grown since starting at the company?

I have been able to work with many different teams since I started here and have grown tremendously. I have worked with new product teams, Reliability teams and now work with Security and Compliance teams. This experience has enriched my technical and product knowledge, and I get to be part of the teams which are solving complex business problems.

Gargi

Technical Program Manager

How do you empower your team to be more creative?

Creativity is best fueled by collaboration, and has two simple ingredients: First, you hire passionate & talented people, people who care about users and who want to solve meaningful complex problems. Then, you support a culture of openness, with every designer constantly sharing their best ideas across the whole org. That's how creativity thrives!

Chris

Head of UX

What makes someone successful on your team?

Success on our team is enjoying ownership over our work while staying open to suggestions. We have an open-door policy to share knowledge with one another, strengthening us individually and as a team. We check our egos at the door and are lucky enough to be surrounded by people who feel like family more than coworkers.

Sam

Software Engineer

What are Lifion by ADP Perks + Benefits

Culture
Friends outside of work
Eat lunch together
Daily stand up
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Unconscious bias training
Someone's primary function is managing the company’s diversity and inclusion initiatives
Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Onsite Gym
Retirement & Stock Options Benefits
401(K) Matching
Employee Stock Purchase Plan
Performance Bonus
Match charitable contributions
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Free Daily Meals
Stocked Kitchen
Happy Hours
Fitness Subsidies
Professional Development Benefits
Tuition Reimbursement
Lunch and learns
Promote from within
Continuing Education stipend
More Jobs at Lifion by ADP11 open jobs
All Jobs
Dev + Engineer
Operations
Product
Project Mgmt
Sales
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Project Mgmt
new
New York
Sales
new
New York
Operations
new
New York