Database Administrator

Jobtailor; Phoenix (AZ); On-site; USD 90,000 - 120,000; Full time

Job summary

Jobtailor in Phoenix, AZ is seeking a seasoned SQL Server DBA to administer CJIS-compliant reporting environments for the Police Department's Premier One RMS.

You will design, develop, and maintain SSRS reports, optimize T-SQL, manage permissions, and ensure data quality across large enterprise datasets while collaborating with business stakeholders.

Qualifications

• Must have advanced experience with Microsoft SQL Server.
• Strong experience with T-SQL.
• Strong experience with SQL query optimization.
• Strong experience with stored procedures.
• Strong experience with database permissions administration.
• Proficiency with SSRS, including report design, deployment, and administration.
• Experience with large enterprise datasets.
• Knowledge of RBAC, data governance and data quality.
• Experience with CJIS security standards and IT governance.

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.
• Document database changes, permissions, and reporting solutions.
• Provide advanced database administration, reporting, and technical support for the Police Department's Premier One RMS

Skills

Microsoft SQL Server

T-SQL

SQL query optimization

Stored procedures

Database permissions administration

SSRS

Large enterprise datasets

RBAC

Data governance

Data quality

CJIS security standards

US work authorization

Tools

SSRS

Premier One RMS

Job description

• 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
• Provide advanced database administration, reporting, and technical support for the Police Department's Premier One Records Management System (RMS)

Requirements

• Advanced experience with Microsoft SQL Server
• Strong experience with T-SQL
• Strong experience with SQL query optimization
• Strong experience with stored procedures
• Strong experience with database permissions administration
• Proficiency with SQL Server Reporting Services (SSRS), including report design, deployment, and administration
• Experience working with large, complex enterprise datasets
• Strong analytical and problem-solving skills
• Experience with data governance and data quality
• Experience with role-based access control (RBAC)
• Experience with 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
• Local Arizona/Phoenix 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
• Current location must be listed on the resume
• HireRight background check and drug screening required
• Work involves handling sensitive Police Department data
• Preferred: Experience with Premier One Records Management System (RMS)
• Preferred: Public Safety or Law Enforcement environment experience
• Preferred: Experience supporting enterprise reporting environments
• Preferred: Knowledge of CJIS security standards
• U.S. work authorization status must be provided

Core Competencies

Demonstrates advanced expertise in Microsoft SQL Server, T-SQL, and SQL Server Reporting Services (SSRS) for effective database administration and reporting solutions. Proven ability to ensure data quality, compliance with CJIS security standards, and manage complex enterprise datasets.

Highest-signal resume keywords

• Microsoft SQL Server
• T-SQL
• SQL Query Optimization
• SQL Server Reporting Services (SSRS)
• Database Permissions Administration

ATS Optimization Keywords

Hard Skills

• SQL Query Optimization
• Stored Procedures
• Database Security Best Practices
• Data Governance
• Data Quality
• Role-Based Access Control (RBAC)
• Database Documentation
• Reporting Requirements Gathering
• Troubleshooting Database Performance
• Advanced Database Administration

Soft Skills

• Analytical Skills
• Problem-Solving Skills
• Excellent Communication Skills
• Project Management

Industry Keywords

• CJIS Security Standards
• Public Safety
• Law Enforcement
• Enterprise Reporting Environments

Tools & Technologies

• SQL Server Reporting Services (SSRS)
• Premier One Records Management System (RMS)