Sign in

MS BI Developer - F2F - Des Moines, IA - Long term - W2/c2c

Company:
MSys Inc
Location:
Des Moines, Iowa, United States
Posted:
January 07, 2019

Description:

Title: MS BI Developer - F2F Interview

Location: Des Moines, IA, United States

Length: Long term

Send resumes to

Job Description:

*** Very long term project; Initial PO till 6/30/2019 - expect to go for 5+ years *** F2F Required; reasonable expenses will be paid for f2f interview ***

PLEASE NOTE*** The client is ONLY scheduling IN-PERSON INTERVIEWS for this position. They WILL NOT schedule webcam or phone interviews. Please ONLY SUBMIT CANDIDATES who can EASILY ATTEND an IN-PERSON INTERVIEW if selected to interview***

Responsibilities:

• Assist in designing, developing, and enhancing large transaction and reporting databases.

• Assist in converting existing Legacy applications to newer technologies

• Assist in integrating in-house applications with third-party enterprise solutions.

• Design, create and implement database systems based on the end user's requirements.

• Develop database schemas, tables and dictionaries using SQL server 2008 R2, 2012, and 2016.

• Translate business requirements into software applications and models.

• Develop and maintain efficient, well-documented custom SQL scripts; stored procedures triggers using Microsoft T-SQL by defined business rules and requirements to support application development

• Create and troubleshoot stored procedures and queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor and Execution plans. Recommend query and index improvements in application to increase performance.

• Thoroughly test all approved application and database code additions and changes before implementing to staging. Request approval from users before implementing any additions or changes to the production environment.

• Research, understand and apply best practices, cost-effective solution, policies and procedures towards all assigned tasks, roles and responsibilities.

• Use the Microsoft Team Foundation Server (TFS) to manage changes to the code.

• Participate in requirement analysis discussions and come up with an efficient technical solution

• Develop new and maintain existing reports using SQL Server Reporting Services (SSRS)

• Build and Deploy ETL processes using SQL Server Integration Services (SSIS).

Required Experience

• Demonstrated experience with relational database design and implementation using MS SQL Server

• Experience optimizing SQL queries for improving performance and maintaining data integrity

• Experience in creating database migration scripts by using schema and data compare tools

• Experience in creating batch packages using SSIS

• Experience in creating reports using SSRS

• Experience in architecting, writing and maintaining RESTful APIs/Services

• Write efficient, consistent and testable code

• Proficiency with using Visual Studio 2012,2015 & 2017

• Ability to understand and analyze the business requirements and come up with a practical technical solution

• Demonstrated experience in SOA and web service development

• Experience in using LINQ

• Demonstrated experience with C#, .NET framework, and object-oriented design/development.

• Demonstrated experience with Microsoft Azure cloud services

• Being able to work with minimal requirements and improve the functionality as requirements are refined

• Technical understanding of infrastructure components, their dependencies, and interactions between servers, virtual systems, networks, databases, web applications, etc.

Required Skill

• Experience with working with different versions of SQL server (2008 R2, 2012 and 2016) 5+ years

• Expert knowledge of TSQL 5+ years

• Database modeling & Design 5+years

• Experience in creating batch packages using SSIS 3+ years

• Experience in creating reports using SSRS 3+years

• Experience optimizing SQL queries for improving performance and maintaining data integrity 5+ years

• Experience with C#, .NET framework, and object-oriented design/development 5+ years

• Experience in architecting, writing and maintaining RESTful APIs/Services 5+years

• Experience in using LINQ 5+ years

• Experience with Microsoft Azure cloud services 1-year minimum

• Proficiency with different versions of Visual Studio (2012,2015 & 2017) 5 + years

Desired Skills

• SNAP/Medicaid

• certifications

• public sector experience