Job Description

Role:- SQL Database Administrator- PowerBI Server

Location – Sacramento ,CA ( 100% onsite )

Duration - 12+ month contract

MUST interview In-Person - No Exceptions. NO Video interviews allowed

Job Summary

The Sacramento County Department of Technology is seeking a skilled SQL Database Administrator for a contract-to-hire opportunity. The ideal candidate will have expertise in performance tuning, indexing, SQL Clustering, T-SQL, SSRS, and PowerBI. This role involves maintaining data collection and sharing processes, developing SSRS reports and Power BI Dashboards, optimizing database processes, and building stored procedures, views, and functions to support database interactions by applications, services, reports, and dashboards. The SQL Database Administrator will work closely with the Business Analysis and Applications Development Teams, as well as end-user customers.We are seeking a SQL Database Administrator with expertise in performance tuning, indexing, SQL Clustering, T-SQL, SSRS, and PowerBI. Responsibilities include maintaining data collection and sharing processes, developing SSRS reports and Power BI Dashboards, optimizing database processes, and building stored procedures, views, and functions to support database interactions by applications, services, reports, and dashboards.

Must Have Skills:

• Expert knowledge and experience with Microsoft SQL Server databases, SSRS, and PowerBI.
• Must have experience with installing, configuring and maintaining SQL Server Clusters and PowerBI Report Server
• Proficiency in T-SQL and development of stored procedures.
• Experience in report writing with SSRS and PowerBI.
• Strong skills in performance tuning, indexing, and SQL Clustering.
• Ability to develop and troubleshoot SSRS reports and PowerBI dashboards.
• Must have excellent communication skills .
• Knowledge of data integration processes (ETL).
• Familiarity with data transport protocols (e.g., SFTP, XML, JDXDML).
• Experience with Case Management data and/or Justice System data.
• Basic understanding of networking principles.
• Ability to analyze system resource usage and constraints.
• Strong communication skills; ability to interact at all levels, including management.
• Ability to work independently and follow through on assignments.

Responsibilities

• 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 using T-SQL.
• Research, troubleshoot, and resolve data issues.
• Assist with system analysis and application design within the project team.
• Collaborate with Business Analysts and customers to refine requirements and ensure data quality.
• Contribute to the definition, development, and maintenance of standards and processes.
• Develop stored procedures, views, and functions using T-SQL.
• Write reports using SSRS and PowerBI.
• Drive continuous improvement and automation in BI solutions and processes.
• Work effectively with System Administrators, Project Managers, Developers, Customers, and Management.
• Participate in a team development environment using JIRA.
• Communicate effectively in written and verbal forms.

Desirable Skills:

• Degree in Computer Science, Business, or a related discipline.
• Application Development Lifecycle knowledge and experience.
• Documentation of system support information.

Other Important Information

• A background check is required.
• Telecommuting is not offered during the first year.
• Work location: 8735 Folsom Boulevard, Sacramento, CA.
• Free parking available.

Job Tags

Similar Jobs