Database Administrator at Tall Ridge

| Chicago
!Sorry, this job was removed at 5:18 p.m. (CST) on Thursday, May 30, 2019
Please send resume and a short summary of why this role interests you to [email protected] and make sure to mention Built In Chicago in the subject line of the message.
Apply now

Company Background

Direct Commerce Group, LLC (DCG) is a growing and entrepreneurial business with multiple areas of focus. Privately held and well capitalized by private investors and internet industry veterans, DCG currently operates Tall Ridge and Office Designs.

Tall Ridge (www.tallridge.com) is a full-service digital marketing agency focused on helping brands like Hydro Flask, Boll & Branch and Gerber Gear succeed on Amazon and other online marketplaces. We offer products for the quality conscious consumer.

Office Designs (www.officedesigns.com) is an e-commerce business focused on offering high-end ergonomic seating, modern office furniture, and office décor products to small and mid-size businesses and home offices. Full-service offerings include design and layout services, curated product offering and installation. Because of our capabilities, we are selectively authorized to offer high-quality brands such as Herman Miller, Steelcase, Humanscale, and Haworth, in addition to various other brands.

 

Position Summary

Using your deep expertise in databases and application development, you will work with the team to develop and maintain DCG’s data platform. You will help develop, enhance and maintain applications using AWS cloud technologies, along with using relational, MySQL and other specialized databases. You will help write data services in Java and demonstrate concurrent programming skills as needed. We will depend on your futuristic thinking to mitigate issues before they occur and will look to you to test, debug and troubleshoot challenges and to document resolution steps when necessary.

 

Key Responsibilities

  • Formulates detailed network, storage, and computes design specifications for stable and secure computing operations in a dynamic cloud based environment to support Tableau reporting infrastructure.

  • Monitors MySQL databases to assist in optimization of database performance, resource use, and physical implementation.

  • Creates custom Java and/or Python based scripts to automate data retrieval and integration into database.

  • Collaborates with internal and external parties to transform high-level technical objectives into comprehensive technical requirements.

  • Makes recommendations for improvements to security, scalability, manageability, and performance across a wide variety of network, storage, and compute technologies.

  • Participates in, implements, and coordinates with others, in maintaining, modifying, and creating database structures.

  • Develops strategies for data acquisitions, archive recovery, and implementation of MySQL databases.

  • Assists and begins to develop designs for databases.

  • Monitors and manages MySQL database backups and restorations.

  • Installs, maintains, and upgrades MySQL database software as required.

  • Administers, maintains, and develops policies and procedures for ensuring the security and integrity of databases.

  • Continues our charge towards test automation and continuous integration

  • Drives innovation by coming up with new and surprising ideas for our applications and our processes

  • Designs, implements, and maintains our application and infrastructure components

  • Refactors and improves maintainability of the codebase

  • Solves complex scalability, platform, and integration problems

  • Learns new paradigms, languages, and libraries as you work

  • Assists with identifying and planning potential new cloud services, features, and capabilities.

  • Demonstrates problem solving skills and the ability to work on multiple projects simultaneously.

  • Meets predetermined deadlines set for assigned tasks.

  • Studies the technical structure and requirements of the DBM system to be supported.

  • Demonstrates the ability to utilize training in assigned tasks.

  • Performs project tasks to ensure that associated deliverables are completed in a timely manner.

  • Creates documentation in accordance with the tasks performed.

  • Ensures written communication is accurate, timely and thorough.

  • Adheres to accepted department standards and procedures.

  • Database Administration and Monitoring

  • Owns and solves performance issues of database applications by implementing changes to database objects and/or working with developers/vendors on application tuning effort

 

Requirements:

  • Bachelor’s degree in computer science, MIS or a related field or the equivalent in education and experience is required

  • Experience in data modeling, along with 2-3 years of programming experience writing performant stored procedures/functions/SQL statements is required

  • Experience installing/administering clustered MySQL v5.x+ instances

  • Solid understanding of different Database Models

  • Experience in either Oracle or MySQL is required

  • Minimum 2 years of working experience in core java is required.

  • Understanding of how HTTP works as it applies to RESTful architectures required

  • Data warehousing experience is preferred

 

Compensation and Benefits

  • Competitive salary
  • Flexible work location
  • Stocked kitchen
  • Health, dental and vision insurance
  • Smart and fun co-workers who will quickly feel like family
  • 3 weeks PTO
  • 401k plan with company match 
  • Short Term Disability
Read Full Job Description
Please send resume and a short summary of why this role interests you to [email protected] and make sure to mention Built In Chicago in the subject line of the message.
Apply now

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • SqlLanguages
    • jQueryLibraries
    • FlaskFrameworks
    • MySQLDatabases
    • Google Big Query Databases
    • Google AnalyticsAnalytics
    • TableauAnalytics
    • Google OptimizeAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • Adobe Creative Cloud - Full SuiteDesign
    • JIRAManagement
    • Monday.comManagement
    • SlackManagement
    • WordpressCMS
    • MagentoCMS
    • NetsuiteCMS
    • BrontoEmail
    • UnbounceLead Gen

Location

Tall Ridge has 2 office locations: our main office is in Northbrook, and our satellite office is at TechNexus, located in downtown Chicago

An Insider's view of Tall Ridge

What are some social events your company does?

Happy hours, bag tourneys, Halloween costume contests, and Friday lunches are just some of the fun group events we've had.

Angelica

Office Manager

What projects are you most excited about?

Each day I am excited to build data systems and connections that run while my team sleeps. Then the company is free to plan and work creatively, driving real growth on a steady foundation.

Aaron

Database Administrator

How has your career grown since starting at the company?

I moved up from customer service to copywriting and learned many important skills since starting my new position. Customer service here taught me how to navigate processes and think on my feet. My current position is teaching me to think more creatively and to look at problems from a different perspective.

Cassandra

Copywriter

How do you make yourself accessible to the rest of the team?

I look forward to greeting each team member almost every day. Through team meetings, hallway conversations, one on ones and doorway discussions, I generate energy from my interactions with the team. The close knit connection provides a meaningful and engaging atmosphere. People really care about each other at DCG

John MacEntee

President

What does your typical day look like?

Project management responsibilities are 10%-15% of my day. Working with SQL/BigQuery and database's infrastructure is around 20%-25% of my day, working with Python for non-modeling tasks is around 20% and working with ML and statistical models around 25% of my time. The rest is dedicated to learning something new!

Mario

Lead Data Scientist

What are Tall Ridge Perks + Benefits

Tall Ridge Benefits Overview

Many of us consider our people to be our best perk but to sweeten the deal, we also have a pretty awesome list of conventional (and less conventional) perks and benefits including competitive salaries, health benefits, a 401K matching plan with immediate vesting, generous and flexible paid time off, tuition reimbursement, and great employee discounts on our products. Not to mention, we regularly partake in happy hours, company-sponsored events, oh yeah, and snacks & drinks too of course!

Culture
Volunteer in local community
Tall Ridge participates in local volunteer activities such as Feed my Starving Children.
Friends outside of work
Eat lunch together
Open door policy
Team based strategic planning
Diversity
Dedicated Diversity/Inclusion Staff
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Tall Ridge employees can contribute up to $2700 annually to their FSA.
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Flexible Work Schedule
Remote Work Program
Vacation & Time Off Benefits
Generous PTO
Tall Ridge employees receive between 15 and 25 days per year of paid time off based on years of service.
Paid Holidays
Perks & Discounts
Beer on Tap
Casual Dress
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Happy hours are hosted At team's discretion.
Pet Friendly
Tall Ridge is dog-friendly! They are so important they have their own calendar.
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Promote from within
Paid industry certifications
More Jobs at Tall Ridge1 open job
All Jobs
Operations
Operations
new
North Suburbs
Please send resume and a short summary of why this role interests you to [email protected] and make sure to mention Built In Chicago in the subject line of the message.
Apply now
Save jobView Tall Ridge's full profileSee more Tall Ridge jobs