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

Location

875 North Michigan Avenue , Chicago, IL 60611

What are SMS Assist Perks + Benefits

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
Retirement & Stock Options Benefits
401(K)
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Vacation & Time Off Benefits
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Professional Development Benefits
Job Training & Conferences

Additional Perks + Benefits

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

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