SQL server developer

Scope of Work

• Perform schema design review and changes for application releases.
• Perform database maintenance such as table re-organizations, index rebuilds.
• Provide support for day-to-day operations and troubleshooting.
• Ability to work in a 24X7 on-call environment when needed.
• Provide design advice from database performance perspective.
• Assist in application database upgrade planning, development of database migration design strategies, and other assorted database projects for CJIS applications.
• Administer multiple databases across multiple applications, test and production environments.
• Ability to work with Microsoft BI Stack - Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services SSIS, Microsoft SQL Server Analysis Services (SSAS).
• Knowledgeable on all facets of Software Development Methodology (SDM) and assisting the CJIS Governing Board team on SDM compliance for CJIS activities.
• Foster and ensure cooperation and coordination among the various justice partners and Information Services (IS) organizations within the state and local agencies.
• Ability to perform Unit Testing as a developer and work with the Test team to help with System and UAT testing.
• Ensure compliance with Justice Reference Architecture (JRA), National Information Exchange Model (NIEM), National Center of Courts (NCSC) and other criminal justice industry standards in all areas of the CJIS environment, and Global Federated Identity and Privilege Management (GFIPM).

Required Skills/Experience

• Solid background with Microsoft SQL Server Database development skills.
• The ability to foster and ensure cooperation and coordination among the various CJIS partners.
• Five or more years of experience in the following:
• Windows Server 2019/2022 with SQL Server 2019/2022 – Development/Administration
• Microsoft SQL Server Reporting Services (SSRS)
• Microsoft SQL Server Integration Services SSIS
• Microsoft SQL Server Analysis Services (SSAS) and Extraction Transformation and Loading (ETL) knowledge.
• Dashboard development using Power BI
• Developing and analyzing Views, Triggers, Stored Procedures, and functions using database languages
• Analyzing performance issues (indexes, constraints, keys, triggers, etc.)
• Shell scripting in languages such as Windows shell or PowerShell
• Knowledge of the following is a plus:
• Use of structured methodology (RUP experience a plus) to produce design artifacts
• Use of design tools such as ERWIN, and Embarcadero background in logical and physical database design
• ETL tool - CONNX

State Resources and Oversight

• Workstation and supervision by CJIS Executive Director
• Security/Privacy Considerations: Pass background investigation, sign confidentiality statements

General/Miscellaneous

• All work product property of the CJIS Governing Board.
• Travel not included.