SMS Assist
Chicago, IL

Database Administrator at SMS Assist

| Chicago
Sorry, this job was removed at 2:41 p.m. (CST) on Monday, August 24, 2020
Find out who's hiring in Chicago.
See all Data + Analytics jobs in 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
See More
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Where we are

875 North Michigan Avenue , Chicago, IL 60611

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • AsanaManagement
    • JIRAManagement
    • HubSpotCRM
    • SalesforceCRM
Previous
Next

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
Diversity
Dedicated Diversity/Inclusion Staff
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
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.
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Company sponsored family events
Acme co. sponsors family oriented events Annually.
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Our game room includes Ping Pong, Pool Table.
Happy Hours
Happy hours are hosted At team's discretion.
Recreational Clubs
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Time allotted for learning
Paid industry certifications

Additional Perks + Benefits

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

Jobs at SMS Assist
19

All Jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Legal
Operations
Product
Project Mgmt
Sales
Tap to close

Sr. Service Delivery Manager

SMS Assist
Chicago
7 hours ago
+48
Consistently delivers exceptional client experiences that create increased client satisfaction, retention and willingness to be a reference. Establishes and grows relationships with assigned clients. Develops monthly updates, quarterly plans and presents annual business reviews to clients; develops strategies and improvement plans from those results. Leverages internal departments such as Sales, Operations, IT and Marketing to meet or exceed performance standards of established service level agreements (SLAs). Forecasts and measures account metrics to improve client revenue and retention. Develops and drives continuous improvement initiatives related to the client. Understands client objectives, resolves challenges and meets the needs of the client by performing regular assessments of data.

Vendor Recruiter Lead

SMS Assist
Chicago
2 days ago
+48
Lead the team of Vendor Recruiters to meet all targets by both removing barriers and building creative new vendor recruiting tactics and supporting growth strategies of the business. Establish a program plan and targets to proactively address all vendor needs of the business. Build new vendor networks in markets where new business is anticipated. Ownership of monitoring and driving program metrics, including status reporting to leadership and key stakeholders. Ensure new vendors are aware of performance expectations and equipped to successfully perform services. Develop a plan for oversight and coaching to affiliates during initial work orders.

Sales Director

SMS Assist
Chicago
2 days ago
+48
Deliver Revenue: Responsible for selling the full outsourced solution into the C-Suite or an “a la carte” single line of business to operations/procurement.  Maintain Customer Relationships: Maintain a thorough understanding of the customer’s structure and leadership, with the ability to influence key decision makers.  Identify and deliver on any opportunities to increase SMS Assist’s suite of offerings to existing customers. Keep Current on Industry/Customer Data: Maintain up-to-date, detailed customer knowledge and industry data. Read and research all relevant trade and industry materials, publications, news, etc.  Serve as an active member of groups and associations related to the industry and relevant customers.  Must be a ‘student’ of the residential market and other related industries. 

Senior Business Analyst

SMS Assist
Chicago
5 days ago
+48
The Senior Business Analyst is responsible for supporting operations by providing meaningful and actionable analytics. This role is assigned to a specific division and is responsible for driving operational and financial improvement. The role also partners with divisional leadership and additional departments to define and review analytics aimed at process improvement and efficiency.

Director of FP&A

SMS Assist
Chicago
5 days ago
+48
The Director of FP&A (Financial Planning & Analysis) is responsible for driving profitable business results and operational excellence by leading the financial support to SMS’ business units and providing in depth financial performance and operating metrics. This individual will maintain relationships internally within SMS operations, affiliate teams, and management. 

Attorney - Contract Manager

SMS Assist
Chicago
5 days ago
+48
The Attorney, Contract Manager role supports the business by reviewing, managing, and negotiating commercial agreements as part of the Legal Department. This includes negotiating agreements directly with suppliers, working with senior attorneys on more complex agreements, ensuring efficient management of the contracting process, and accurately documenting each contract. The role will require diligence, teamwork, and strong project management skills to advance multiple projects to completion and work seamlessly across all business units to ensure quick turnaround of agreements.

Product Manager II

SMS Assist
Chicago
1 week ago
+48
The Product Manager II leads and collaborates with various local and overseas teams and stakeholders to deliver value to customers, affiliates and internal users through delivery of well-defined, appropriately-prioritized and human-centric product solutions.

Product Manager I

SMS Assist
Chicago
1 week ago
+48
The Product Manager I is responsible for executing SMS Assist’s product strategy for a business area that helps secure the company’s role as the industry’s path of least resistance for multi-site property maintenance. This role is responsible for collaborating with a cross-functional team of engineers, designers and business stakeholders to prioritize and create innovative operational experiences that enable SMS Assist, their partners and their customers to drive quantifiable performance and efficiency improvements their property management operations. This role will leverage operations knowledge and metrics in all areas of the business to accomplish these goals.  The Product Manager will also contribute to SMS Assist’s Corporate and Product Strategy and ensure continued alignment between their product roadmap and the company’s business objectives.

