Jada Systems
SQL Developer
Jada Systems, Elk Grove, California, us, 95759
Jada Systems, Inc. Seeks the following: Senior Software Engineer (SQL Database Developer):Estimated Start Date:
Feb. 10, 2025Duration:
Not to exceed 2 Years (1 year extension option)Location:
On-Site (Elk Grove, CA)Hours (Excluding State Holidays):
Monday thru Friday, 8:00am 5:00pm (40 hours per week)Experience:
Minimum five (5) years of experience in Information TechnologyStatement of WorkSQL Database Developer : Developing, maintaining, migrating and tuning SQL Server database and reporting environments. The selected candidate will provide database development support for existing and new SQL databases and providing applications development, maintenance and operations support on all the Enterprise SQL databases and SQL Server Reporting Services for all environments (Development, Test, Staging and Production).The selected candidate will be involved in reviewing and documenting existing SQL database designs and identifying areas for improvement. Based on the suggested design and action plan, the selected candidate will perform the following tasks and provide documentation:Working with business users to document business requirements related to reports and ETL (Extract Transfer Load) process and develop solutions based on identified requirements.Installing and administering SQL Server, SQL Server Reporting Server (SSRS) and developing SQL Server Integration Services (SSIS) packages.Monitoring and troubleshooting issues related to SQL Server, SSRS reports and Microsoft Power BI reports.Documenting the baseline of the existing database and reporting environments.Optimizing the query functionality and performance tuning of the database.Creating and maintaining stored procedures, views and functions to test and verify KPIs according to documentation for the MH Verification project.Providing detailed knowledge transfer to State staff as defined in 5. Knowledge Transfer below.Knowledge TransferThe selected candidate must perform "knowledge transfer" to technical staff. "Knowledge transfer" is defined as personal and/or technical knowledge or information which will enable or enhance the ability of staff to maintain and operate specific systems."Knowledge transfer" shall also include "on the job" training and education to staff, including all relevant documentation, to enable staff to adequately maintain and operate the solutions.The selected candidate shall also provide a written manual/guide of all materials associated and agrees that staff may reproduce such documentation for its own use to sustain project continuity.Mandatory QualificationsThis classification must have a minimum of five (5) years of experience in Information Technology. At least three (3) years of that experience must be in the following areas below:This classification requires the possession of a Bachelors Degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.Experience with designing and implementing data extract using Replication, Stored Procedures and SQL Server Integration Services (SSIS);Experience in developing Microsoft SQL Server Reporting Server (SSRS);Experience with stored procedures creation, debugging, optimization and database performance tuning and monitoring.Experience in all phases of software development life cycle (SDLC) for database development, report writing and report administration.Experience with business intelligence tools like Visual Studio Business Intelligence Module or Microsoft Power BI.Experience with data warehouse concepts and architecture; andExperience producing requirements documents, systems architecture and interfaces, data model diagrams, configuration management documents, and procedural manuals.Desirable Qualifications (within the las three (3) years of experience)Experience producing requirements documents, systems architecture and interfaces, data model diagrams, configuration management documents, and procedural manuals.Experience with Electronic Health Care Record SystemsExperience in supporting enterprise solutions within a health care and/or correctional environment.Experience with organizational change management.TO BE CONSIDERED, THE FOLLOWING MUST ACCOMPANY EACH RESUME:THREE (3) REFERENCES MANAGER WHO CAN VERIFY THE WORK PERFORMEDRELATED CERTIFICATION(S)COPY OF DEGREE(S) NECESSARY TO SATISFY EDUCATION REQUIREMENTS (SCREENSHOTS NOT PERMITTED)
Feb. 10, 2025Duration:
Not to exceed 2 Years (1 year extension option)Location:
On-Site (Elk Grove, CA)Hours (Excluding State Holidays):
Monday thru Friday, 8:00am 5:00pm (40 hours per week)Experience:
Minimum five (5) years of experience in Information TechnologyStatement of WorkSQL Database Developer : Developing, maintaining, migrating and tuning SQL Server database and reporting environments. The selected candidate will provide database development support for existing and new SQL databases and providing applications development, maintenance and operations support on all the Enterprise SQL databases and SQL Server Reporting Services for all environments (Development, Test, Staging and Production).The selected candidate will be involved in reviewing and documenting existing SQL database designs and identifying areas for improvement. Based on the suggested design and action plan, the selected candidate will perform the following tasks and provide documentation:Working with business users to document business requirements related to reports and ETL (Extract Transfer Load) process and develop solutions based on identified requirements.Installing and administering SQL Server, SQL Server Reporting Server (SSRS) and developing SQL Server Integration Services (SSIS) packages.Monitoring and troubleshooting issues related to SQL Server, SSRS reports and Microsoft Power BI reports.Documenting the baseline of the existing database and reporting environments.Optimizing the query functionality and performance tuning of the database.Creating and maintaining stored procedures, views and functions to test and verify KPIs according to documentation for the MH Verification project.Providing detailed knowledge transfer to State staff as defined in 5. Knowledge Transfer below.Knowledge TransferThe selected candidate must perform "knowledge transfer" to technical staff. "Knowledge transfer" is defined as personal and/or technical knowledge or information which will enable or enhance the ability of staff to maintain and operate specific systems."Knowledge transfer" shall also include "on the job" training and education to staff, including all relevant documentation, to enable staff to adequately maintain and operate the solutions.The selected candidate shall also provide a written manual/guide of all materials associated and agrees that staff may reproduce such documentation for its own use to sustain project continuity.Mandatory QualificationsThis classification must have a minimum of five (5) years of experience in Information Technology. At least three (3) years of that experience must be in the following areas below:This classification requires the possession of a Bachelors Degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.Experience with designing and implementing data extract using Replication, Stored Procedures and SQL Server Integration Services (SSIS);Experience in developing Microsoft SQL Server Reporting Server (SSRS);Experience with stored procedures creation, debugging, optimization and database performance tuning and monitoring.Experience in all phases of software development life cycle (SDLC) for database development, report writing and report administration.Experience with business intelligence tools like Visual Studio Business Intelligence Module or Microsoft Power BI.Experience with data warehouse concepts and architecture; andExperience producing requirements documents, systems architecture and interfaces, data model diagrams, configuration management documents, and procedural manuals.Desirable Qualifications (within the las three (3) years of experience)Experience producing requirements documents, systems architecture and interfaces, data model diagrams, configuration management documents, and procedural manuals.Experience with Electronic Health Care Record SystemsExperience in supporting enterprise solutions within a health care and/or correctional environment.Experience with organizational change management.TO BE CONSIDERED, THE FOLLOWING MUST ACCOMPANY EACH RESUME:THREE (3) REFERENCES MANAGER WHO CAN VERIFY THE WORK PERFORMEDRELATED CERTIFICATION(S)COPY OF DEGREE(S) NECESSARY TO SATISFY EDUCATION REQUIREMENTS (SCREENSHOTS NOT PERMITTED)