Client - DCAS

This position is fully on-site with location at 1 center street, NY - 10007

Project Name: EC3 (Energy Cost Control and Conservation) – Web Portal

Job Title: Sr. NET Engineer – Tech Lead

Description: The EC3 web portal provides information about monthly energy cost and usage for city agencies, facilities and utility accounts and meters to agency energy managers, energy team members, and ELOs (Energy Liaison Officers). The data is received from utility companies electronically and is then processed by DCAS’ Energy Management team on behalf of all City agencies.

EC3 also handles processing and invoicing of utility billing and the generation of the citywide Heath, Light and Power Budget. Citywide users can run canned reports as well as custom reports, while DEM team can, in addition, run reports from the EC3 Data Warehouse

RESPONSIBILITIES

• Conduct assessment and planning for the upgrade of EC3, EC3 Budget, and EC3 Invoice systems to .NET 8 and Metronic 8.
• Develop migration plan for moving EC3 to Azure cloud, including structural changes required for the application.
• Identify and document dependencies and integration points for each system.
• Set up development and testing environments for the upgrade and migration process.
• Upgrade agency facing screens on EC3 to .NET 8 and Metronic 8 according to the migration plan.
• Implement structural changes necessary for migrating EC3 to Azure cloud
• Upgrade admin facing screens on EC3 to .NET 8 and Metronic 8
• Conduct Security Accreditation with OTI and Load Testing
• Migrate data and configurations from cityNet to Azure cloud environment.
• Conduct thorough testing to ensure compatibility and functionality post-upgrade and migration
• Identify and evaluate robust reporting tools to replace post-publishing crystal reports of EC3.
• Implement selected reporting tools and migrate existing reports to the new platform.
• Conduct user acceptance testing (UAT) for reporting enhancements and automation solution.

MANDATORY SKILLS

• 12 years of experience developing Microsoft ASP.NET applications using MVC 5 or higher
• 12 years of experience in SQL Server (2016, 2019, 2022)
• 7 years of experience with Microsoft Entity Framework or comparable ORM
• Proficiency with .NET 8 and Metronic 8
• 5 years of experience with Vue or Angular or React, HTML5, and CSS3
• Experience with Azure cloud
• Experience in server and application troubleshooting
• Experience with using WebAPI or WCF
• Experience in designing and developing robust database driven applications with advanced reporting functionalities.
• Experience in design and implementation of user interfaces
• Experience with using Azure DevOps
• Experience setting up and deploying CI/CD pipelines.
• Experience with Agile and Scrum methodologies
• Experience in data integration/ETL, specifically SSIS and Azure Data Factory
• Experience working with REST web services and designing and developing Json based data exchanges.

HIGHLY DESIRABLE SKILLS

• Proficiency in implementing comprehensive unit tests and integration tests for application code.
• Experience in automated testing frameworks such as NUnit, MSTest, or xUnit.
• Demonstrated ability to deploy applications securely on Azure cloud infrastructure, adhering to best practices for network security, data encryption, and access control.
• Familiarity with Azure Security Center and Azure Key Vault for managing and safeguarding sensitive data and credentials.
• Experience in conducting vulnerability assessments and implementing security patches and updates in a timely manner.
• Knowledge of secure coding practices and techniques to mitigate common security threats such as SQL injection, cross-site scripting (XSS), and cross-site request forgery (CSRF).
• Proficiency in implementing role-based access control (RBAC) and authentication mechanisms using Azure Active Directory (AAD) or similar identity management solutions.
• Experience in designing and implementing disaster recovery and failover mechanisms for high availability of applications and databases.
• Ability to configure and manage continuous integration/continuous deployment (CI/CD) pipelines securely, ensuring compliance with regulatory requirements such as GDPR and HIPAA.