coverPhoto
Devcare Solutions3.6
Data Architect
Columbus, OH
Employer est.:$62.00 - $78.00 Per Hour
Job

Job Description :

Data Architect /DA1

Years of Relevant Experience: Minimum 5 years of experience, with 3 years in solution architecture.
Preferred Education: 4-year college degree in computer science or related field with advanced study preferred.
Job Description: This engagement will be focused on ensuring that the OOD IT project schedule and efforts to move OOD toward State of Ohio Public Cloud (Azure) solutions with industry standard cloud implementations are completed timely for all applications.
The candidate will work with OOD IT and the State of Ohio Office of Information Technology (OIT) to:

  • Migrate all on-premises SQL Server solutions to Microsoft Azure SQL
  • Convert SSIS jobs to use equivalent/appropriate Azure technology
  • Collaborate with all IT (Network, Application Development, Database, Help Desk) technical teams to ensure proper integration of the environments
  • Train and mentor state staff on tools, processes and best practices for performing data migrations from on-prem MS SQL to MS Azure SQL
  • Review and recommend changes to MS Azure SQL configuration to improve performance and/or reduce expenses
  • Review and recommend changes to replication, backup and recovery practices to ensure performance, reliability and recovery standards are met

Mandatory skills The position requires expertise and understanding of developing MS Azure SQL solutions with a focus in MS Azure SQL databases, MS Azure SQL Managed Instances, and MS Azure Data factories.
1. 5 years experience with MS SQL Server. Must have 3+ years experience with MS SQL 2016 and MS SQL 2019.
2. 5 years experience with SQL Server Integration Services (SSIS)
3. 5 years experience with MS Azure SQL
4. 5 years experience with data replication between on-premises databases and MS Azure SQL
5. 5 years experience with MS Visual Studio and MS Azure DevOps Services
6. 5 years experience following Agile Development methodologies
Certifications or Desired skills if any 1. 18 months experience with Azure SQL Managed Instance
2. 18 months experience with MS Azure Data Factory
3. 18 months experience with MS Azure System Managed Identity
4. 18 months experience with MS Azure SQL Insights
5. 18 months experience MS Azure Data Classification
6. 18 months experience MS Azure DevOps Build Pipelines for databases
7. 5 years experience with Microsoft Power BI
8. 5 years experience with MS T-SQL Development
9. 5 Years experience with Business Intelligence and Data Warehouse environments using OLTP to OLAP ETL tools and techniques

Job Type: Contract

Pay: $62.00 - $78.00 per hour

Benefits:

  • Dental insurance
  • Health insurance
  • Vision insurance

Schedule:

  • 8 hour shift
  • Monday to Friday
  • Weekend availability

Experience:

  • Solution architecture: 3 years (Required)
  • MS Visual Studio: 5 years (Required)
  • MS Azure DevOps: 5 years (Required)

Work Location: Multiple Locations

Show more
Get alerts to jobs like this, to your inbox.

Suggested Searches