Database Administrator at Moda Operandi

| Greater NYC Area
!Sorry, this job was removed at 11:01 a.m. (CST) on Wednesday, January 15, 2020

We are looking for a DBA who will be responsible for managing, and owning Moda Operandi's OLTP data stores. In this role you will be performing traditional DBA tasks including user performance tuning, monitoring, replication, setting backup retention policies, growth projections, user management, etc. You should also be comfortable working with application developers to promote and implement data modeling best practices. This position will also work closely with the Data Engineers to streamline ETL/ELT pipelines from OLTP stores to the Data Warehouse.

Necessary qualifications for success:
• Expertise in MySQL performance tuning, provisioning, upgrading, and
resource monitoring in an Aurora environment
• Expertise in SQL, query optimization, and partitioning
• Developing stored procedures, triggers, and index tuning
• Knowledge of limitations in MySQL and solutions
• Experience with database deployment tools eg. flyway, liquibase
• Experience with other Aurora database offerings (Postgres, MariaDB)
• Experience with scripting languages such as Python, shell scripting

Extra Credit (not required):
• Experience with data modeling in an ecommerce domain
• Experience with NoSQL datastores eg. dynamodb, mongodb, etc.
• Experience with vcs eg. git, mercurial, subversion etc.
• Experience with Snowflake


Read Full Job Description
Apply now

Technology we use

  • Engineering
    • ScalaLanguages
    • ReactLibraries
    • AngularJSFrameworks

Location

New York, NY 10013

What are Moda Operandi Perks + Benefits

Moda Operandi Benefits Overview

Enjoy A Flexible Lifestyle

Where the high-energy of a start-up meets the stability of a well-funded company. Moda is committed to fostering flexibility and wellbeing inside and outside of the office. Our employees enjoy a full suite of benefits.

Unlimited PTO & sick leave
Full medical, dental, vision insurance
Generous parental leave
Industry leading merchandise discount
401K
Performance bonus
Equity Incentive plan
Opportunities to work flexibly
Subsidized day care, gym discount & pet insurance
Free snacks and weekly company happy hours
Dog-friendly office
& more!

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Diversity manifesto
Someone's primary function is managing the company's diversity and inclusion initiatives
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Adoption Assistance
Company sponsored family events
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Pet Friendly
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Promote from within
Time allotted for learning
More Jobs at Moda Operandi12 open jobs
All Jobs
Design + UX
Operations
Product
Sales
Content
Product
new
New York
Design + UX
new
New York
Design + UX
new
New York
Product
new
New York
Design + UX
new
New York
Product
new
New York
Product
new
New York
Design + UX
new
New York
Product
new
New York
Content
new
New York
Operations
new
New York