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.
  

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, ANSI-SQL, PL-SQL
  
• 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 2010, 2012 & 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, ANSI-SQL, PL-SQL
  
• 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 2010, 2012 & 2015
  

Skills and Knowledge:

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

• Programming Languages: C#, ANSI-SQL, PL-SQL, Visual Basic .NET, VB script
  
• Databases: SQL Server 2012 - 2019, Oracle 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 2010, 2012 & 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: N-Tier Client-Server and Internet Application Architectures (.NET), Component-Based 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 2010-2013
  

• 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 decision-making skills; organizational, creativity and perseverance skills
  
• Experience with relational database technologies
  
• Knowledge and experience in the implementation of a mechanism for document generation and field-population 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#, ANSI-SQL PL SQL, Visual Basic .NET
  
• Architecture: N-Tier Client-Server and Internet Application Architectures (.NET), Component-Based 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 Transact-SQL Write or change, maintain, unit & system test and supporting ETL's
  

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. Model-View-Controller (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, end-to-end)
  
• 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 drill-down and charting
  

Analytical and Communications Skills:

• Excellent analytical, problem-solving and decision-making skills
  
• Strong verbal and written communication skills
  
• Strong interpersonal skills
  
• A team player with a track record for meeting deadlines