Job brief

Develop, create, and modify general computer applications software or specialized utility programs.Analyze user needs and develop software solutions.

Requirements

• Analyze user needs and develop software solutions.
• Design software or customize the software for client use with the aim of optimizing operational efficiency.
• May analyze and design databases within an application area, working individually or coordinating database development as part of a team.
• May supervise computer programmers.
• Modify existing software to correct errors, allow it to adapt to new hardware, or improve its performance.
• Analyze user needs and software requirements to determine the feasibility of design within time and cost constraints.
• Confer with systems analysts, engineers, programmers, and others to design systems and to obtain information on project limitations and capabilities, performance requirements, and interfaces.
• Store, retrieve, and manipulate data for analysis of system capabilities and requirements.
• Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcomes and consequences of design.
• Develop and direct software system testing and validation procedures, programming, and documentation.
• Supervise the work of programmers, technologists, and technicians, and other engineering and scientific personnel.
• Determine system performance standards.
• Coordinate software system installation and monitor equipment functioning to ensure specifications are met.
• Consult with customers about software system design and maintenance.
• Analyze information to determine, recommend, and plan computer specifications and layouts, and peripheral equipment modifications.
• Design and develop dynamic UI components, business logic layer, data access layer for the Health-e-Arizonaapplication by ensuring the services and the components are well-defined and modularized, secure, reliable, diagnosable, actively monitored, and reusable with technologies .Net 4.7 & 3.0 Core, ASP.NET, MVC, C#, JBOSS, JavaScriptframework, Entity core Framework, Azure Web Jobs, and functions.
• Develop and design RESTful WebAPIS service components and define service contracts to expose and reuse by states eligibility system and county access program systems.
• Configure security settings, SSLfor several web services exposed to the external network.
• Design low-level design document using appropriate object-oriented design patterns to make the application more robust and write Pseudocode for major components using C#, ReactJS, and angular.
• Lead requirement gathering sessions for HEAPlus batch job module development and enhancement to formulate and define objectives with various research & fact-finding techniques, prototyping, sampling, and observation.
• Operate on MS SQL Database (SQLServer 2012-R2/2016) / Business Intelligence (SSIS/SSRS) & other database development methodologies to resolve performance issues of complex stored procedures to improve the response time.
• Create several SSIS Packages to migrate data from heterogeneous data sources such as flat files, Oracle, Access, Excel into SQL server staging database and create data mappings to load the data from source to destination.
• Extensively use data conversions, lookups, and derived column, conditional split to implement incremental data loading, for data cleaning, to remove unnecessary columns, to eliminate redundant and inconsistent data.
• Develop complex stored procedures to run multiple DML statements from flat files to run incremental updates on tables on the staging database.
• Create indexes to speed up the queries in SQL Server, perform data extraction and migration activities to populate test (non-production) data and customer databases.
• Optimize SQL queries to develop database objects such as triggers, joints, constraints, cursors, indexes, views and created stored procedures to automate sequential updates in fewer transactions.
• Create and maintain ERDs, Databasediagrams, and data dictionaries.
• Lead quality assurance cycle sprints to ensure applications satisfy end-user requirements with standard test process methodology.
• Perform risk analysis by data gathering, representation techniques, and data modeling techniques (ExpectedMonetary Value Analysis (EMV), Monte Carlo Analysis) and develop solutions to mitigate risk.
• Measure and monitor the performance of the applications, server load, and network traffic using GoogleAnalytics and New Relic tools and fix the performance issues.