SQL DBA
SQL DBA
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Sacramento County Department of Technology is seeking a SQL Database Administrator with expertise in performance tuning indexing SQL Clustering TSQL SSRS and PowerBI. This is a contracttohire opportunity.
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. This contractor will work closely with all members of the Business Analysis and Applications Development Teams as well as enduser customers.
An expert level of knowledge and experience with Microsoft SQL Server databases SSRS and PowerBI is required. This position provides opportunities to contribute to the engineering of new systems and reengineering of old ones.
* 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 adhoc queries using TSQL * 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 * Expertise in TSQL 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 Managers Developers Customers and Management
* Participate in a team development environment using JIRA
* Excellent written and verbal communication skills
* DESIRABLE SKILLS: *
* Degree in Computer Science Business or a related discipline
* Knowledge of data integration (e.g. extract transform and load (ETL) processes)
* Ability to develop and troubleshoot SSRS reports and PowerBI dashboards with strong analytical skills
* Experience with data access performance tuning and database performance optimization * Application Development Lifecycle knowledge and experience
* Familiarity with data transport protocols (e.g. SFTP XML 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 * Ability to work independently and follow through on assignments
* 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
Required Skills : SQL
Basic Qualification :
Additional Skills :
Background Check : No
Drug Screen : No
Employment Type
Full Time
