Software Engineer- usa job vacancy

Job title: Microsoft Datawarehouse - Software Engineer
Location Detroit Michigan, United States of America
Category: Executive
Duration: Full time
Start Date: ASAP
Rate: 85k - 100k year + bonus + benefits + relo help
Organization: Career Brokers
Contact Sean Napoles
Web Link http://www.careerbrokers.com
Reference JS-MICROSOFT BI = DETROIT
Deadline: 15/7/2013

 NOTE: No contractors/subs, you must work on-site, and you must join them "direct/full-time."

Relocation reqs: You must move to Michigan and work downtown Detroit.

Technical reqs:

4 + years experience with SQL Server 2005/2008 T-SQL Coding
2+ years experience with SQL Server 2005/2008 Database Administration
Microsoft SQL Management Studio, Query Analyzer, SQL Profiler (or similar tools)
Advanced knowledge of Transact SQL and query optimization
A deep understanding of SQL Server as a developer
Stored Procedure and Index creation/optimization

Duties;

The main responsibilities will include creating stored procedures for complex queries, monitor system performance and implement query and table optimizations where appropriate, and mentoring software engineers on query and schema design.
By working closely with business analysts and software engineers, this solution oriented individual will turn the requirements for our applications into a highly scalable and fast performing transactional system that helps meet business goals.
While working closely with the technology team and the reporting specialist, this team player will gain the knowledge necessary to build and maintain all schema changes that the business requires on our own internal platforms.
The position will create new and maintain the existing ETL, SSIS, and other data transfer jobs which feed our existing database from other systems, as well as overall database administration duties.
Monitoring and managing all ETL, SSIS, and other data transfer jobs.
Adhering to any standards set by the Quicken Loans DBA team.
Optimizing all new database schema changes and reviewing them with the BI Team.
Read, understand and provide estimates for business requirements to be completed during the Agile Iteration(s).
Validate data to ensure the integrity of all reports.
Work directly with the business users and software engineers to understand and clarify their requirements.
Find and implement new technologies to optimize the database performance.
Creating routine reports for how the database is performing which will be used to prioritize changes.
Implementing database unit tests to ensure that all business requirements are met.
How to apply: Visit; http://www.computerjobs.com/us/en/search-jobs-in-Detroit,-Michigan,-USA/MICROSOFT-DATAWAREHOUSE-SOFTWARE-ENGINEER-7EAADAC2D6E3CF74/?utm_source=17&utm_medium=job&utm_content=1&utm_campaign=JobSearchLanding