Database Administrator

Administer SQL Server permissions and security for SSRS reports Develop, optimize, and maintain SQL queries, stored procedures, and database objects Design, develop, deploy, and maintain SSRS reports Gather reporting requirements and validate data accuracy Troubleshoot SQL, reporting, and database performance issues Ensure compliance with CJIS security requirements and IT governance standards Document database changes, permissions, and reporting solutions Improve reporting efficiency, data quality, and system integrations Provide advanced database administration, reporting, and technical support for the Police Department's Premier One Records Management System (RMS) Requirements Advanced experience with Microsoft SQL Server Strong experience with

T-SQL

Strong experience with SQL query optimization Strong experience with stored procedures Strong experience with database permissions administration Proficiency with SQL Server Reporting Services (SSRS), including report design, deployment, and administration Experience working with large, complex enterprise datasets Strong analytical and problem-solving skills Experience with data governance and data quality Experience with role-based access control (RBAC) Experience with database security best practices Experience documenting database changes, workflows, and report specifications Excellent communication skills with technical and business stakeholders Ability to manage multiple projects with minimal supervision Local Arizona/Phoenix candidates only Must be available for in-person interviews within one week of the posting close date Must be able to start within two weeks of receiving an offer Current location must be listed on the resume HireRight background check and drug screening required Work involves handling sensitive Police Department data Preferred: Experience with Premier One Records Management System (RMS) Preferred: Public Safety or Law Enforcement environment experience Preferred: Experience supporting enterprise reporting environments Preferred: Knowledge of CJIS security standards U.S. work authorization status must be provided Core Competencies Demonstrates advanced expertise in Microsoft SQL Server, T-SQL, and SQL Server Reporting Services (SSRS) for effective database administration and reporting solutions. Proven ability to ensure data quality, compliance with CJIS security standards, and manage complex enterprise datasets. Highest-signal resume keywords Microsoft SQL Server T-SQL SQL Query Optimization SQL Server Reporting Services (SSRS) Database Permissions Administration ATS Optimization Keywords Hard Skills SQL Query Optimization Stored Procedures Database Security Best Practices Data Governance Data Quality Role-Based Access Control (RBAC) Database Documentation Reporting Requirements Gathering Troubleshooting Database Performance Advanced Database Administration Soft Skills Analytical Skills Problem-Solving Skills Excellent Communication Skills Project Management Industry Keywords CJIS Security Standards Public Safety Law Enforcement Enterprise Reporting Environments Tools & Technologies SQL Server Reporting Services (SSRS) Premier One Records Management System (RMS) #J-18808-Ljbffr Jobtailor