Database Manager Jobs in Boise, ID (NOW HIRING)

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients - including governmental agencies and private companies - throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Agency Project Scope (Description of Work Needed - Additional background check requirements are to be added here)

Payroll Based Journaling Project

The Centers for Medicare and Medicaid Services ("CMS") will require the Agency to submit verifiable and auditable direct care staffing information for each of the Idaho State Veterans Homes beginning July 1st 2016. Project objectives is to develop a system that: (1) extracts, transforms, and load ("ETL") State employee data from the State Controller's Office for submission to CMS; (2) develop a system to collect contracted employee data for ETL and submission to CMS.

Application Redesign and Migration Projects

Redesign and migration of existing SharePoint applications to into standalone applications for the (1) Cemetery Management System, (2) Volunteer Management System, (3) and In-service Management System. The software engineer will develop, standalone applications in a manner that simplifies the help desk support burden, future application model customization, feature development, and troubleshooting tasks for the existing Agency IT staff.  

General Requirements

A System Requirements Specification ("SRS") will be created for each application prior to implementation. A descriptive, non-abbreviated, naming scheme will be used for code objects and their purposes will be described. At minimum, XML source code comments will be used to describe class summaries, property descriptions, method parameters, return types, and when necessary special remarks and code examples to assist future developers. Engineer must use the technologies described in the Specific Skills Required section to complete this order.  

Application Requirements

All described applications will have the following common application requirements: (1) will not require an application server host such as SharePoint or Internet Information Services; (2) implement a Windows Forms controls and components platform; (3) utilize an on premise SQL server as the application data store; (4) implements a framework for automatic User Interface generation; (5) implements an Object Relational Mapping ("ORM") framework that automatically manages data access layer code functions, and database schema updates from business object class code; (6) avoids the use of SQL stored procedures where possible; (7) when required, refactor existing databases for data quality and normalization prior to migration; (8) ETL data into redesigned applications; (9) implement an application model editor that provides program feature customization at runtime.

Specific Skills Required (Programming languages, databases, operating systems, etc.) 

• C# programming language.
• ExpressApp Framework (XAF) and Express Persistent Objects (XPO) application development framework and ORM framework.  
• Model-View-Controller (MVC) architectural design pattern and coding practices; 
• Understanding of NET Framework class libraries: XML, Text, IO, Net, Directory Services, Component Model, Language Integrated Query, and Windows Forms coding practices.
• Microsoft SQL Server, Data Quality Tools, SQL Server Integration Services, data cleansing, database normalization, and ETL practices.
• Development of SRS documentation, use cases, acceptance criteria, and test plans. 
• Team Foundation Server, Scrum, and Kanban agile software development project methodology and tools. 
• Visual Studio integrated development environment.

Experience: Min 6 years

Key Skills: 

• Sharepoint
• SQL Svr
  
• C#
  
• ExpressApp Framework and Express Persistent Objects application development framework and ORM framework
  
• MVC architectural design pattern and coding practices
  
• SSIS
  
• Data cleansing, migration and ETL
  
• TFS
  
• Agile
  
• Visual Studio
  

1. Good comm skills are a big priority
2. Duration: 12+ Months