Be involved with database and application design, creating complex SQL queries, SSIS jobs and SSRS / PowerBI reports, developing ASP.NET application via using .NET Core, C#, MVC, JSON and jQuery.
Develop and test stored procedures, user defined functions, triggers and other objects that assist in the implementation of business rules/logic.
Thoroughly test all code to ensure that programs are functioning correctly.
Manage security, permissions and access to applications and related services.
Provide day-to-day administration, support and monitoring of applications and related services.
Create IT documents for knowledge base, user guides and other various communications systems.
Following established business, technical and project policies and guidelines aligned with the Commonwealth’s Executive Office of Technology Services and Security (EOTSS) principles and standards to include the following: use of best practices, meeting management, project plans, status reports and dashboards, risk and issue tracking, change requests and resource management.
Qualifications:
Minimum 8 years’ experience with SQL Server, SSIS Packages.
Minimum 8 years’ experience with ASP.NET, .NET Core, C#, MVC, JSON, and jQuery.
Solid knowledge and experience with developing complex, hi-performance data cleansing SSIS Packages.
Expert programming and troubleshooting skills.
Expert performance tuning skills and dynamic SQL skills.
Willingness to jump into other’s code at any time to solve the problem.
Ability to reverse-engineer other’s code and modify it to solve the problem in a better or more efficient way.
Working knowledge of XML and web services.
Experience and understanding with unit testing, release procedures, coding design and documentation protocol.
Ability to communicate with technical and business resources at many levels in a manner that supports progress and success.
Ability to understand, appreciate and adapt to new business cultures and ways of working.
Ability to work independently with minimal supervision.