Database Administrator

| Chicago

Responsibilities

  • Plan and design data structure; set and monitor standards.
  • Assist management in database concepts and functional capabilities.
  • Design, create, modify and review database objects (tables, views, indexes, keys,       stored procedures, functions, DB links, etc.) to support development projects.
  • Monitor current Database performance; develop procedures and improve the Database environment for future requirements .
  • Assemble large, complex data sets that meet functional/non-functional business requirements.
  • Build ad-hoc reports with complicated queries .
  • Automate reports and authoring pipelines via SQL/python based ETL framework
  • Implement and test database backup and restore
  • Controls and monitors user access to the database
  • Assist developers with query tuning and schema refinement; modify the database structure as necessary
  • Ensure the confidentiality of internal and external data
  • Perform ad-hoc projects and other duties as assigned

 

Professional Skills 

  • Verbal Communication – Proficient
  • Written Communication – Proficient
  • Teamwork – Proficient
  • Relationships – Proficient  
  • Negotiation – Proficient
  • Learning Agility – Proficient
  • Problem Solving – Proficient
  • Process Orientation – Proficient
  • Prioritization - Proficient

 

Role Specific Skills

  • SQL programming skills required
  • Advanced skills in Relational (MySQL) and Non-Relational (MongoDB) Database preferred
  • Data architecture and data analysis skills required
  • Understanding of Data Warehouse (RedShift) preferred
  • Experience in cloud-based database systems such as Amazon RDS preferred

 

Qualifications 


    Minimum Qualifications 

  • Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field required 
  • 2 or more years of experience in a relevant field required

 

Other Relevant Qualifications

  • Master’s degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field preferred
Read Full Job Description

Technology we use

  • Product
  • Sales & Marketing
    • AsanaManagement
    • JIRAManagement
    • HubSpotCRM
    • SalesforceCRM

Location

875 North Michigan Avenue , Chicago, IL 60611
How SMS Assist is Building Tech to 'Fix the Business of Fixing Things'
Watch

What are SMS Assist Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
SMS Assist's team fitness initiatives include In-office yoga, in-office fitness classes, and sponsored race teams.
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Happy Hours
Happy hours are hosted At team's discretion.
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Promote from within

Additional Perks + Benefits

Competitive Salary. Flexible Spending Plans. Prescription Drug Program. Free Fitness Center membership.

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