Lead Database Engineer at Lifion by ADP

| Greater NYC Area
Sorry, this job was removed at 1:44 p.m. (EST) on Thursday, October 22, 2020
Find out who's hiring in NYC.
See all Developer + Engineer jobs in NYC

Job description

The Engineering Reliability team at Lifion is central to the reputation and trustworthiness of our product. We are looking for a senior architect/ engineer with strong experience in database technologies to work within the Database Reliability team. The team applies the practices of Site Reliability Engineering to the data owned by platform and product engineering teams, and delivers value through standardization of database operations, best practices, automation and subject-matter expertise.

RESPONSIBILITIES

  • Support many application teams and their databases in AWS on MySQL, PostgreSQL
  • Work with developers on architecting data models.
  • Perform database administration tasks, including automation, performance monitoring and tuning, and query optimizations
  • Work to identify, design, plan, and implement architectural and operational improvements on various SQL DBMS and NoSQL technologies
  • Work with infrastructure engineers, developers, and architects to build and maintain scalable, reliable, and robust databases solutions
  • Work with security and operations to manage access control to databases
  • Monitor databases for problems and diagnose their origin
  • Identify and resolve production application issues
  • Participate in rotating on-call duties
  • Plan and provide operational oversight in large database migrations with minimal impact to customers
  • Troubleshoot and resolve problems across various tiers with applications and database systems
  • Plan and provide details how to scale databases/clients horizontally when data grows without much ( or no) impact on the performance
  • Help application team to test application with 10X, 100X or 1000X data set on lower environments before hitting the new code on upper environment

QUALIFICATIONS

  • 5+ years experience administering MySQL or PostgreSQL databases in production
  • Experienced in AWS Aurora and RDS MySQL
  • Strong troubleshooting and performance-tuning skills required
  • Must be able to improve SQL performance results through the use of query execution plans and other optimization tools
  • You have a strong sense of ownership, and an ability to drive tasks to completion
  • You have strong communication skills
  • Experience working in programming languages ( NodeJS, Python, bash)
  • Experience working with containers

 

 

We’re designing a better way to work, so you can achieve what you’re working for. Consistently named one of the ‘Most Admired Companies’ by FORTUNE® Magazine, and recognized by DiversityInc® as one of the ‘Top 50 Companies for Diversity,’ ADP works with more than 740,000 organizations across the globe to help their people work smarter, embrace new challenges, and unleash their talent. “Always Designing for People” means we’re creating platforms that will transform how great work gets done, so together we can unlock a world of opportunity.

 

At ADP, we believe that diversity fuels innovation. ADP is committed to equal employment opportunities regardless of race, color, genetic information, creed, religion, sex, sexual orientation, gender identity, lawful alien status, national origin, age, marital status, or protected veteran status. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.

Read Full Job Description

Technology we use

  • Engineering
  • Product
    • GolangLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • ReactLibraries
    • ReduxLibraries
    • Node.jsFrameworks
    • TensorFlowFrameworks
    • MySQLDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • JIRAManagement

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
Design + UX
Dev + Engineer
Project Mgmt