Press ENTER to skip to the job description.

Senior SQL Developer

  Apply Now  


Job Description
The Cabinet information & Technology Services Department is seeking a contract resource for the role of Senior SQL Developer. The Senior SQL Developer collaborates with and contributes to a development team of senior developers, Quality Assurance Analysts, Business Analysts, and Subject Matter Experts providing value added solutions as requested by the Product Owner. The successful candidate follows guidance from System and Software Architects and reports to the Team Lead.

 KEYWORDS:
C#, .NetCore, Web API, Azure, LINQ, JSON, T-SQL, XML, SSRS, Crystal Reports, Visual Studio 2019/22, REST, SOAP, Service-oriented architectures SOA, SSMSStored Procedure, Function, SSIS, SQL Jobs, Views, Triggers, Tables, Security

ESSENTIAL CHARACTERISTICS OF THE SUCCESSFUL CANDIDATE:
The Senior SQL Developer will be responsible to review and refactor the database objects for the Financials System for the Client Court of Justice. This will include learning the entire schema and providing substantiative performance improvements including wholesale changes, if required and implementing Vendor recommendations, as deemed appropriate. The successful candidate will work in an isolated remediation environment and hand-off improvements to the primary Financials team for review, testing, and integration into the production environment. Must have experience building and/or refactoring enterprise level database schemas and services for equivalent domains (Justice, Medical, Banking). Will l interact with colleagues in a professional manner. Will follow all standards and document 
all technical recommendations/changes.
 
DUTIES OR RESPONSIBILITIES OF THIS CLASSIFICATION:

  • Overall
    • Compliance with KCOJ software development standards
    • Learn entire Financials Database Schema within 30 days
    • Deconstruct complicated SQL objects to their constituent parts
    • Refactor SQL objects of all types to improve stability scalability and performance
    • Rapidly prototype new ideas and concepts
    • Strong attention to detail with superb analytical skills
    • Review existing code identifying opportunities for optimizations
    • Develop new and tests, debugs, troubleshoots existing scripts, views, functions, and stored procedures
    • Independently explore databases/tables to identify best data sources
  • Using DevOps Azure/GitHub;
    • Execute on backlog items as prioritized by the product owner
    • Estimate and report on effort
    • Complete other work items, as assigned
  • Using SSMS, Redgate, and Visual Studio 2019 or higher;
    • Develop high quality SQL software using best practices of the industry
    • Refactor existing software as needed
    • Build unit and integration tests within existing code base
    • Assist with debugging enterprise application issues to resolve problems in test and production environments by reviewing errors and program code.
    • Assist with development and utilization of automated testing.
  • Regular attendance as required.
  • Perform other duties, as assigned.

QUALIFICATIONS:

  • Understands double entry accounting
  • Understands relational model including relational algebra and calculus, integrity and normalization up to 3rd normal form
  • Demonstrated semantic modeling skills
  • Demonstrated appropriate use of database objects
  • Mastery of SQL Transaction Mechanics
  • Mastery of Execution/Explain Plan and its use in optimization
  • Mastery of Table Partitioning
  • Experience with business communication, analytical problem solving and troubleshooting skills
  • Experience working in multi-disciplined team environment with client and vendor interfacing skills. 

MINIMUM REQUIREMENTS:
Education: Bachelor’s degree in Computer Science, Mathematics, or related field
Education Substitute:  7+ yrs. job experience or Associates degree in Computer Science/Information Technology (related field) with 5+ yrs. job-related experience 
SPECIAL REQUIREMENTS: (LICENSES, REGULATIONS, CERTIFICATES, ADVANCED EDUCATION, ETC.)

·        Working knowledge of Microsoft Office Suite (365)

·        Effective communication skills - written and oral

·        Available during off hours and on weekends

·        Optionally conversant with database design by Christopher J Date et al (Nikos Lorentzos, David McGoveran, Fabian Pascal, Lex de Haan)

WORKING CONDITIONS:

  • 08:00 – 17:00 M-F
  • Remote work environment with Teams
  • Expected online during work times
  • Remote work plan option available

  Apply Now