Database Developer II

United Wholesale Mortgage; Pontiac (MI); On-site; USD 85,000 - 110,000; Full time

Job summary

United Wholesale Mortgage is hiring multiple Database Developer IIs for 100% on-site roles in Pontiac, MI. The role focuses on database development, data warehousing, ETL, and analytics to support OLTP/OLAP environments.

Requirements include a Bachelor's degree in Computer Science or related field and 2 years of related experience. Candidates must be on-site in Pontiac, MI and ready to work in a fast-paced data-driven setting.

Qualifications

• Bachelor's degree in Computer Science, Engineering or related and 24 months related experience.

Responsibilities

• Develop and administer Microsoft SQL Server databases (2016/2012/2008).
• Design data models to support OLTP and OLAP systems.
• Apply DBA techniques: backups/restores, clustering, replication, automation, performance tuning.
• Develop new models and data warehouse architectures for analytics.
• Design analyses, reports, applications, and systems.
• Responsible for ETL packages and data warehousing/architecture activities.
• Responsible for DTS, SSIS and other ETL applications.

Skills

SQL

Data modeling

ETL processes

Analytical thinking

Education

Bachelor's degree in Computer Science/Engineering or related

Tools

SSIS

DTS

SSMS

Job description

United Wholesale Mortgage

Hiring multiple Database Developer IIs for 100% on-site positions in Pontiac, MI.

Duties:

• Develop and administer Microsoft SQL Server 2016, 2012, and 2008 relational database management systems.
• Design conceptual, logical and physical data models necessary to support OLTP and OLAP systems.
• Apply database administration techniques, such as online backups/restore management, clustering, replication, automation and performance tuning to ensure higher availability.
• Develop new models, analytic processes, and construction of operational database and data warehouse architectures.
• Design and prototype new analyses, reports, applications and systems.
• Responsible for database and SQL development, ETL packages for data warehousing and data architecture activities.
• Responsible for DTS, SSIS and other ETL applications.

Req. Bachelors degree in Computer Science, Engineering or related and 24 months related experience.