Lead SQL Database Developer (Local Candidates ONLY) (Remote)

Frameware Solutions, Inc. is seeking an experienced Lead Database Developers for a Sacramento area client. The contractor will provide database development support for existing and new SQL Server databases, provide support to application development teams, provide maintenance and operations support on all the Enterprise SQL databases and SQL Server Reporting Services on all environments, including production.

***INTERVIEWING LOCAL CANDIDATES ONLY***

Job Type: 1 Year Contract (1099 or Corp-to-Corp), and Two 1 Year Optional Renewals

Mandatory Qualifications:

• Minimum five (5) years of experience working as a lead within the last 7 years
• Designing and implementing data extracts using Replication, Stored Procedures and SQL Server Integration Services (SSIS)
• Minimum seven (7) years developing reports using Microsoft SQL Server Reporting Server (SSRS)
• Minimum seven (7) years developing ETL processes using Microsoft SQL Server Integration Services (SSIS)
• Minimum seven (7) years developing stored procedures, debugging, and optimizing queries by interpreting execution plans
• Minimum seven (7) years of database performance tuning and monitoring
• Minimum seven (7) years of experience working on projects under the Software development life cycle (SDLC)
• Minimum seven (7) years of experience using Team Foundation Server as source control for projects, including branching and merging
• Minimum seven (7) years of experience working with business users to document business requirements related to reports and the ETL (Extract Transfer Load) process and develop solutions based on the identified requirements.
• Minimum seven (7) years of experience installing and administering SQL Server, SQL Server Reporting Server (SSRS) and developing SQL Server Integration Services (SSIS) packages.
• Minimum seven (7) years of experience monitoring and troubleshooting issues related to SQL Server, SSRS reports and Microsoft Power BI (Business Intelligence) dashboards and reports.
• Minimum seven (7) years of experience documenting the baseline of the existing database and reporting environments.
• Minimum seven (7) years of experience migrating SQL Server databases doing side-by-side or in place migration and upgrading of Visual Studio projects for SSIS and SSRS
• Minimum two (2) years of experience performing database schema compare and data compare using Visual Studio’s SQL Server utility to synchronize environments and analyze disparities across environments.
• Minimum seven (7) years of experience generating builds for SQL Database projects, SSRS projects, and SSIS projects in Visual Studio for the purposes of promoting and deploying code changes.
• Knowledge on Data warehouse concepts and architecture
• Creating technical documentation such as:

• Requirements documents
• Configuration management documents
• Procedures
• Training/user manuals
• Systems architecture and interface diagrams
• Data model diagrams

Desirable Qualifications:

• Experience in supporting enterprise solutions within a health care organization
• Experience providing mentoring, coaching, and guidance to people with varying skill levels.

Job Type: Contract

Job Type: Contract

Pay: $65.00 - $75.00 per hour

Schedule:

• 8 Hour Shift
• Day shift
• Monday to Friday
• On Call

COVID-19 considerations:
For the current time the client is allowing staff work remotely from home, but that could be subject to change in the coming weeks.

Experience:

• relevant: 7 years (Preferred)

Education:

• Bachelor's (Preferred)

Location:

• Elk Grove, CA 95758 (Required)

Work authorization:

• United States (Required)

Application Question:

• Candidate has a minimum of 5 years as a lead within the last 7 years

Full Time Opportunity:

• No

Work Remotely:

• Temporarily due to COVID-19