Systems Engineer III

Job Description

Job Description

 
 
PROJECT DESCRIPTION: DSS has a constant increased need for the provision of full systems life cycle applications development on various computer platforms, including a variety of client eligibility and recertification systems, employment/work engagement services, claims systems, etc., that are critical to the operation and functioning of DSS programs, requiring periodic refinements to maintain the applications at optimum service levels. Having a project portfolio which properly reflects the user’s business needs and DSS’ workload is crucial. Therefore, there is a need for IT consulting resources for the expanding responsibilities at DSS.
 
Tasks & Duties

• Develop system design specification.
• Develops and prepares documents for the general design of solutions that meet system and security requirements, including the selection of alternative approaches.
• Develops specifications for databases, communication systems, hardware, network, security, storage and software configurations.
• Develops structured diagrams for the specifications of databases, communication systems, computer or storage area networks, security or network programs.
• Develops, compiles, maintains and documents configurations of the following: databases, servers, computers, security and network monitor systems, packaged programs, macros, utilities, and communication systems.
• Develop system documentation
• Develop operational and installation procedures for communication systems, hardware, network, security, storage and software.
• Develop guidelines and upgrade techniques of new operational procedures for the support of databases, hardware systems, operating systems software, network systems software, security and client server systems.
• Develop detailed systems operations designs.
• Perform System Design/Development
• Work with ITS staff (e.g., managers, senior programmers, support staff, product manager) to plan program implementation, enhancements, and changes
• Create, test, and maintain programs
• Design reports, audit trails/logs, security mechanisms
• Assist ITS technical support staff when they are unable to resolve a program, database, or IT issue by themselves
• Occasionally contact customers as may be needed to clarify the intent of a new feature or resolve a problem
• Provide general programming assistance to other ITS programmers/projects as may be needed.
• Recommend business process flow improvements and clearly communicate problem/resolution process to project management.
• Develop, improve, implement, and maintain databases, enabling administrators and users to update, retrieve, arrange, or delete data within databases
• See out a project from conception to final product, requiring good organizational skills and attention to detail.
• Provide progress documents to upper management, using change management tools such as Service now and Jira, maintain development in different environments, by serving as a .Net and Oracle Database Expert for a speedy and effective delivery to ITS end users

  Required Skills
A minimum of 6 years of experience with the following skill sets:
·        Writing application software, data analysis, data access
·        Data structures, data manipulation, databases, design, programming, testing and implementation
·        Technical and user documentation, software conversions. Experience in creating Technical Specification Documents, State Diagrams and conducting technical walkthrough with QA team.
·        Exposure to environments include but are not limited to mainframe, mid-range, personal computers, laptops
·        Lead in the design of program specifications and the implementation of software solutions. Extensive experience working under Agile methodologies environment, and experience with enterprise-level software architecture
·        Designing 3 tiered applications
·        .Net Framework including: VB.Net, ASP.NET, Experience with ADO.NET, VB6, Java Script, XML, WEB Service, VBScript, C#, Object oriented concepts and technologies
·        Oracle database Backend processing and extensive experience in relational database development, for creating complex database queries, Constraints, Indexes, Views, Packages, Stored Procedures, Triggers, Cursors and Functions using TOAD, PL/SQL Developer
·        Developing Web Applications using HTML, CSS, JavaScript, jQuery, AJAX, JSON. Expert knowledge using LINQ, and Entity Framework
·        Knowledge of SOA trends, SOA standards including web services, XML, XSLT, SOAP, WSDLs, and WCF
·        Proficient at developing Single Page Application (SPA) with AngularJS controllers, directives, factories, services, routing, DOM manipulation using JavaScript, JQuery, AngularJS, and REST API
·        Developing SSIS packages for extracting, cleaning, transforming, and loading data from different sources like XML, Excel, Text files and databases (Oracle, SQL server)
·        Professional experience as Full Stack (Database/.Net) developer in all the phases of Software Development Life Cycle (SDLC) including User Interaction, Design, Development, Implementation, Testing, Deployment, Customer Support, Maintenance and Enhancements of applications