SQL Software Developer

DC Office on Aging; Washington (District of Columbia); On-site; USD 75,000 - 100,000; Full time

Benefits offered by this job

Health and life insurance benefits

Retirement benefits

Job summary

The DC Office on Aging is seeking an IT Specialist to support management, enhancement, and development of front-end application technology solutions. This role involves creating technical design documentation, designing application architecture, and developing reports tailored to specific user needs.

Ideal candidates will have a Master's degree in Information Technology, 4+ years of experience in a large-scale development program, and be proficient in .NET Framework, C#, SQL, and JavaScript.

Employment includes health and life insurance benefits, along with retirement plans.

Qualifications

• Excellent written and communication skills.
• Full knowledge of the .NET Framework, C#, JavaScript, AJAX, and MVC.
• Experience in SQL and SQL Database design including Stored Procedures.
• Familiarization with REST API design and development.

Responsibilities

• Manage technical decisions for one or many projects/teams.
• Act as liaison for client-side technical expertise.
• Direct operations related to escalated technical issues.
• Demonstrate interest in improving technical awareness across the business.

Skills

Excellent written and communication skills

.NET Framework

C#

JavaScript

AJAX

MVC

SQL

REST API

NodeJS

Database design

Education

Master’s degree in Information Technology or related field

Tools

SSIS

SSRS

Spring Framework

Job description

The mission of the Office of the State Superintendent of Education (OSSE) is to remove barriers and create pathways for District residents to receive a great education and prepare them for success in college, careers, and life. OSSE plays many roles in the lives of children, teens, and adults seeking an education in the District of Columbia. The agency sets statewide policies, provides resources and support, and exercises accountability for all public education in DC. OSSE also ensures that children and families receive year round access to well balanced meals by providing federal reimbursements, training and nutrition education to program participants.

Job Description

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:

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

Qualifications

Excellent written and communication 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.

Additional Information

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.