NCSBE - Technical Specialist- Expert

The purpose of this position is to provide database administration, data analytics and development assistance that improves the future administration of elections for Federal office.

• This is a part-time position working 10-20 hours / week.
• This is a remote position.

The Technical Specialist is an expert-level resource with specialized knowledge and experience in the internally developed North Carolina Statewide Elections Information Management System (SEIMS). The Technical Specialist has an overall knowledge and understanding of application development and architecture that serves as a strong base for technical expertise in the SEIMS application suite.

The duties and responsibilities of this position are listed below :

Database Administration

Provide consultation to IT development and data teams regarding the design of database systems for election modernization efforts.

Review database scheduled jobs and associated stored procedures to provide recommended improvements as needed

Data Analyst

Generate complex queries in response data requests, list maintenance and Federal reporting requirements.

Development

Provide code development work and consultation for election modernization efforts.

Troubleshoot applications as well as make suggestions for improvement

Documentation

Develop technical documentation as needed

Document, replicate, and provide specific details regarding issues found in production or testing.

The Technical Specialist must have the following Knowledge, Skills and Abilities (KSAs) :

Developer KSA s :

Expert level development experience with the North Carolina State Elections and Information Management System (SEIMS) application suite

Proven work experience as a software development manager

Ability to design and implement highly scalable applications, APIs, and database components.

Extensive technical knowledge to serve as a resource in solving problems of high complexity, and to devise or modify systematic processes to solve complex problems, accounting for computing capacity and limitations.

Expert knowledge and practical experience with C#, Javascript, Razor, and tSQL.

Knowledge and experience working with developing objects such as stored procedures, views, etc. against a MS SQL Server 2016 Database

Knowledge in the following development practices is required : distributed, enterprise-oriented application development, agile-based development methodologies, object-oriented development, web application development (preferably .net web applications using Blazor, MVC and Razor Pages with Javascript / HTML / CSS / Bootstrap), and database object structure.

Knowledge of the architecture design and security protocols of systems being developed. Knowledge and practical experience with a software testing procedure and / or toolset.

Knowledge in the complete Software Development Life Cycle (SDLC) including, but not limited to, waterfall and agile development. This should involve a working knowledge of processes involving technical specification documentation and analysis, workflow diagrams, data modeling, project artifact documentation and quality assurance.

Knowledge and practical experience in the use of cloud computing technologies and deployment (preferably with Microsoft Azure environment).

Knowledge and practical experience with the following tools : Microsoft Visual Studio, version control software (preferably Git), reporting tools (such as Microsoft SQL Server Reporting Services), and Azure DevOps tools.

Database Administration and Analyst KSA s

Expert level database management experience related to the North Carolina State Elections and Information Management System (SEIMS) application suite

Comprehensive understanding of database systems and database programming techniques.

Extensive experience with Microsoft SQL Server database administration in a Windows Environment.

Excellent T-SQL skills.

Extensive understanding of database systems and ETL (extraction, transformation, and load) concepts.

Proficiency in reporting and data visualization software such as Power-BI, Tableau, SQL Server Reporting Services and MS Report Builder.

General KSA s

Knowledge and practical experience in the use of Microsoft Office applications (Outlook, Word, Excel, Access, and PowerPoint).

Knowledge of Microsoft Windows environment, including but not limited to structure, basic security access and permissions, basic networking, and basic device management as it pertains to software applications.

Communication : Must have excellent communication, documentation, and presentation skills for technical and business audiences.

Problem Solving : Must have outstanding problem-solving skills as part of the design as requirements change or technical solution is designed, or as issues arise.

Development Skills : extensive technical knowledge is desired to serve as a resource in solving problems of high complexity, and to devise or modify systematic processes to solve complex problems, accounting for computing capacity and limitations.

Time Management : Ability to multi-task is important, including being able to perform duties reasonably simultaneously to meet work schedules. Ability to manage priorities and time as it relates to assigned tasks and work deadlines and adapt work to unanticipated changes to meet deadlines in a fast-paced environment. Must be able to lead others and provide technical guidance.

Planning and Organization : Ability to work independently, manage work with minimal supervision, and adapt work to unanticipated changes to meet deadlines in a fast-paced environment. Must also be able to keep track of other developers' work.

Required / Desired Skills

Skill

Required / Desired

Amount

of Experience

Expert level development experience with the North Carolina State Elections and Information Management System (SEIMS) application suite

Required

Years

Proven work experience as a software development manager

Required

Years

Ability to design and implement highly scalable applications, APIs, and database components

Required

Years

Extensive technical knowledge to serve as a resource in solving problems of high complexity.

Required

Years

Expert knowledge and practical experience with C#, Javascript, Razor, and Blazor

Required

Years

Comprehensive understanding of database systems and database programming techniques including MS SQL Server 2016 Database and tSQL

Required

Years

Expert knowledge and practical experience with MS Azure (DevOps), Visual Studio, Git tools

Required

Expert knowledge and practical experience working with SDLC, waterfall and agile processes and methodologies

Required

Questions

Question

Question1

How soon can your candidate start if selected for this opportunity?

Question2

Vendors are encouraged to submit candidates that are available for the duration of the assignment. Do you anticipate your candidate being able to work until the proposed end date listed on this VectorVMS req?

Question3

Candidates submitted above the hourly Vendor Rate of $$$ may not be considered for this assignment. Do you agree to this requirement?

Question4

Does the candidate have over 10 years of development and database experience with the North Carolina State Elections and Information Management System (SEIMS) application suite?

Question5

This position will be subject to a background check. DHS carries all security clearances for SBE. This position may require the receipt and ongoing maintenance of a security clearance. Would the candidate be able to meet these security clearance and background check requirements?

Question6

Is the candidate a US Citizen and legally allowed to work for the State of North Carolina?

Question7

Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm?

Question8

Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirement?