Solutions Architect
Solutions ArchitectOur client is seeking a Solution Architect (database application developer) to replace and modernize the existing database front end, which currently utilizes SQL with a Microsoft Access front end. The objective of this project is to enhance data collection, dissemination, and security-related reporting capabilities while discontinuing the use of Microsoft Access as the front end. Scope of ServicesThe ideal candidate must be able to contribute immediately in the following areas:
Needs Assessment:
Conduct a comprehensive assessment of the existing database system and identify the specific requirements, functionalities, and features needed to modernize and improve it. Design and Development:
Design and develop a user-friendly, web-based database application with a responsive and intuitive front end to replace Microsoft Access. The application should include modules for prisoners' information, prisoner movement, prisoner transportation, security threats, incident reporting, PREA notifications, and security-related reporting. Data Migration:
Migrate all existing data from the current SQL database and Microsoft Access to the new database application without data loss or corruption. Security:
Implement robust security measures to ensure data privacy, access control, and compliance with relevant regulations and standards. User Training:
Provide training to JMS personnel on how to use the new database application effectively. Documentation:
Create comprehensive documentation that includes system architecture, data flow diagrams, user manuals, and technical guides for system administrators. Testing:
Assist JMS in performing rigorous testing, including unit testing, integration testing, and user acceptance testing to ensure the application's reliability and performance. Maintenance and Support:
Minimally, provide JMS training on how to provide on-going maintenance and support services including bug fixes, updates, and enhancements. Minimum QualificationsIn addition to the standard skills and qualifications for the job class, the ideal candidate shall possess the following
Experience:
General
Experience:
Minimum ten (10) years of experience in design, development, unit testing, and solving complex engineering problems. Technical Competencies:
.NET Framework (4.6.2 and up) .NET 6 and above .NET MVC 5 Entity Framework 6 and Entity Framework CORE .NET WEB API Razor view and/or Blazer SQL Server (2016 and up) SSIS & SSRS IIS (8.5 and up) Azure Dev Ops and Azure Identity will be a plus SQL Server Performance Skills Optimize SQL queries (Query Execution Plans . etc.,) Simplify Index analysis o Resolve SQL Server deadlocks Identify the root cause of SQL Server blockings Bootstrap and JQuery Messaging APIs Understand and able to implement design patterns (Repository Pattern . etc.) For more information please contact Vijay Karney at or Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area. Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects. Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position. Recommended Skills Api Acceptance Testing Access Controls Bootstrap (Front End Framework) Data Collection Data Loss Apply to this job. Think you're the perfect candidate? Apply on company site $('.external-apply-email-saved').on('click', function (event) window.ExternalApply = window.open('/interstitial?jobdid=j3v1vj6j909x0nddlh1', 'ExternalApply-j3v1vj6j909x0nddlh1'); ); $(document).ready( function() $(#ads-desktop-placeholder).html(
n
n
n Estimated Salary: $20 to $28 per hour based on qualifications.
Needs Assessment:
Conduct a comprehensive assessment of the existing database system and identify the specific requirements, functionalities, and features needed to modernize and improve it. Design and Development:
Design and develop a user-friendly, web-based database application with a responsive and intuitive front end to replace Microsoft Access. The application should include modules for prisoners' information, prisoner movement, prisoner transportation, security threats, incident reporting, PREA notifications, and security-related reporting. Data Migration:
Migrate all existing data from the current SQL database and Microsoft Access to the new database application without data loss or corruption. Security:
Implement robust security measures to ensure data privacy, access control, and compliance with relevant regulations and standards. User Training:
Provide training to JMS personnel on how to use the new database application effectively. Documentation:
Create comprehensive documentation that includes system architecture, data flow diagrams, user manuals, and technical guides for system administrators. Testing:
Assist JMS in performing rigorous testing, including unit testing, integration testing, and user acceptance testing to ensure the application's reliability and performance. Maintenance and Support:
Minimally, provide JMS training on how to provide on-going maintenance and support services including bug fixes, updates, and enhancements. Minimum QualificationsIn addition to the standard skills and qualifications for the job class, the ideal candidate shall possess the following
Experience:
General
Experience:
Minimum ten (10) years of experience in design, development, unit testing, and solving complex engineering problems. Technical Competencies:
.NET Framework (4.6.2 and up) .NET 6 and above .NET MVC 5 Entity Framework 6 and Entity Framework CORE .NET WEB API Razor view and/or Blazer SQL Server (2016 and up) SSIS & SSRS IIS (8.5 and up) Azure Dev Ops and Azure Identity will be a plus SQL Server Performance Skills Optimize SQL queries (Query Execution Plans . etc.,) Simplify Index analysis o Resolve SQL Server deadlocks Identify the root cause of SQL Server blockings Bootstrap and JQuery Messaging APIs Understand and able to implement design patterns (Repository Pattern . etc.) For more information please contact Vijay Karney at or Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area. Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects. Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position. Recommended Skills Api Acceptance Testing Access Controls Bootstrap (Front End Framework) Data Collection Data Loss Apply to this job. Think you're the perfect candidate? Apply on company site $('.external-apply-email-saved').on('click', function (event) window.ExternalApply = window.open('/interstitial?jobdid=j3v1vj6j909x0nddlh1', 'ExternalApply-j3v1vj6j909x0nddlh1'); ); $(document).ready( function() $(#ads-desktop-placeholder).html(
n
n
n Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
