What are the responsibilities and job description for the SQL DBA position at KEY BUSINESS SOLUTIONS, INC.?
SQL DBA
Sacramento, CA(Onsite)
12 Months
Need USC,GC on our W-2
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.
This contractor will work closely with all members of the Business Analysis and Applications Development Teams, as well as 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 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
Expertise in 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 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
Regards,
Satya
Technical Recruiter
Key Business Solutions, Inc|| Office: 916 646 2080 Ext 216 OR D: 667 837 5998|| Fax: 916 646 2081 || Email:satya@keybusinessglobal.com || G Talk: satyakeysoft
Notice: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list. Thank You
Salary : $46 - $58
