SQL Server Developer

Overview

Remote
Depends on Experience
Contract - W2

Skills

DBA_OracleApps
DM_Data Warehousing

Job Details

Our government client is looking for an experienced SQL Server Developer on a remote 6+ months renewable contract opportunity in Salem, OR.

Position: SQL Server Developer

About the role:
The agency seeks 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.
Tasks:
Contractor’s Key Person shall:

  • 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
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.

Required skills and experience:
Skills Qualification Competency
Skills Microsoft .NET Framework Proficient (4-6 Years)
Skills MVC Proficient (4-6 Years)
Skills Service oriented architecture (SOA) Proficient (4-6 Years)
Skills SOAP Novice (1-3 Years)
Skills XMLDOM Proficient (4-6 Years)
Skills XMLSchema Proficient (4-6 Years)
Skills ADO.NET Proficient (4-6 Years)
Skills Data Analysis Expert (10+ Years)
Skills Microsoft SQL Server Advanced (7-9 Years)
Skills Transact-SQL Expert (10+ Years)
Skills AJAX Proficient (4-6 Years)
Skills CSS Proficient (4-6 Years)
Skills HTML DOM Advanced (7-9 Years)
Skills Microsoft Exchange Server Proficient (4-6 Years)
Skills C# Proficient (4-6 Years)
Skills HTML Proficient (4-6 Years)
Skills JavaScript Proficient (4-6 Years)
Skills JSON Expert (10+ Years)
Skills PL/SQL Proficient (4-6 Years)
Skills SQL Expert (10+ Years)
Skills VBScript Proficient (4-6 Years)
Skills WSDL Proficient (4-6 Years)
Skills XHTML Proficient (4-6 Years)
Skills XML Proficient (4-6 Years)
Skills XSL Proficient (4-6 Years)
Skills XSLT Proficient (4-6 Years)
Skills TCP/IP Proficient (4-6 Years)
Skills Windows 9x/2000/XP/NT/Vista/7 Advanced (7-9 Years)
Skills Shell Proficient (4-6 Years)
Skills ERwin Novice (1-3 Years)
Skills Angular Novice (1-3 Years)
Skills Apache Novice (1-3 Years)
Skills ASP Proficient (4-6 Years)
Skills ASP.NET Proficient (4-6 Years)
Skills Backup & Recovery Proficient (4-6 Years)
Skills Communication skills both verbal and written Proficient (4-6 Years)
Skills Active Directory Proficient (4-6 Years)
Skills IBM WebSphere Proficient (4-6 Years)
Skills IIS Proficient (4-6 Years)
Skills Microsoft Internet Information Server (IIS) Proficient (4-6 Years)
Skills Design patterns Advanced (7-9 Years)
Skills Microsoft Visual Studio .NET Proficient (4-6 Years)
Skills MicrosoftOffice Proficient (4-6 Years)
Skills VisualStudio Expert (10+ Years)


About Vector:
Vector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to ** People, Partnerships, Purpose and Performance - THE VECTOR WAY
www.vectorconsulting.com
“Celebrating 30 years of service.”
#LI-GK1

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.