JVIC, a Zachry Group Company
JVIC Catalyst Services
Ambitech

Job Attributes

Requisition ID:

44428

Job Category:

Technical

Division

Technology and Information Services

Job Status

External

Job Type:

Contract

Job Location

SAN ANTONIO, TX 78221 - US

Apply Now SQL DATA ARCHITECT (CONTRACT) Job in SAN ANTONIO

Zachry Group has an exciting new opportunity for a Contract SQL Data Architect to be based in Houston, Texas. The opportunity to work remotely may be an option based on experience and leadership skills.

The SQL Data Architect will work closely with IT and business professionals to transform a departmental application from Microsoft Access to an enterprise-scale application leveraging a SQL data platform.  The desired candidate will have recent experience with Microsoft Access database to SQL database conversions. This position is a 12-week contract position starting no later than September 17th.

 

Requirements:

  • Bachelor/Associate’s Degree or equivalent experience.
  • 8 – 10 years Database Development experience.
  • Experience with Database Development for MSSQL Server (8+ years).
  • Experience in Microsoft Access and the Microsoft SQL Server Migration Assistant for Access.
  • Experience in implementing automation using stored procedures and scripts.
  • Experience in troubleshooting and resolving database problems.
  • Experience in Query Optimization and Performance Tuning, using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server or Azure SQL.
  • Knowledge of indexes, index management, and statistics.
  • Experience working with Windows server, including Active Directory and proper disk configurations.
  • Good communication and documentation skills.

 Preferred Qualification:

  • Experience with Azure SQL
  • Experience with Azure Data Factory pipelines.
  • Experience with PowerBI.

PHYSICAL DEMANDS

Employee will be required to communicate in person, via telephone, email, video chat and software systems.  Position may include visits to construction sites and industrial facilities requiring mobility (on ground and at heights) and the use of personal protective equipment (PPE) including but not limited to: hardhat, safety glasses/goggles, ear plugs/muffs, masks/respirators, safety vests, gloves and work boots.

  •  

 Preferred Qualification:

  • Experience with Azure SQL
  • Experience with Azure Data Factory pipelines.
  • Experience with PowerBI.

PHYSICAL DEMANDS

Employee will be required to communicate in person, via telephone, email, video chat and software systems.  Position may include visits to construction sites and industrial facilities requiring mobility (on ground and at heights) and the use of personal protective equipment (PPE) including but not limited to: hardhat, safety glasses/goggles, ear plugs/muffs, masks/respirators, safety vests, gloves and work boots.

 

WORK ENVIRONMENT

Will work in a general office environment. Capable of operating and functioning in a fast-paced work environment. Must possess a vision (corrected or uncorrected) that allows for clear visibility from a distance of 20 inches or less. The above description covers the fundamental responsibilities of the SQL Data Architect (contract) position. It shall not be construed as a complete listing of all miscellaneous, incidental, or similar duties which may be required from day-to-day.

Zachry Group is dedicated in providing a Safe and Drug Free work environment; and is an Equal Opportunity Employer.

 

Apply Now