Associate Database Administrator

| Chicago
ActiveCampaign is one of the fastest growing tech companies in Chicago revolutionizing marketing automation. Our software allows all of our users, the power to make smarter business decisions based on data-driven analytics.
We are currently seeking a creative Associate Database Administrator to join our Infrastructure team. Our team is passionate about automating our infrastructure and ensuring that we stay current with the latest technology practices. The Associate Database Administrator will deal with terabytes of data for all of our development and data science teams.
If this sounds like you and your next career move, then we would love to hear from you!

What your day could consist of:

  • Maintaining infrastructure (data stores, ETL tools)
  • Optimizing queries for our SQL and NoSQL data stores
  • Performance tuning and advising developers on best practices for data loads between data lake, internal data structures, internal and external API’s
  • Brainstorming with data science and development teams and suggesting data and architectural solutions
  • Creating and anonymizing data for staging/testing purposes for all development teams
  • Collaborating with data engineers to build ETL pipelines

What is needed:

  • Experience with MySQL or other relational data stores
  • Experience with NoSQL or stores (preferably Elasticsearch)
  • Administer databases (SQL, NoSQL, etc.) for scale, stability, security, multi-user load management and performance
  • SQL and Bash skills
  • Experience with common file and concept data structures (JSON, CSV, lists, dictionaries, data frames, etc.)
  • Experience with data sanitization processes and creation of said processes for testing purposes
  • Version control/Git
  • Experience with any data visualization tools/frameworks is preferred. Looker Experience (LookerML) (desired)
  • Python skills

We continually invest in our employees and offer comprehensive benefits including 100% coverage of your medical premiums and 50% for dependents, open vacation policy, fully paid maternity and paternity leave, 401k matching, catered lunches every day in a kitchen stocked with snacks and fresh fruit, free CTA or Metra passes, and a DIVVY bike membership (to name a few).
At ActiveCampaign, we are committed to maintaining a culture that is inclusive and diverse. Our colleagues foster an environment that is warm, supportive, and helpful where we treat each other exceptionally well. We are looking to add curious, driven, and creative individuals to our team who are ready to grow with us!

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • jQueryLibraries
    • DjangoFrameworks
    • Ember.jsFrameworks
    • FlaskFrameworks
    • LaravelFrameworks
    • MySQLDatabases
    • TrelloManagement
    • ActiveCampaignCRM

Location

Beautiful Chicago Loop Office overlooking State Street with views of the lake and Millennium Park and is minutes from the Metra & CTA.

What are ActiveCampaign Perks + Benefits

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
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Health Insurance & Wellness Benefits
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Generous Parental Leave
Remote Work Program
Family Medical Leave
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Recreational Clubs
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Continuing Education stipend
Online course subscriptions available
Paid industry certifications

Additional Perks + Benefits

Daily Catered Lunches. Open Vacation Policy. Dual monitor & stand-up desk workstation. FOND Membership. Peer Recognition Program (bonuses). Work/Life Balance. Competitive Salaries.

More Jobs at ActiveCampaign39 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Sales
new
Chicago
Developer
new
Chicago
Internships
new
Chicago
Operations
new
Chicago
Design + UX
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Sales
new
Chicago