What are the responsibilities and job description for the SQL Server DBA position at Mindlance?
Job Details
Title: SQL Server DBA Duration: 12 Months (Contract to Hire) Work Mode: Hybrid - 3 days/Week onsite. The interview and work location will be at Sacramento, CA 95826
The client 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, and building stored procedures, views, and functions to support database interactions by applications, services, reports, and dashboards. This consultant 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.
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
Preferred Qualifications:
- 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
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veteran
