Job Description :
NOTICE:
1) Interviews will be conducted on MAY 18th, 19th, and 20th.Only to submit candidates who are available to interviews on the date(s) provided.
2) Due to COVID-19, the client has agreed to allow the selected candidate to work remotely for the time being. However, the selected candidate must be available to report in person as directed by the client on the first day to pick up equipment. DHS WILL NOT SHIP EQUIPMENT. THE CONTRACTOR MUST RELOCATE TO DES MOINES TO BE CONSIDERED A VIABLE CANDIDATE FOR THIS POSITION.
3) This position REQUIRES the selected candidate to work ONSITE for the duration of the assignment once clear to return to the facility. Candidates should be fully aware of this requirement if submitted.
IA-DHS-AA2 Database Analyst (622503)
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+years39; experience in Azure DevOps
• Boards
• Repos
• Pipelines
• Releases
At least 1+ years39; experience with Azure Components is a plus
• Data Factory
• Data Lake
• Data Bricks
• SQL Data Warehouse
• Stream Analytics
Required/Desired Skills
Skill
Required/Desired
Amount
of Experience
writing and performance tuning complex TSQL queries at an expert level
Required
8
Years
writing SQL to access commercial databases like PeopleSoft, Microsoft Dynamics, Workday, SAP or similar for user reports.
Required
2
Years
design and modeling OLTP databases using the many type of objects in Microsoft SQL Server Database Engine 2016 and newer
Required
5
Years
writing SSIS packages that used objects like calculated columns, script tasks, parameters, and primarily CRUD SQL that were scheduled to run on a.
Required
3
Years
.basis for SQL Server 2016 or later.
Required
3
Years
creating/managing Team Foundation Server Automated Build and Release Definitions in a DEVOPS process
Required
3
Years
using visual studio database projects to for the build of database changes and maintaining database source control in a DEVOPS process.
Required
5
Years
In depth understanding of using Entity Framework against SQL Server(e.g. coding, debugging, optimizing)
Required
0
In depth understanding of using Reporting Services against SQL Server(e.g. The abilities of what can be done in a report vs. TSQL)
Required
0
In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
Required
0
In depth understanding of Networks(e.g. Network Transmission Protocols, Firewalls, DNS, troubleshooting)
Required
0
Excellent verbal and written communication skills
Required
0
Experience as a developer coding VB.NET or C# - Visual Studio 2017 or newer
Required
0
Experience creating/managing Control-M Scheduler jobs
Required
0
Experience in Data Warehouses
Required
0
Experience with Azure DevOPs (boards, repos, pipelines, releases)
Required
2
Years
Experience with Azure Components (Data Factory, Data Lake, Data Bricks, SQL Data Warehouse, Stream Analytics)
Required
1
Years