Database Administrator

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

Technology we use

  • Product
  • Sales & Marketing
    • Google AnalyticsAnalytics
    • TableauAnalytics
    • Google OptimizeAnalytics
    • Adobe Creative Cloud - Full SuiteDesign
    • Monday.comManagement
    • SlackManagement
    • WordpressCMS
    • MagentoCMS
    • NetsuiteCMS
    • BrontoEmail
    • UnbounceLead Gen

Location

DCG has 2 office locations: our main office is in Northbrook (722 Landwehr Rd), and our remote office is at TechNexus, located in downtown Chicago.

An Insider's view of Direct Commerce Group

What are some social events your company does?

Cosmic bowling, ping pong tourneys, Halloween costume contests, and happy hours are just some of the fun group events we've had.

Molly

Marketing Operations Manager

How has your career grown since starting at the company?

I started at DCG seven years ago as a Graphic Designer and have advanced into the Creative Director role. In my time here, I have been empowered to make some really impactful changes, including creating the individual identities for all of our brands as well as creating profitable marketing materials.

Amanda

Creative Director

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 are Direct Commerce Group Perks + Benefits

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Flexible Work Schedule
Remote Work Program
Perks & Discounts
Beer on Tap
Casual Dress
Company Outings
Stocked Kitchen
Some Meals Provided
Professional Development Benefits
Job Training & Conferences
More Jobs at Direct Commerce Group4 open jobs
All Jobs
Data + Analytics
Design + UX
Operations
Design + UX
new
North Suburbs
Data + Analytics
new
Chicago
Operations
new
North Suburbs
Data + Analytics
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 job
loading ...
Emailed
View Direct Commerce Group's full profileSee more Direct Commerce Group jobs