System Developer

Role: System Developer

Location: Remote

Responsibilities:

• Develop a system architecture document to illustrate application inter-connectivity.
• Provide support to modify current transaction loading and processing of data and documents in the current environment as need arises.
• Transition current transaction environment from Oracle to SQL Server.
• Modify current and new multi-agency interfaces to support loading data and documents to new staging area environments.
• Migrate current processes to populate data sources with transaction data and documents from new staging areas.
• Conduct interface testing - internally and externally with other agencies as needed.
• Go Live and post-implementation support.
• Develop a system architecture document to illustrate application inter-connectivity.
• Analysis of user requirements documented in a Functional Requirements Document
• Design and creation of data structures and database objects in MS SQL Server environment.
• Design of the new module, interfaces documented in a Design Document
• Construction of forms, reports, interfaces, and processes required for User Interface
• Migration of data to new MS SQL Server environment, as needed.
• Unit and system integration testing
• Go Live and post-implementation support

*

• Design, develop, test, implement and document modifications of existing applications including, but not limited to, Oracle Forms and Reports and MS Access.
• Design, test and implement roles-based application access vs direct grants application access for Oracle applications.
• Develop and implement solutions for identified application security issues.
• Develop, implement, and maintain scripting solutions for various interfaces including, but not limited to, MS Office 365 components and MS Windows.
• Construct and execute mass data update scripts as required.
• Conduct unit and system integration testing as required.
• Provide Go Live and post-implementation support.
• Provide recommendations and solutions for day-to-day user adhoc requests.

Qualifications:

• Systems Development Methodology:

• Knowledge of System Architecture modeling.
• Skills in data modeling and process modeling.
• Knowledge of requirements analysis and system definition reports and documentation.
• Skills in providing end user training.
• Skills in project planning.
• Skills writing user and system manuals.

• Web Technologies:

• XML (Extensible Markup Language)
• JSON (JavaScript Object Notation)
• Web Services (SOAP, SoapUI, REST API)
• Dynamic web pages using CSS, Ajax and HTML5
• .Net Applications using C#
• Java

• Databases, Operating Systems, Application Servers:

• MS SQL Server
• PostgreSQL
• Oracle
• Linux
• Windows

• Development Tools, APIs, and Scripting:

• .Net Applications using C#
• VB Script
• Java
• Data modeling and data management using ERWin and TOAD
• SQL Server Integration Services
• MS Access
• Oracle 12c Developer Tool Suite
• PL/SQL

Job Type: Full-time

Education:

• Bachelor's (Preferred)

Experience:

• Systems Development Methodology: 5 years (Preferred)
• Web Technologies: 5 years (Preferred)
• Databases, Operating Systems, Application Servers: 5 years (Preferred)
• Development Tools, APIs, and Scripting: 5 years (Preferred)

Work Location: Remote