SQL DBA (Database Administrator)

*CRITICAL SKILLS:*

* Install configure and maintain SQL Server Clusters and PowerBI Report Server.


* Monitor and optimize SQL performance.


* Develop complex data extracts, applications, reports, dashboards, and ad-hoc queries by using T- SQL.


* Research, troubleshoot, and resolve data issues.


* Work within the project team to assist with system analysis and application design.


* Work closely with Business Analysts and customers to refine requirements, and ensure data quality.


* Collaborate on the definition, development, and maintenance of standards and processes.


* Must possess expertise with T-SQL and development of stored procedures.


* Report writing experience, with SSRS and PowerBI.


* Drive continuous improvement and automation in BI solutions and processes.


* Work effectively with System Administrators, Project Manager(s), Developers,

Customers and Management.


* Participate in a team development environment using JIRA.


* Must possess excellent written and verbal communication skills

*DESIRABLE SKILLS:*


* Degree in Computer Science, business or related discipline.


* Knowledge of data integration, e.g. extract, transform, and load (ETL) process development/support.


* Able to develop and troubleshoot SSRS reports and PowerBI dashboards; requires good analytical skills.


* Experience with data access performance tuning, and database performance optimization.


* Application Development Lifecycle knowledge and experience.


* Data transport protocols, e.g. SFTP, XML, and JDXDML.


* Experience with Case Management data and/or Justice System data.


* Documentation of system support information.


* Basic understanding of networking principles.


* Ability to analyze system resource usage and constraints.


* Strong communication skills; ability to interact at all levels including management.


* Works independently and follows through on assignments.

OTHER IMPORTANT INFORMATION:*


* A background check is required


* Telecommuting is not offered


* Work location is: 9750 Business Park Drive in Sacramento, CA.


* Free parking.

Please limit resumes submitted to your top three (3) candidates that can be available for a virtual interview anticipated next week followed by in-person interviews the following week.