Database Administrator

The City of Phoenix is seeking an experienced Database Administrator to provide advanced database administration, reporting, and technical support for the Police Department’s Premier One Records Management System (RMS). The ideal candidate will have strong expertise in Microsoft SQL Server, T-SQL, SSRS, database security, query optimization, and reporting in a large enterprise environment. Work Schedule

• Hybrid: 75% Onsite / 25% Remote (after onboarding)
• Local Arizona 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., * 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

Important Notes

• Local Phoenix, AZ candidates only
• Current location must be listed on the resume
• HireRight background check and drug screening required
• Work involves handling sensitive Police Department data

Primary Skills Microsoft SQL Server, T-SQL, SQL Server Reporting Services (SSRS), SQL Query Optimization, Stored Procedures, Database Administration, Database Security, Role-Based Access Control (RBAC), Data Governance, Data Quality, SQL Permissions, Reporting, Data Integrity, Premier One RMS, CJIS Compliance, SQL Performance Tuning, Enterprise Reporting, Database Management

• Advanced experience with Microsoft SQL Server
• Strong experience with:
• T-SQL
• SQL Query Optimization
• Stored Procedures
• Database Permissions Administration
• Proficiency with SQL Server Reporting Services (SSRS):
• Report Design
• Deployment
• Administration
• Experience working with large, complex enterprise datasets
• Strong analytical and problem-solving skills
• Experience with:
• Data Governance
• Data Quality
• Role-Based Access Control (RBAC)
• 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

Preferred Skills

• Experience with Premier One Records Management System (RMS)
• Public Safety or Law Enforcement environment experience
• Experience supporting enterprise reporting environments
• Knowledge of CJIS security standards