SQL Software Developer
Apply NowCompany: DC Office on Aging
Location: Washington, DC 20011
Description:
Company 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:
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.
Qualifications
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.
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.
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:
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.
Qualifications
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.
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.