SQL Database Developer

Spectraforce Technologies; Salem (OR); Remote; USD 70,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled SQL Database Developer to enhance data-driven decision-making in Child Welfare programs. This role involves designing and optimizing Microsoft SQL Server data structures, ensuring compliance with federal regulations, and collaborating with various teams to modernize data practices. The ideal candidate will have extensive experience in Transact-SQL, data analysis, and database management, contributing to strategic initiatives that promote data quality and legislative compliance. Join a forward-thinking organization committed to making a positive impact through innovative data solutions.

Qualifications

• 7-9 years experience with Microsoft SQL Server and Reporting Services.
• 10+ years experience in Data Analysis and SQL.

Responsibilities

• Design and implement database solutions for data storage and access.
• Maintain compliance with federal regulations and data security.

Skills

Transact-SQL

Microsoft SQL Server

Data Analysis

JSON

C#

HTML

JavaScript

Communication skills

Education

Bachelor’s degree in a related field

Tools

Microsoft Visual Studio

Microsoft .NET framework

Microsoft Azure Development Operations

Job description

SQL Database Developer

Duration: 3 Months

Location: Salem, Oregon 97302 (REMOTE)

Role:

• The team includes an experienced Database Analyst Level IV specializing in designing and developing Microsoft SQL Server data structures, optimizing database interactions (SQL, stored procedures, ETL, etc.), in compliance with business, data security, regulatory requirements, legislative mandates, and court findings.
• This role will support Child Welfare (CW) plan items from previous years, CW Transformation strategies, data quality initiatives, and the transition to data-oriented decision making in CW practice.
• The contractor's key person will collaborate with various CW program areas and business teams to deliver strategic components for data modernization, legislative compliance, and court mandates.

Tasks:

1. Develop database structures and process changes based on specifications from weekly Sprint planning, adhering to data standards, including those from the United States Postal Service where applicable.
2. Ensure compliance with data security and access models.
3. Follow Federal regulations for CCWIS design, development, deployment, and maintenance.
4. Adhere to the 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)
• HTML DOM (7-9 years)
• Windows 9x/2000/XP/NT/Vista/7 (7-9 years)
• Transact-SQL (10+ years)
• Microsoft Visual Studio (10+ years)
• Microsoft .NET framework (4-6 years)
• Microsoft Azure Development Operations
• MVC (4-6 years)
• Data Analysis (10+ years)
• JSON (10+ years)
• SQL (10+ years)
• XML (4-6 years)
• C# (4-6 years)
• HTML (4-6 years)
• JavaScript (4-6 years)
• TCP/IP (4-6 years)
• Communication skills (verbal and written, 4-6 years)
• Microsoft Office (4-6 years)

Additional Skills and Experience:

• Software development lifecycle, especially regarding requirement changes
• Agile development process
• Requirements elicitation and collaboration with non-technical staff
• Experience with modernization initiatives and federal program regulations
• Managing database changes affecting external data exchanges or data warehouses

Responsibilities & Requirements:

• Maintain data storage and access by designing and implementing database solutions, identifying data sources, and documenting processes.
• Write code for database access, modifications, and construction.
• Follow established guidelines and instructions.
• Work under supervision, reporting to a manager.
• Education and experience requirements: Bachelor’s degree in a related field and 0-2 years of relevant experience, or substitutions such as college coursework, certifications, or relevant work experience as specified.