SQL Database Developer
3 Months
Salem, Oregon 97302 (REMOTE)
 
Role:

• The Team an experienced Database Analyst Level IV with expertise in designing and developing Microsoft SQL Server data structures, optimizing interactions with and within the database (SQL, stored procedures, ETL, etc.), in accordance with business, data security and regulatory requirements as well as legislative mandates and court findings.
• This work will continue fulfilling the Child Welfare (CW) plan items from previous years and continue to support CW Transformation strategies including data quality initiatives and the emerging transition to data-oriented decision making in CW practice.
• Contractor’s Key Person will also work with various CW program areas and business teams to deliver strategic roadmap components to execute data modernization efforts, fulfill legislative mandates and comply with court findings.

Tasks:

• Develop database structure and process changes based on specifications established during weekly Sprint planning sessions and following data standards based on existing datatype standards where available and appropriate; address standards published by the United States Postal Service as an example.
• Comply with data security and access models.
• Comply with Federal regulations for CCWIS (Comprehensive Child Welfare Information System) design, development, deployment and maintenance.
• Follow a data (or database) change request process with the developer and Data Resource Management teams.

 Required skills and experience:

• Microsoft SQL Server/Reporting Services/Business Intelligence (7-9 years of experience)
• HTML DOM (7-9 years of experience)
• Windows 9x/2000/XP/NT/Vista/7 (7-9 years of experience)
• Transact-SQL (10+ years of experience)
• Microsoft Visual Studio (10+ of years of experience)
• Microsoft .NET framework (4-6 years of experience)
• Microsoft Azure Development Operations
• MVC (4-6 years of experience)
• Data Analysis (10+ years of experience)
• JSON (10+ years of experience)
• SQL (10+ years of experience)
• MVC (4-6 years of experience)
• XML (4-6 years of experience)
• C# (4-6 years of experience)
• HTML (4-6 years of experience)
• JavaScript (4-6 years of experience)
• TCP/IP (4-6 years of experience)
• Communication skills both verbal and written (4-6 years of experience)
• Microsoft Office (4-6 years of experience)

In addition, the ideal candidate will have skills and experience in:

• Software development life cycle especially related to the impact from requirement changes.
• Agile Software Development Process
• Requirements elicitation and specification in collaboration with non-technical Business Analysts and non-technical CW business program staff.
• Modernization initiatives targeting specific technology changes or generational changes in Federal program regulations.
• Working to deliver technical solutions in a County, State or Federal Human Services context.
• Managing the impact of database changes on external data exchanges or date warehouses

Responsibilities & Requirements:

• Maintains data storage and access by evaluating, designing and implementing company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Writes codes for database access, modifications and constructions.
• Relies on established guidelines and instructions to perform daily job functions.
• Works under immediate supervision and usually reports to a manager.
• May require a bachelor’s degree in a related area and 0–2 years of relevant experience.
• Full-time professional work experience in Software Development, Maintenance, or Implementation.
• Substitutions: Accredited college training may substitute for the required work experience with a maximum substitution of four (4) years. (Fifteen (15) semester hours in Information Technology or a related area is required.) Accredited graduate training in the above area may substitute for the required work experience with a maximum substitution of two (2) years.
• Successfully completion of an Information Technology Certification program, may substitute for the required work experience with a maximum substitution of two (2) years. (Proof of certification must accompany application.) Two (2) years of work experience as a Data Administrator; Data Warehousing Administrator; Data Architect; Database Analyst-Intermediate; Data Warehousing Analyst may substitute for all of the required experience.

 

About Us: SPECTRAFORCE is one of the fastest-growing workforce solutions firms in the United States. As a diversity-owned business, we place human connection at the heart of everything we do, building strong relationships with both clients and candidates to fill roles successfully. Our teams in North and Central America and India serve more than 150 Fortune clients globally, leveraging custom AI technology to provide direct hire, executive search, nearshoring, offshoring, and project staffing solutions.
 
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.

Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
 
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
 
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer. 


At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $50.00/hr.