OLTP SSIS SQL Server VB Script Azure DevOps Troubleshooting C# Data Warehouse Writte   Requirement id 106562 Job title Analyst Job location in Des Moines, IA Skills required T SQL, OLTP, SSIS, SQL Server VB Script Azure DevOps Troubl Open Date 12-May-2020 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: T SQL, OLTP, SSIS, SQL Server VB Script Azure DevOps Troubl Note: Candidates need to be local to Des Moines, IA for this position. Will be required to sit onsite once Covid-19 passes.Position is more of a Database Modeler/Developer vs a Database Analyst. Hiring Manager is looking for someone that is very skilled and knowledgeable. Will be filling the role of a skilled full-time employee. Candidate must be our W2 Employee. Candidate must be local : Yes Job Description : Database Modeler/Developer 12+ Month Contract Des Moines, IA Position Overview Responsible for designing, modeling, developing and supporting Microsoft SQL Server 2016. Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Develops database and warehousing designs across multiple platforms and computing environments. Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment. Designs and supports DBMS of low to medium complexity. Works on one or more projects as a project team member or sometimes as a project leader. May coach more junior technical staff. Primary Skill Set 8+ years where the primary job function was writing and performance tuning complex TSQL queries at an expert level 2+ years writing SQL to access commercial databases like PeopleSoft, Microsoft Dynamics, Workday, SAP or similar for user reports. 5+ years where the primary job function was design and modeling OLTP databases using the many type of objects in Microsoft SQL Server Database Engine 3+ years where the primary job function was design and modeling OLTP databases using the many type of objects in Microsoft SQL Server Database Engine 2016 or newer 3+ years where the primary job function was writing SSIS packages that used objects like calculated columns, script tasks, parameters, and primarily CRUD SQL that were scheduled to run on a regular basis for SQL Server 2016 or later. 3+ years creating/managing Team Foundation Server Automated Build and Release Definitions in a DEVOPS process 5+ years actively using visual studio database projects to for the build of database changes and maintaining database source control in a DEVOPS process. In depth understanding of using Entity Framework against SQL Server(e.g. coding, debugging, optimizing) In depth understanding of using Reporting Services against SQL Server(e.g. The abilities of what can be done in a report vs. TSQL) In-depth understanding of data management (e.g. permissions, recovery, security and monitoring) In depth understanding of Networks(e.g. Network Transmission Protocols, Firewalls, DNS, troubleshooting) Excellent verbal and written communication skills Secondary Skill Set Experience as a developer coding VB.NET or C# Visual Studio 2017 or Newer Experience creating/managing Control-M Scheduler jobs Experience in Data Warehouses Preferred at least 2+years experience in Azure DevOps Boards Repos Pipelines Releases At least 1+ years experience with Azure Components is a plus Data Factory Data Lake Data Bricks SQL Data Warehouse Stream Analytics   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 106562 while calling.   Other jobs in IA: Des Moines (16), West Des Moines (2), West Desmoines (1), T SQL job openings in Des Moines, IA Jobs List IA-DVSR-TS3-Technical Specialist (704247) Create date: 28-Feb-2023 Remote Start date :03/20/2023 End Date :02/29/2024 Submission deadline :3/3/2023 Client Info :DVRS: Department of Vocational Rehabilitation Services Description : Iowa Vocational Rehabilitation Services is recruiting a technical specialist/developer to enhance the Iowa Rehabilitation Servi.... (This job is for - Sql Server 2000Business Analyst Jobs in IA DesMoines Specialist - (in Des Moines, IA)) IA-DHS-SDP6 Sr. SQL Server/Full Stack Developer (685727) Create date: 21-Jun-2022 Start Date : 7/11/2022 End Date : 06/30/2023 Submission Deadline : 6/23/2022 Client Info : DHS-IMHI: Department of Human Services Description : The successful candidate will spend a good portion of their time working with the Systems that support Chil.... (This job is for - Sql Server 2000SSRS Jobs in IA DesMoines Developer - (in Des Moines, IA)) IA-DHS-DBA5-SQL Developer (675844) Create date: 17-Feb-2022 Start Date :03/14/2022 End Date :06/30/2022 Submission Deadline :02/23/2022 Client Info : DHS-CWIS: Department of Human Services Note : * Agency Interview Type: Agency Interview Type: Description : The successful candidate will spend a good po.... (This job is for - Sql Server 2000Database Admin Jobs in IA DesMoines Developer - (in Des Moines, IA)) IA-DHS-DBA5-SQL Server/Full Stack Developer (670815) Create date: 06-Jan-2022 start date:1/31/2022 End date:06/30/2022 submission deadline:1/12/2022 client info : OEM Description: The successful candidate will spend a good portion of their time working with the Systems that support Child Care, Child Welfare, Medicaid, TANF, and SNAP Systems and expected to work in concert with.... (This job is for - Sql Server 2000 Jobs in IA DesMoines Developer - (in Des Moines, IA)) SQL ServerFull Stack Developer (654590) Create date: 29-Jun-2021 Start Date:06/14/2021 End Date:06/30/2021 Submission Deadline:7/2/2021 Client Info:DHS-IMHI: Department of Human Services *Note: Agency Interview Type: Web Cam Interview Only Description: The successful candidate will spend a good part of their time working with the Systems that supp.... (This job is for - Sql Server 2008Modeling Jobs in IA DesMoines Developer - (in Des Moines, IA))    T SQL job openings in other states Jobs List Programmer/Developer -62703 Create date: 08-May-2024 No of Submissions : Start date : 06/01/2024 End Date : 06/01/2025 Submission deadline : 05/20/2024 Client Info : CT DCF Position Location : Hybrid Description : ------------------------------------------------------ The Department of Children and Families depends on th.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) VDOT Bus Analyst - Clifton Forge, VA (687761) Create date: 25-Jul-2022 Start Date : 08/08/2022 End Date : 06/30/2023 Submission Deadline : 7/27/2022 Client Info : VDOT Description : *Candidates must live in Virginia and be able to go to Clifton Forge, VA location to pick up laptop *Candidates must be willing to come .... (This job is for - job Jobs in VA CliftonForge Analyst - (in Clifton Forge, VA)) Expert Software Developer - 6950 Create date: 08-Jul-2022 Description: Qualifications Software Developer - Is involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software. Expert 84 + Months - Candidate is able to provide guidance to large teams and/or has extensive industry exp.... (This job is for - SQL Jobs in NY Albany Developer - (in Albany, NY)) NJDOH ASAPM Back End/DB Developer (683192) Create date: 23-May-2022 Start Date :05/23/2022 End Date :06/30/2022 Submission Deadline :5/20/2022 Client Info :DOH Description : Please do not submit any candidates that are in need of remote work - this is 100% onsite role. Please do not submit any candidates that interviewed for NJDOH ASAPM Back End/DB Develo.... (This job is for - job Jobs in NJ Trenton Developer - (in Trenton, NJ)) Senior Power BI Developer - 55967 Create date: 12-Nov-2020 start date:11/30/2020 End date:11/29/2021 submission deadline:11/18/2020 client info : NeEDU Description: Bachelors degree in computer science or a related field or related experience. Minimum of eight years of experience in Power BI dev.... (This job is for - SDLC Jobs in NE Lincoln Developer - (in Lincoln, NE))    T SQL job openings in IA Jobs List IA-HHS-SDP6-Senior SQL Server Developer-703584 Create date: 15-Feb-2023 Start Date : 03/13/2023 End Date : 06/30/2024 Submission Deadline : 2/20/2023 Client Info : DHS-IMHI: Department of Human Services Note: * Either Web Cam or In Person Interview Description : The successful candidate will spend a good portion of the.... (This job is for - job Jobs in IA Moines Consultant - (in Moines, IA)) IA-DHS- SDP6-Senior .Net Developer (Full Stack) (681127) Create date: 28-Apr-2022 Start Date:05/16/2022 End Date :06/30/2022 Submission Deadline:5/3/2022 Client Info :DHS-IMHI: Department of Human Services Description : The successful candidate will spend a good portion of their time working with the systems that support Child Care, Child Welfare, Medicaid, TANF, and SNAP Sy.... (This job is for - job Jobs in IA PolkCounty Developer - (in Polk County, IA)) Senior SQL Developer/Designer( .Net, SQL And Azure)(613404) Create date: 06-Nov-2019 Start Date : 11/25/2019 End Date :06/30/2020 Submission Dead Line : 11/12/2019 Client Info :DHS-IMHI: Department of Human Services Description : The successful candidate will spend a good portion of their time working with the Systems that support Child Care, Child Welfare,.... (This job is for - Sql Server 2008 Jobs in IA PolkCountry Developer - (in Polk Country, IA)) (Analyst: T SQL, OLTP, SSIS, SQL Server VB Script Azure DevOps Troubl in Des Moines, IA)

Featured Jobs ASP.Net .Net Developer (Jobs in Richmond, Virginia) PMO Manager (Jobs in Richmond, Virginia) MVC JQuery. Developer (Jobs in Richmond, Virginia) Project Manager Document Manager (Jobs in Richmond, Virginia) TED Supervision Hospital Specialist (Jobs in Raleigh, North Carolina) Excellent Consultant (Jobs in Lincoln, Nebraska) Quality Tester (Jobs in COLUMBIA, South Carolina) Documentation Analyst (Jobs in Hartford, Connecticut) System Specialist (Jobs in Salem, Oregon) MicrosoftOffice Specialist (Jobs in Salem, Oregon)