Net Developer with Strong SQL

PRINCIPAL DUTIES & RESPONSIBILITIES:

Sr. Programmer Systems Analyst will perform all the activities that support the development and maintenance of new applications and;

• Ability to extract manufacturing PLC data from SQL databases (SQL stored procedures) and display data on management frontend webbased dashboards or business intelligence/analytic tools (such as PowerBI).
• Code programs create code libraries and run tests to determine software defects.
• Develop and maintain inhouse developed applications.
• Write APIs between existing and new applications both onprem and SaaS based.
• Troubleshoot technical issues and identify modifications needed in existing applications
  to meet changing user requirements.
• Work as a Project Manager to evaluate business needs create a plan on how best to meet
  those needs and communicate a time frame for correction of issues and/or
  implementation of new processes.
• Troubleshoot technical issues and identify modifications needed in existing applications
  to meet changing user requirements.
• Arranges project requirements in programming sequence by analyzing requirements preparing a workflow chart and diagram using knowledge of computer capabilities subject matter programming language and logic.
• Enhance existing custom application performance by optimizing the SQL statements/procedures within the database which the application is built on.
• Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies.
• Identifies develops and maintains the procedures that aid in system recovery in case of disaster.
• Works with IS Operations to ensure that systems are transferred to a production status once the new system has been implemented or an older system has been upgraded.
• Serve as back up to System Analyst and supports production operations by resolving incidents within their SLA.
• Performs other functions as assigned.
• Maintains computer systems and programming guidelines by writing and updating policies and procedures.

• In accordance with the NIST CSF and Hallmark Standards ensure adherence to policies and processes to remain in compliance for maintenance security continuous monitoring and recovery areas including Asset Management Change Management Incident Management Problem Management Vulnerability & Patch Management Data Security Disaster Recovery and Business Continuity.

JOB SPECIFICATIONS:

• Bachelors degree in Computer Science from an accredited college or university program with 8 years manufacturing system experience in large systems design and implementation using relational database technology advanced programming tools as well as experience in working with application users and technical staff in a team environment. Experience in developing Client/Server and WebBased applications.

OR

• Associates degree in Computer Science with 12 years manufacturing system experience in large systems design and implementation using relational database technology advanced programming tools as well as experience in working with application users and technical staff in a team environment. Experience in developing Client/Server and WebBased applications.
• Strong knowledge of SQL. With the ability to write new and troubleshoot existing stored procedures.
• Ability to successfully develop in HTML CSS Javascript .NET and frontend business intelligent/analytic tools.
• Ability to develop APIs using open restAPI scripting.
• Strong knowledge of webbased architectures relational databases database architecture and data loading and extraction practices.
• Strong organizational skills the ability to perform under pressure and manage multiple priorities with competing demands for resources.
• Strong analytical data processing and problemsolving skills.
• Proficiency in process formulation and improvement.
• Familiar with a variety of the IS fields best practices concepts and procedures.
• Excellent interpersonal and communication skills (written verbal and presentation).
• Knowledge of applications related to the manufacturing environment (Rockwell Johnson Controls Allen Bradley etc. a plus).
• Some travel maybe required.