Database Administrator

S R INTERNATIONAL INC

Phoenix, AZ, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Data Analysis Big Data Databases Data Governance Data Integrity Database Schema Document Management Systems Document-Oriented Databases IT Management Microsoft SQL Server Query Optimization Role-Based Access Control

+8 more

SQL Stored Procedures SQL Databases SQL Server Reporting Services Systems Integration Transact-SQL Data Management Tools for Reporting SQL Server Management Studio (SSMS)

Job description

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

Requirements

Do you have experience in T-SQL?, * 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.

Preferred Skills

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.

Primary Skills Microsoft SQL Server, SQL Server Reporting Services (SSRS), T-SQL, Database Administration, Query Optimization, Stored Pro

Flexible work from home options available.