Account Representative - 10:00 AM - 7:00 PM CST

SMS Assist
Chicago
2 weeks ago
+48
The Account Representative is responsible for the day to day delivery of facilities services to a number of major client sites within a geographic territory. This role plays an integral part in client account management, operational support, and financial success for the assigned client base. This role also works closely with multiple internal and external stakeholders to address daily client challenges, while identifying and executing opportunities to make meaningful improvements to client operations. The role is based at our corporate headquarters with travel to client sites as needed.

Software Developer II

SMS Assist
Chicago
2 weeks ago
+48
The Software Developer supports the Product and Technology Department by managing day to day activities within the organization's software development function. The Software Developer reports to senior team members and is part of an agile development team building and working on enterprise grade software. Software Developer is involved in all areas of development from design to development to testing.

Senior Software Developer I

SMS Assist
Chicago
2 weeks ago
+48
The Senior Software Developer supports the Product and Technology Department by managing day to day activities within the organization's software development function. Senior Software Developer is part of an agile development team building and working on enterprise grade software. Senior Software Developer is involved in all areas of development from design to development to testing. They lead a small team of Software Developers.

Manager of Learning Experience Design

SMS Assist
Chicago
2 weeks ago
+48
The Manager of Learning Experience Design (LX) is responsible for the effective performance of the Learning Experience (LX) Design service within SMS Assist, including the definition of learning standards, processes, and tools, liaising with departments to ensure learning needs are analyzed and met, and providing leadership to the LX team. The LX Manager helps define, build, and support the organization’s learning and development strategy.

Service Delivery Manager

SMS Assist
Chicago
2 weeks ago
+48
The Service Delivery Manager is responsible for driving profitable business results and operational excellence by creating and developing relationships with clients and delivering service that exceeds expectations. Their main focus is to act as a voice of the client to internal stakeholders, as well as driving a two-way relationship back to the client. This role serves as a key client contact and works with Sales, Operations, Legal and Technology to deliver an excellent client experience.

Senior DevOps Engineer II

SMS Assist
Chicago
2 weeks ago
+48
The Senior DevOps Engineer II supports the Product and Technology Department by developing and building IT solutions, installing and configuring solutions, and implementing reusable components. They will also translate technical requirements, assist with all stages of test data, develop interface stubs and simulators, and perform script maintenance and updates. This candidate must have experience in designing and implementing cloud solutions in Azure or AWS public cloud. 

Account Representative (Nights)

SMS Assist
Chicago
2 weeks ago
+48
The Account Representative is responsible for the day to day delivery of facilities services to a number of major client sites within a geographic territory. This role plays an integral part in client account management, operational support, and financial success for the assigned client base. This role also works closely with multiple internal and external stakeholders to address daily client challenges, while identifying and executing opportunities to make meaningful improvements to client operations. The role is based at our corporate headquarters with travel to client sites as needed.

Inside Sales Representative

SMS Assist
Chicago
2 weeks ago
+48
The Inside Sales Representative is responsible for sourcing prospective clients and creating interest of how SMS Assist services can benefit their organization. This position is an enterprise role working with sales, marketing, clients and prospective clients to build a sales pipeline. The position reports to the Manager of Inside Sales and Lead Generation and will serve as a support role for all Vice Presidents of Sales.

Asset Manager

SMS Assist
Chicago
3 weeks ago
+48
The Asset Manager is responsible for developing and managing SMS Assist asset management programs, implementing technology and strategic relationships to reduce expenses, improving product quality and accessibility. Specifically, they are tasked with developing standard performance metrics and reporting to provide local leadership with the visibility necessary to evaluate and drive improvement in the asset retention and protection, and structure cost effective programs with suppliers that meet local and remote operational demands and drive product quality and consistency.

Talent Development Manager

SMS Assist
Chicago
3 weeks ago
+48
This position is responsible for managing the strategy and implementation of processes and programs within the areas of performance management, talent management, development, and culture. This role will partner closely with HR Business Partners, Training, and business leaders to identify learning needs and define key programs that directly support business objectives and goals. This position will build our talent management strategy.

Sales Director - Residential

SMS Assist
Chicago
3 weeks ago
+48
Deliver Revenue: Responsible for selling services and solutions into the C-Suite of target REITs, institutional investors and property managers across various real estate assets classes with a focus on residential. Maintain Customer Relationships: Maintain a thorough understanding of the customer’s structure and leadership, with the ability to influence key decision makers.  Identify and deliver on any opportunities to increase SMS Assist’s suite of offerings to existing customers. Keep Current on Industry/Customer Data: Maintain up-to-date, detailed customer knowledge and industry data. Read and research all relevant trade and industry materials, publications, news, etc.  Serve as an active member of groups and associations related to the industry and relevant customers.  Must be a ‘student’ of the residential real estate sector, the “proptech” sector and other related sectors. Ensure confidentiality of internal and external data. Perform ad-hoc projects and other duties as assigned. Expected Travel Time: 25-50% of the time typically on 1-3 day trips.