Database Administrators OracleSQL ServerTSQLSSRS

S R INTERNATIONAL INC; Phoenix (AZ); Hybrid; USD 110,000 - 140,000; Full time

Job summary

City of Phoenix is seeking a Database Administrator (Oracle, SQL Server) for a hybrid/local role with 75% on-site and 25% remote work. The position focuses on SQL Server permissions, query optimization, and SSRS report development for police data reporting.

Responsibilities include collaborating with multiple stakeholders, ensuring data security per CJIS standards, and maintaining documentation. Local Arizona residency is required for consideration.

Qualifications

• Advanced Microsoft SQL Server experience including T-SQL and optimization.
• Proficiency in SSRS report design, deployment and management.
• Experience with large public safety or enterprise data sets preferred.

Responsibilities

• Administer SQL Server permissions for SSRS folders and reports.
• Develop, optimize, and maintain SQL queries and procedures.
• Design, build, test, and deploy SSRS reports for multiple units.
• Collaborate with vendors and IT staff to gather reporting requirements.
• Troubleshoot SQL queries, reports, and data integrity issues.
• Ensure data handling aligns with security standards and CJIS requirements.
• Document changes and data workflows for governance.
• Support data quality improvements and system integration.

Skills

SQL Server

T-SQL

SSRS

Data governance

Analytical skills

Communication

RBAC security

CJIS compliance knowledge

Education

Bachelor's degree in Computer Science or related field

Tools

SSMS

SSRS

Premier One RMS

Job description

THIS POSITION IS OPEN FOR ONLY CURRENT ARIZONA RESIDENTS.

ONLY W2 (NO C2C)

Job Title: Database Administrators (Oracle, SQL Server)

Job ID: 164488 - Hybrid/Local

Client: City of Phoenix

Closing Date & Time: 8/17/2026@ 4 PM

100% Hybrid (75% on-site, 25% remote to be discussed after onboarding)

Project Description:

Provides 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 permissions administration, query development and optimization, and the creation of SSRS reports. The role requires strong coordination between the external vendor, internal IT Bureau staff, and various Police Department bureaus that depend on accurate, timely data reporting.

Key Responsibilities:

• Administer and manage SQL Server database permissions required for SSRS folder and report access.
• Develop, optimize, and maintain SQL queries, stored procedures, and database objects to support operational and analytical reporting needs.
• Design, build, test, and deploy SSRS reports for multiple Police Department bureaus, ensuring accuracy, security, and performance.
• Collaborate with stakeholders to gather reporting requirements, validate data outputs, and refine deliverables based on operational needs.
• Troubleshoot errors related to SQL queries, report execution, dataset performance, and data integrity.
• Ensure all data handling aligns with departmental security standards, CJIS requirements, and established IT governance processes.
• Document database changes, data workflows, permissions assignments, and report specifications.
• Support ongoing improvements in data quality, reporting efficiency, and system integration.

Required Skills & Qualifications:

• Advanced experience with Microsoft SQL Server, including T-SQL, permissions administration, and query optimization.
• Proficiency in SQL Server Reporting Services (SSRS) report design, deployment, and management.
• Experience working with large, complex datasets in a public safety or enterprise environment (preferred but not required).
• Strong analytical and problem-solving skills with attention to accuracy and performance.
• Effective communication skills for interacting with vendors, technical staff, and operational personnel.
• Ability to manage multiple reporting requests and project tasks with minimal supervision.
• Understanding of data governance, security best practices, and role-based access control.
• Experience with Premier One RMS (preferred but not required).

Work Environment: This position supports a multi-bureau Police Department environment and requires interaction with technical and non-technical users. Work may involve sensitive or confidential data requiring strict adherence to security protocols.