Database Specialist (Part-Time),Remote, NC,United States

Database Specialist (Part-Time),Remote, NC,United States

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.

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):

• 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.
• Knowledge and experience working with developing objects such as stored procedures, views, etc. against a MS SQL Server 2016+ Database
• 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.
• 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.

Skill Matrix:

• 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
• 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