Quicken Loans Sr. Database Engineer in Detroit, Michigan

Rock Connections is a contact services provider that makes interactions between brands and consumers easier and more effective. The company leverages technology, data, and industry-leading training to strategically connect with consumers in the most effective way – improving conversion rates and providing a greater return on marketing investments. Rock Connections has a proven track record of strengthening brand reputations and driving value for the businesses it represents. Serving a wide range of well-known, national brands, Rock Connections provides client care and sales in a variety of industries, including finance, automotive and health care.

The Database Engineer uses versatile database technology expertise to build databases that are high-quality, scalable and high-performance to meet the demands of our rapidly growing and ever-changing environment. Database engineers are responsible for database designing, supporting existing databases, performance tuning on premises and in the cloud. Database engineers will design and implement ETL processes to fulfill analytical needs of the business.

Responsibilities

  • Install and configure database server

  • Design databases in the normalized model and dimensional model

  • Ensure quality data creation, presentation and data flow across systems

  • Maintain responsibility for database logical and physical design, and performance tuning on queries

  • Provide data integration solutions across systems

  • Assist writing complex stored procedure and optimize execution efficiency in Microsoft SQL Server environment and Redshift

  • Support and maintain quality data

  • Enforce database best practices and data security

  • Participate in code and design review

  • Work closely with application teams and business owners

  • Take ownership and use proper technical knowledge to help the business make right decisions

  • Research and evaluate third-party tools

  • Participate in regular on-call rotation

  • Collaborate and communicate with team members on daily basis

  • Enhance database applications in an very dynamic environment

Requirements

  • Bachelor’s degree in computer science or concentration in a technical field, or equivalent experience

  • Five years of experience in developing Microsoft SQL database or Redshift applications

  • Understanding of database design/architecture in a Microsoft SQL Server environment or AWS Redshift

  • Basic database administration operations experience in a Microsoft SQL Server environment or in AWS Redshift

  • Knowledge of Transact SQL

  • Ability to create stored procedures and SQL views

  • Experience working with ETLs

  • Possess deep understanding of databases as a developer

  • Experience creating SSIS packages for data integration

  • Experience with data modeling, query design and optimization, as well as stored procedures

  • Experience with functions and scripting

  • Knowledge related to computer hardware, cloud platforms

  • Ability to understand large data models quickly

  • Strong ability to work with and provide technical leadership to other team members

What’ll Make You Special

  • Enterprise-level experience with Microsoft SQL Server and AWS products

  • NoSQL technologies

  • Salesforce experience

  • Demonstrated experience with DB optimization and tuning

  • Paid training

  • Strong growth and leadership opportunities

Why We're Different

Meet the anti-corporate culture of Rock Connections, where there's no daunting hierarchy, "boss" is a four-letter word, and if you work hard, you're the one who will reap the rewards, both personally and professionally. More than any other place you'll work, we're dedicated to honing your skills, helping you grow and making sure you have plenty of fun while you're at it.

Rock Connections is an equal opportunity employer.

Record Name: Rock Connections LLC

External Company Name: Quicken Loans Inc.

External Company URL: www.quickenloans.com

Street: 1050 Woodward Avenue