SQL Developer | Must have Department of Justice experience

Remote • Posted 3 hours ago • Updated 3 hours ago
Contract W2
Contract Corp To Corp
Contract Independent
Remote
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • SSRS
  • SSIS
  • SSAS
  • Microsoft SQL Server 2019/2022
  • Power BI dashboards
  • Views
  • Triggers
  • Stored Procedures
  • Functions
  • Department of Justice
  • DOJ
  • CJIS

Summary

Role: SQL Developer
Location: Remote

Key Responsibilities

  • Design and review database schemas for application releases
  • Perform database maintenance (index rebuilds, table reorganization)
  • Support day-to-day database operations and troubleshooting
  • Optimize database performance and query efficiency
  • Assist with database upgrades and migration strategies
  • Administer multiple SQL Server databases across environments
  • Develop views, stored procedures, triggers, and functions
  • Work with Microsoft BI stack (SSRS, SSIS, SSAS)
  • Develop dashboards and reports using Power BI
  • Support ETL processes and data transformation
  • Participate in unit testing and assist with system/UAT testing
  • Ensure compliance with CJIS architecture standards including JRA, NIEM, NCSC, and GFIPM

Required Skills

  • 5+ years experience with:
    • Microsoft SQL Server 2019/2022 (Development & Administration)
    • SSRS, SSIS, SSAS
    • ETL processes
    • Power BI dashboards
    • Writing Views, Triggers, Stored Procedures, Functions
    • Database performance tuning (indexes, constraints, keys)
    • Windows Server 2019/2022
    • PowerShell or Windows shell scripting

Nice to Have

  • Database design tools such as ERWIN or Embarcadero
  • RUP / structured development methodology
  • CONNX ETL tool
  • Disaster Recovery / Business Continuity Planning

Additional Requirements

  • Ability to work in a 24x7 on-call support environment if required
  • Must pass background investigation
  • Work collaboratively with criminal justice agencies and state partners

--
Asher Williams
Desk: 2o1.497.1o1o X:1o5 | Direct: 551.272.o129
asher (at) pullskill dot com

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 90922281
  • Position Id: 8914001
  • Posted 3 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Remote

Today

Easy Apply

Contract

68

Remote

Today

Easy Apply

Third Party, Contract

Depends on Experience

Remote

Today

Easy Apply

Contract

Depends on Experience

Remote

Today

Easy Apply

Contract, Third Party

60 - 70

Search all similar jobs