Software Development Manager REMOTE

Job Title: Data Base Analyst (REMOTE)

Location: Raleigh NC

Duration: 12 Months

Job Description:

The Technical Specialist is an expertlevel resource with specialized knowledge and experience in the internally developed client. 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 Client 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 KSAs:

• 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 enterpriseoriented application development agilebased development methodologies objectoriented 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 KSAs

• Expert level database management experience related to the Client application suite
• Comprehensive understanding of database systems and database programming techniques.
• Extensive experience with Microsoft SQL Server database administration in a Windows Environment.
• Excellent TSQL skills.
• Extensive understanding of database systems and ETL (extraction transformation and load) concepts.
• Proficiency in reporting and data visualization software such as PowerBI Tableau SQL Server Reporting Services and MS Report Builder.

• General KSAs:
  • 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 problemsolving 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 multitask 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 fastpaced 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 fastpaced environment. Must also be able to keep track of other developers work.

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

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