RQ06700 - Software Developer - Senior

Scope:

• The Office of the Public Guardian and Trustee (OPGT) requires a Software Developer L3 with 5 years of application development and support experience with Microsoft .NET framework C# VB.NET Oracle SQL Server Access to work on the Case Management System (PGTed) Enterprise Reporting System and other applications.
  
• The primary objective of this project is to assist in the support and enhancements to the functionality of the OPGT s Case Management Systems.
  

Deliverables:

• Provide support to production environments including the case management system (PGTED) and data warehouse.
  
• Develop support and maintain ETL (Extract Transform and Load) processes.
  
• Support and maintain the batch programs for over 80 data interfaces.
  
• Document all modifications and enhancements made following existing standards including development of detailed programming specifications user interface designs prototypes writing and/or generating code.
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

A minimum of 5 years knowledge of experience with and proven skills:

• Programming Languages: Visual Basic .NET C# VB script ANSISQL PLSQL
  
• Developing and supporting ETL s (extract load transform)
  
• Creating report using SQL Reporting Services
  
• Developing and supporting applications using Windows Forms C# and PL/SQL using Visual Studio& 2015
  

Skill Set Requirements:

Mandatory Requirements:

A minimum of 5 years knowledge of experience with and proven skills:

• Programming Languages: Visual Basic .NET C# VB script ANSISQL PLSQL
  
• Developing and supporting ETL s (extract load transform)
  
• Creating report using SQL Reporting Services
  
• Developing and supporting applications using Windows Forms C# and PL/SQL using Visual Studio& 2015
  

Skills and Knowledge:

• Knowledge of experience with and proven skills with the following:
  

• Programming Languages: C# ANSISQL PLSQL Visual Basic .NET VB script
  
• Databases: SQL ServerOracle 11g & 12
  
• Operating Systems: Windows 10 and later Windows Server 2012 and later
  

• Experience with and proven skills (within the last 5 years) in developing and supporting ETL s
  
• Experience in creating report using SQL Reporting Services
  
• Experience with and proven skills in developing and supporting applications using Windows Forms C# and PL/SQL using Visual Studio& 2015
  
• Experience of the following development tools:
  

• Team Foundations Server (TFS) for source code management reporting requirements management
  
• Project management (Scrum development model) automated builds testing and release management)
  
• Architecture: NTier ClientServer and Internet Application Architectures (.NET) ComponentBased Design (COM) Architectural Design Patterns Systems Integration
  
• Toad for Oracle SQL Server Management Studio & SQL Server Reporting Services
  
• System Design: Object Oriented Analysis Design and Programming UML Relational Database Design User Interface Design Network / Environment Design.
  
• Other Tools: IIS ADO XML / XSL Web Services SOAP Visio SharePoint foundation Services
  

• A team player with a track record for meeting strict deadlines
  
• Knowledge and understanding of business modeling and use case modeling
  
• Analytical problem solving and decisionmaking skills; organizational creativity and perseverance skills
  
• Experience with relational database technologies
  
• Knowledge and experience in the implementation of a mechanism for document generation and fieldpopulation from disparate data sources
  
• Excellent verbal and written communication skills
  
• Highly developed interpersonal skills
  

Criteria:

Solution Development:

Demonstrated experience with:

• Programming Languages: VB script C# ANSISQL PL SQL Visual Basic .NET
  
• Architecture: NTier ClientServer and Internet Application Architectures (.NET) ComponentBased Design (COM) Architectural Design Patterns Systems Integration
  
• System Design: Object Oriented Analysis Design and Programming UML Relational Database Design User Interface Design Network / Environment Design
  
• Developing scripts and stored procedures in PL/SQL and TransactSQL Write or change maintain unit & system test and supporting ETLs
  

Technical Skills:

• 5 years of professional experience in software development specifically with C# .NET
  
• 5 years of experience leading others technically including providing coaching and mentoring as well as ensuring high code quality and adherence to standards
  
• 5 years of experience including ASP.NET framework SQL Server and design/architectural patterns (e.g. ModelViewController (MVC))
  
• Ability to fully support all phases of the software development lifecycle (SDLC)
  
• Ability to review requirements translate these requirements into a design implement and fully test this design; testing experience should include all aspects of testing (unit functional integration endtoend)
  
• Production implementation and support
  

SQL Server Reporting:

• 5 years of experience in writing or changing maintaining and supporting reports using SQL Server Reporting Services.
  
• SQL Server Reporting Services deployment and portal customization; complex report design and implementation including drilldown and charting
  

Analytical and Communications Skills:

• Excellent analytical problemsolving and decisionmaking skills
  
• Strong verbal and written communication skills
  
• Strong interpersonal skills
  
• A team player with a track record for meeting deadlines