Applications Development Analyst
vTech Solution
Florida, USA
7h ago

Background :

The Office of the State Courts Administrator (OSCA) Court Services unit requires services to assist in the enhancement and update of the Uniform Case Reporting (UCR) System including expansions to existing data capture, parsing, and database processes.

Work will focus on enhancements and updates to UCR subsystems but may include work on other Judicial Data Management (JDMS) data systems as they interface with the UCR system.

The essential function within the organization will be to write T-SQL code to implement existing data processing designs and will build on and extend previous development work.

Requirement :

  • In depth knowledge and experience in Microsoft SQL Server 2012 database and the Transact-SQL programming language.
  • Experienced in the use of Git Source Control version 2.17.0 or later.
  • Experience in the seamless integration of newly developed script processes with existing processes and applications.
  • Troubleshoots and corrects network connectivity issues; ensures secure network access; provides support and training as required and mentors staff on networking principles and operations;
  • provides consultation to court technology officers in local area network design, TCP / IP traffic flow control and security.

    Knowledge, skills, abilities and experience supporting systems software maintenance and system software operations with the following :

  • Advanced knowledge of Microsoft database application development in the SQL
  • Server Management Studio development environment;
  • Advanced knowledge of Microsoft Transact-SQL procedural language scripting;
  • Advanced knowledge of stored procedures and functions using T-SQL involving both scalar and table valued parameters;
  • Advanced knowledge of Common Tables Expressions;
  • Advanced knowledge of complex relational database concepts, including proper use of both normalized and de-normalized data models;
  • Advanced knowledge of exception handling in T-SQL;
  • Knowledge of parsing and generating XML data types;
  • Advanced knowledge of Git version control process and workflow;
  • Familiarity with clean coding practices such as literate programming;
  • General Characteristics :

    Works closely with customers, business analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions.

    These solutions must be aligned with business and IT strategies and comply with the organization’s architectural standards.

    Involved in the full systems life cycle and is responsible for designing, coding, testing, implementing, maintaining and supporting applications software that is delivered on time and within budget.

    Makes recommendations towards the development of new code or reuse of existing code. Responsibilities may also include participation in component and data architecture design, performance monitoring, product evaluation and buy vs.

    build recommendations. Has experience in systems analysis, design and a solid understanding of development, quality assurance and integration methodologies.

    Education :

    Bachelor’s Degree in Computer Science, Information Systems or other related field. Or equivalent work experience.

    Experience : Typically has 7 to 10 years of programming / systems analysis experience.

    Complexity : Develops solutions requiring analysis and research. Works on small to large, complex projects that require increased skill in multiple technical environments and possesses knowledge in a specific business area.

    Works on one or more projects as a project team member or occasionally as a project lead. May coach more junior technical staff.

    Add to favorites
    Remove from favorites
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form