Database Administrator
About The Position
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. The work schedule is hybrid, with 75% onsite and 25% remote after onboarding. This position requires local Arizona candidates only and availability for in-person interviews within one week of the posting close date. The candidate must be able to start within two weeks of receiving an offer. The role involves handling sensitive Police Department data.
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): Report Design, Deployment, Administration
- Experience working with large, complex enterprise datasets
- Strong analytical and problem-solving skills
- Experience with Data Governance
- Experience with 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
Nice To Haves
- 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
Responsibilities
- 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
Benefits
- Flexible work from home options available
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
