Hello,
Greetings of the day
Please find the below JD & provide me your update resume.
Role: SQL Database Administrator
Location: Sacramento, CA - Hybrid
Duration: 12+ months
Client: County
Please submit USC, GC on w2.
This position will be on-site with telework offered 2 days a week after three (3) months. The interview and work location will be at 9750 Business Park Drive, Sacramento (moving to Folsom in 6 months). The anticipated timeframe of this role will be 12 months with possible extensions.
Sacramento County Department of Technology is 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, building stored procedures, views, and functions to support database interactions by applications, services, reports and dashboards. This contractor works closely with all members of the Business Analysis and Applications Development Teams as well as the end user 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 re-engineering 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 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
Job Type: Contract
Pay: $40.00 - $55.00 per hour
Benefits:
• Dental insurance
• Health insurance
• Paid time off
Schedule:
• 8 hour shift
Ability to Relocate:
• West Sacramento, CA 95605: Relocate before starting work (Required)
Work Location: Hybrid remote in West Sacramento, CA 95605
