SQL Software Developer

This position is located in the Office of the State Superintendent of Education (OSSE), Office of the Chief Information Officer (OCIO). The CIO coordinates collaborative agency-wide technology strategic and tactical planning to ensure delivery of high quality technologies, voice communications, infrastructure, and networking services. The CIO leads the OSSE community in discussing, understanding, prioritizing, planning, applying, and refreshing information technology to advance the mission and attain strategic goals.

The purpose of the IT Specialist is to support the management, enhancement and development of front-end application technology solutions. The IT Specialist will be responsible for all Technical Design Documentation and artifacts involved in the project, designing the Application Architecture of the system, co-designing and developing services for interfacing with the data layer, and developing dashboards and reports and reports customized to specific groups, roles, and users of the target system.

Duties:

The IT Specialist works on problems of diverse scope where analysis of technology requires evaluation of identifiable factors. Demonstrates good judgment in selecting methods and techniques for obtaining solutions. Networks with both internal and external personnel in own area of expertise.

• Shows aptitude for owning responsibility of technical decisions and direction for one or many projects/teams.
• Aptly manages team demands on his/her time and shows willingness/ability to delegate technical execution or responsibilities when appropriate.
• Acts as a liaison or primary point of contact for communicating with client side technical expertise.
• Directs technical aspect of operations related to escalated or high severity issues as they affect or confront a project or team.
• Attends to both business and technical considerations when designing solutions to project/team or company related issues.
• Demonstrates interest in improving the agencies technical awareness, depth and use of technology across the business.
• Participates in the evolution of company level best practices, standards, and policies as it related to software development.
• Provides thought-leadership as it relates to emerging technologies and readying our company and engineers for productively integrating the same into our business.

Excellent written and communications skills. Knowledge of information technology and functional design of information systems.

Full knowledge of .NET Framework, C#, JavaScript, AJAX and MVC.

Experience of SQL, SQLDB design and development including Stored Procedures and SSIS, SSRS

Experience designing, developing and supporting highly scalable architecture solution that supports mobile and web

Familiarization of REST API design and development, Java/Java EE and related tech stack, Spring Framework, Database, RESTful APIs, SOA, ESB, message

Familiarization of message queuing, Sockets and JavaScript frameworks, NodeJS, iOS (Objective C, iOS SDK); Android (Android Framework, Java); Hybrid

Expert knowledge of relational database management concepts, principles, and methods including database logical and physical design, normalization, and storage capacity management concepts.

Familiarization of project management principles and methods sufficient to plan and coordinate the development of data structures and access strategies in alignment with mission requirements; establish testing, implementation, and post-implementation support procedures and develop user instructions.

Knowledge of the concepts of database management systems, operating systems, technical architecture, and network topology. Understanding of network architecture sufficient to read and understand network system architectures.

Licensures, Certifications and other requirements

None

Education

Graduate of an accredited Master’s degree program in Information Technology or related field or equivalent experience.

Work Experience

At least four (4) years of relevant work experience in a large scale/enterprise development program.

Work Environment

The work is performed in an office environment.

Conditions of Employment

While on duty, District employees are prohibited from possessing, dispensing or being impaired by controlled substances, including alcohol. All District employees are subject to drug and alcohol testing when there is a reasonable suspicion of impairment or following any on-duty accident or incident involving injury to person or property.

Employment Benefits

Employees will be eligible to receive health and life insurance benefits and retirement benefits. More information about these benefits is available on the D.C. Department of Human Resources (DCHR) website at www.dchr.dc.gov.

Closing Statement

Office job offers are made by the Office of the State Superintendent of Education (OSSE), Office of Human Resources only.