Database Architect
Job Title:
Senior Database ArchitectLocation:
Columbus, OH (Hybrid)Duration:
Long Term Position Description:
hybrid and currently requires weekly (one day a week) on site presence at the State of Office Tower.
30 East Broad Street, Columbus, Ohio 43215 This position plays an important role in designing and constructing the agency's data infrastructure using Microsoft Azure.
This role will serve as the primary point of contact for the agency's migration of its on-premises data warehouse and analysis workspace to Microsoft Azure.
The responsibilities and duties include:
o Design and develop data infrastructure for the agency in Microsoft Azureo Recommend and implement solutions for data ingestion, ETL, data warehousing, and data analysis.
o Manage access to data infrastructure datasets and analysis tools.
o Develop budget for Microsoft Azure tools and provide recommendations on where to manage costs.
o Build distributed computing analysis environment within Microsoft Azure in order to conduct more thorough analysis and integrate machine learning/AI tools to environment.
o Design and develop database solutions using Microsoft SQL Server and Microsoft Azure tools (SSMS, SSRS, SSIS, Azure Data Factory, Azure Storage).
o Manage data in variety of methods, to include SQL databases, NoSQL databases, file storage, and blob storageo Works with IT Architecture staff, CIO and/or IT Managers to design solutions that meet agency requirementso Design and implement high availability solutionso Data modeling to define and analyze data requirements for designing databases/data warehouseso Analyze on-premise database installations for Azure migrationo Support data lake enterprise business initiativeso Support production and non-production environments incidents and requestso Code, test, debug, implement, and document data infrastructure design, construction, and remediationo Expert knowledge in SQL skills including stored procedure, trigger, index etc.
o Experience with change management with respect to people, processes, and technologieso Develop, maintain, and support business applications (SQL/web-based apps)o Streamline and improve internal processes and reportingo Drive efficiency and operational improvement using data modeling techniqueso Support and train users by providing directions, corrections, and enhancements; communicate with users to find solution to caseo Analyze user requirements, procedures, and problems to provide coaching on system use, recommend changes and automation to improve efficiencyYou'll need the following qualifications and
Experience:
o Bachelor's degree in an appropriate field of study like Computer Science, Data Science, or Information Technologyo Minimum seven years of database administration, data science, data engineering, and/or cloud-based data solution engineering.
o Previous relevant experience with Microsoft suite of data solutionso Experience conducting performance tuning and configuration, creating data models, and managing data warehouses.
It's a strong plus if you have:
o Experience with Healthcare/Mental Health environmento Expertise in Python/R programming languageo Familiar with reporting tools such as Power BI, Tableau, and Cognoso Collaborate with team leads to identify gaps and constraints associated with business requirements and processes and aid in providing solutions to resolve the process issueso Strong communication and interpersonal skillso Strong organization and time management skillso Ability to effectively handle multiple prioritieso Ability to operate across the business and in different environments and cultures.
Recommended Skills Artificial Intelligence Automation Azure Data Factory Business Requirements Change Management Communication Estimated Salary: $20 to $28 per hour based on qualifications.
Senior Database ArchitectLocation:
Columbus, OH (Hybrid)Duration:
Long Term Position Description:
hybrid and currently requires weekly (one day a week) on site presence at the State of Office Tower.
30 East Broad Street, Columbus, Ohio 43215 This position plays an important role in designing and constructing the agency's data infrastructure using Microsoft Azure.
This role will serve as the primary point of contact for the agency's migration of its on-premises data warehouse and analysis workspace to Microsoft Azure.
The responsibilities and duties include:
o Design and develop data infrastructure for the agency in Microsoft Azureo Recommend and implement solutions for data ingestion, ETL, data warehousing, and data analysis.
o Manage access to data infrastructure datasets and analysis tools.
o Develop budget for Microsoft Azure tools and provide recommendations on where to manage costs.
o Build distributed computing analysis environment within Microsoft Azure in order to conduct more thorough analysis and integrate machine learning/AI tools to environment.
o Design and develop database solutions using Microsoft SQL Server and Microsoft Azure tools (SSMS, SSRS, SSIS, Azure Data Factory, Azure Storage).
o Manage data in variety of methods, to include SQL databases, NoSQL databases, file storage, and blob storageo Works with IT Architecture staff, CIO and/or IT Managers to design solutions that meet agency requirementso Design and implement high availability solutionso Data modeling to define and analyze data requirements for designing databases/data warehouseso Analyze on-premise database installations for Azure migrationo Support data lake enterprise business initiativeso Support production and non-production environments incidents and requestso Code, test, debug, implement, and document data infrastructure design, construction, and remediationo Expert knowledge in SQL skills including stored procedure, trigger, index etc.
o Experience with change management with respect to people, processes, and technologieso Develop, maintain, and support business applications (SQL/web-based apps)o Streamline and improve internal processes and reportingo Drive efficiency and operational improvement using data modeling techniqueso Support and train users by providing directions, corrections, and enhancements; communicate with users to find solution to caseo Analyze user requirements, procedures, and problems to provide coaching on system use, recommend changes and automation to improve efficiencyYou'll need the following qualifications and
Experience:
o Bachelor's degree in an appropriate field of study like Computer Science, Data Science, or Information Technologyo Minimum seven years of database administration, data science, data engineering, and/or cloud-based data solution engineering.
o Previous relevant experience with Microsoft suite of data solutionso Experience conducting performance tuning and configuration, creating data models, and managing data warehouses.
It's a strong plus if you have:
o Experience with Healthcare/Mental Health environmento Expertise in Python/R programming languageo Familiar with reporting tools such as Power BI, Tableau, and Cognoso Collaborate with team leads to identify gaps and constraints associated with business requirements and processes and aid in providing solutions to resolve the process issueso Strong communication and interpersonal skillso Strong organization and time management skillso Ability to effectively handle multiple prioritieso Ability to operate across the business and in different environments and cultures.
Recommended Skills Artificial Intelligence Automation Azure Data Factory Business Requirements Change Management Communication Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
