Database Administrator

S R International•Phoenix, AZ

7d•Hybrid

About The Position

The City of Phoenix is seeking an experienced Database Administrator to provide advanced technical support, data management, and reporting services for the Police Department’s Premier One Records Management System (RMS). This position focuses on SQL Server administration, permissions management, query development and optimization, SSRS report development, and data governance while supporting critical public safety operations.

Requirements

Advanced experience with Microsoft SQL Server.
Strong T-SQL development experience.
SQL permissions administration and security management.
Query tuning and optimization.
SQL Server Reporting Services (SSRS) report development and deployment.
Database administration and maintenance.
Stored Procedures, Views, and Database Objects.
Data Governance and Data Integrity.
Role-Based Access Control (RBAC).
Reporting and Analytics.
Strong problem-solving and troubleshooting skills.
Excellent communication and stakeholder management skills.
Ability to manage multiple priorities with minimal supervision.

Nice To Haves

Experience working with large, complex datasets in public safety or enterprise environments.
Experience with Premier One RMS.
Systems Integration experience.
Data Quality Management.
Records Management Systems experience.
Knowledge of CJIS compliance and security requirements.

Responsibilities

Administer and manage SQL Server database permissions and security access.
Develop, optimize, and maintain SQL queries, stored procedures, and database objects.
Design, build, test, deploy, and maintain SSRS reports.
Collaborate with business users and stakeholders to gather reporting requirements.
Troubleshoot SQL queries, report execution issues, performance bottlenecks, and data integrity concerns.
Ensure compliance with CJIS requirements, security policies, and IT governance standards.
Document database changes, workflows, permissions, and reporting specifications.
Support data quality initiatives, reporting enhancements, and system integrations.
Coordinate with vendors, IT staff, and Police Department bureaus to deliver reporting solutions.