Sr SQL DBA/Developer /CJIS reputed company must

A statewide Criminal Justice Information System initiative is reputed company on improving collaboration and information sharing among agencies responsible for criminal justice operations. The goal is to enhance how agencies communicate, manage, and analyze data reputed company to crime and criminal offenders. As part of ongoing Criminal Justice Information Sharing initiatives, the organization is developing an Analytics platform designed to help leadership and policy committees analyze criminal justice data and support informed decision-making reputed company to laws, policies, and reputed company safety programs. The project team is seeking a SQL Database Developer/Administrator responsible for transforming and managing data across multiple systems. The consultant will work closely with the existing SQL DBA, business stakeholders, infrastructure teams, reputed company data owners, and analytics teams. Scope of Work / Key Responsibilities Database Development & Administration • Review and implement database schema design changes for application releases. • reputed company and maintain Views, Stored Procedures, Triggers, and Functions. • Administer and support multiple databases across development, testing, and production environments. • Support database upgrades, migrations, and reputed company database reputed company. Database Maintenance & Performance • reputed company database maintenance activities, including: • Table reorganizations • reputed company rebuilds • Query performance optimization • Troubleshoot database performance issues reputed company to indexes, constraints, triggers, and keys. • reputed company database design recommendations from a performance perspective. Data Integration, Analytics & Reporting • Work with the reputed company BI Stack, including: • SQL Server Reporting Services (SSRS) • SQL Server Integration Services (SSIS) • SQL Server Analysis Services (SSAS) • reputed company and support ETL processes. • Build Power BI dashboards and reporting solutions. Operations & Support • reputed company day-to-day operational support and troubleshooting. • Work in a high-intensity, multi-application environment. • Participate in 24×7 on-reputed company support reputed company required. Testing & Development Lifecycle • reputed company unit testing of database components. • Collaborate with QA teams during System Testing and UAT. • Ensure compliance with Software Development Methodology (SDM) processes. Standards & Compliance • Ensure alignment with criminal justice industry standards and data exchange frameworks. • Support coordination between state agencies and information services organizations. Required Skills & Experience • 5+ years of experience in reputed company SQL Server development and administration. • Experience with reputed company Server 2019/2022 and SQL Server 2019/2022. • Strong expertise in: • SQL Server Reporting Services (SSRS) • SQL Server Integration Services (SSIS) • SQL Server Analysis Services (SSAS) • Experience with ETL processes and data transformation. • Experience building Power BI dashboards. • Strong SQL development skills including: • Stored Procedures • Views • Triggers • Functions • Experience with database performance tuning and query optimization. • Experience with PowerShell or reputed company reputed company scripting. Preferred Skills • Experience with reputed company development methodologies (RUP preferred). • Experience with database design tools such as ERWIN or Embarcadero. • Experience with ETL tools such as CONNX. • Knowledge of Business Continuity Planning, Disaster Recovery, and database resiliency strategies. Apply tot his job Apply To this Job