Database Administrator

S R INTERNATIONAL INC
Phoenix, United States of America
29 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Remote
Phoenix, United States of America

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
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
Systems Integration
T-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.

Apply for this position