Senior Database Administrator

| Greater LA Area

FabFitFun is seeking an innovative and self-driven Senior Database Administrator (DBA) to join our growing Data Infrastructure team for building a scalable and modern data warehouse and business-driven data products. This will include operational duties such as restoring/refreshing environments, deploying releases, and also architectural duties such as schema and code review, and troubleshooting slow queries. There will also be opportunities for growth in writing ETL/ELT for data lake in S3, as well as being a part of the Enterprise Architecture initiative with data governance and privacy. Our Senior DBAs partner with existing Data Engineering/Data Science teams to develop critical data pipelines for making real-time decisions and business recommendations. The ideal candidate would a proven track record supporting and fulfilling the strategic objectives of a highly cross-functional organization.

What You'll Do:

  • Performance monitoring and tuning of database queries in production.
  • Review and tune parameter groups for MySQL and Postgres.
  • Manage Work Load Management (WLM) in Redshift.
  • Build dashboards for database health and alerting.
  • Review existing infrastructure and optimize legacy system.
  • Develop data models for all production schemas.
  • Maintenance and Administration for Aurora MySQL RDS, Redshift, S3.
  • Perform Terraform deployments of database instances/users/groups/Permissions.

 What You'll Bring:

  • Bachelor’s Degree in Computer Science or related field
  • Experience with Liquibase or Schema or similar Schema version control software
  • Extensive experience with design & development of relational databases and data warehouses
  • Advanced level of proficiency in mySQL development and architecture, including designing new schemas
  • Strong knowledge & expertise with ETL/ELT tools like AWS Glue, Talend, or Airflow
  • Experience with AWS S3 and RDS, Terraform is a big plus!
  • Production experience in a high-traffic environment with Postgres and MySQL
  • Intermediate knowledge of python and experience data modeling
  • Excellent communication skills (verbal and written) and interpersonal skills and an ability to effectively communicate with both business and technical teams
  • Experience on subscription service products is a huge plus!
  • Data Lake experience is a huge plus!

What You'll Get:

  • Daily impact on one of the fastest growing companies in the US that are revolutionizing e-commerce
  • Assist in helping FabFitFun achieve personalization through data science and analytics
  • Full health-care coverage as well as dental and vision coverage and 401k
  • Flexible PTO and generous holiday schedule
  • Free FabFitFun subscription
  • Paid parking
  • Catered meals 3x/week
Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • ReactLibraries
    • ReduxLibraries
    • MySQLDatabases
    • PostgreSQLDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • AsanaManagement
    • WrikeManagement
    • SalesforceCRM
    • IterableEmail

Location

In the heart of West Hollywood! Close to many staples of the LA area including The Beverly Center, The Grove and popular restaurants and bars.

What are FabFitFun, Inc. Perks + Benefits

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K)
Company Equity
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Stocked Kitchen
Stocked kitchen with amazing snacks that suit both looking for something healthy or a sweet treat in the afternoon. Kombucha & cold brew also on tap!
Some Meals Provided
FabFitFun offers 3 catered a meals a week at our HQ in West Hollywood. Breakfast provided on Monday, while Lunch is provided on Tuesday and Friday.
Parking
Paid parking available for all of our employees with a paid parking incentive for those who commute to the office and don't require a parking spot or vouchers.
Pet Friendly
Dog friendly office!
Fitness Subsidies
You will have access to our online digital streaming platform (FabFitFun TV) that hosts a library of online fitness classes from top studies. Also hosted fitness classes every quarter in nearby gyms.

Additional Perks + Benefits

Generous compensation package and extensive benefits. 12 weeks’ paid parental leave. Free FabFitFun subscription and tons of beauty freebies! Daily impact on personalizing the FabFitFun member experience.

More Jobs at FabFitFun, Inc.44 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Marketing
Operations
Product
Sales
Content
Data + Analytics
new
Los Angeles
Data + Analytics
new
Los Angeles
Finance
new
Los Angeles
Marketing
new
Los Angeles
Design + UX
new
Los Angeles
Design + UX
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Operations
new
Los Angeles
Operations
new
Los Angeles
Operations
new
Los Angeles
Data + Analytics
new
Los Angeles
Sales
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Marketing
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Operations
new
Los Angeles
Marketing
new
Los Angeles
HR
new
Los Angeles
Data + Analytics
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Finance
new
Los Angeles
Finance
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
Content
new
Los Angeles
HR
new
Los Angeles
Finance
new
Los Angeles
Data + Analytics
new
Los Angeles
Data + Analytics
new
Los Angeles
Data + Analytics
new
Los Angeles
Finance
new
Los Angeles
HR
new
Los Angeles