Advanced Applications Development Analyst(SQL)(Job ID:SA-15-01)

  • Esplanade Way, Tallahassee, FL, USA
  • Full-time

Company Description

Computer Consultants International, Inc. (CCI) is an IT Consulting Firm with more than 18 years experience providing effective, expert-level services in industries such as Construction, Technology, Finance, Healthcare, and Government. CCI focuses on building long-term relationships while completing projects from design to delivery. People are CCI's key component for success. Recruiting utmost-quality individuals for our clients, CCI fields a workforce of individuals who are selected not only because of their technical qualifications but also for their achievements as substantial, contributing human beings. In government work and in the commercial market, high standards of ethics and accountability are critical. Therefore our people are chosen for their integrity and ability to maintain relationships, as well as expertise in their field. To learn more about CCI, visit us online at www.cci-worldwide.com.

Job Description

CCI has a Client who is a Candidate to assist in the enhancement and update of the Uniform Data Reporting (UCR) data management system,  

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.   

 Dimensions  Education:   

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

Experience: Typically has 2 to 5 years of programming/systems analysis experience.   

Complexity: Intermediate professional level role. 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.    

 Requirements 

  • 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;    

Qualifications

  • Bachelor’s Degree in Computer Science, Information Systems or other related field. Or equivalent work experience.   
  • Typically has 2 to 5 years of programming/systems analysis experience.   
  • 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.   
  • 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;    

Additional Information

For immediate consideration, please send your resume to hire(at)cci-worldwide.com with "Advanced Applications Development Analyst(SQL)(Job ID:SA-15-01)"FL as the subject line.