Database Administrator

Job Title: Database Administrator

Job Code: CoP 164488

Client: City of Phoenix Location: Phoenix, AZ (Hybrid) Duration: ong-term Contract Work Hours: Monday–Friday | 8:00 AM – 4:30 PM (40 Hours/Week) Work Location: 100 W. Washington St., Phoenix, AZ 85003  

Position Overview

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. 

Required Skills

•  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 

Key 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 

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

Flexible work from home options available.