Software development and DBA

Job Description

Job Description

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.

Responsibilities

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.

Skills Needed

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

Proven work experience as a software development manager Required 10 Years

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

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

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

Comprehensive understanding of database systems and database programming techniques including MS SQL Server 2016 Database and tSQL Required 10 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

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