Database Administrator

| Chicago

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
loading ...
Emailed

Location

Chicago, IL 60601

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
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
Highly diverse management team
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
Remote Work Program
Our remote work program includes work from home Full-time remote for specific positions, Work remotely $2 days per week, Work remotely on occasion as needed.
Family Medical Leave
Adoption Assistance
Return-to-work program post parental leave
Company sponsored family events
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Our employees receive 2 hours per year of 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
Cross functional training encouraged
Promote from within
Online course subscriptions available
More Jobs at Moda Operandi27 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Product
Sales
Developer
new
Chicago
Data + Analytics
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Product
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago