| Direct Client State of OH in Columbus, OH Need Azure Database Architect for Long Term Project. (718813) at Columbus, Ohio, USA |
| Email: [email protected] |
| From: Sai Teja, Aspired Solutions [email protected] Reply to: [email protected] Role Azure Database Architect Location Columbus, OH Duration Long Term Rate DOE Mode of Interview Web-Ex No New Submittals after 09/08/2023 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 agencys data infrastructure using Microsoft Azure. This role will serve as the primary point of contact for the agencys migration of its on-premises data warehouse and analysis workspace to Microsoft Azure. The responsibilities and duties include: Design and develop data infrastructure for the agency in Microsoft Azure Recommend and implement solutions for data ingestion, ETL, data warehousing, and data analysis. Manage access to data infrastructure datasets and analysis tools. Develop budget for Microsoft Azure tools and provide recommendations on where to manage costs. Build distributed computing analysis environment within Microsoft Azure in order to conduct more thorough analysis and integrate machine learning/AI tools to environment. Design and develop database solutions using Microsoft SQL Server and Microsoft Azure tools (SSMS, SSRS, SSIS, Azure Data Factory, Azure Storage). Manage data in variety of methods, to include SQL databases, NoSQL databases, file storage, and blob storage Works with IT Architecture staff, CIO and/or IT Managers to design solutions that meet agency requirements Design and implement high availability solutions Data modelling to define and analyze data requirements for designing databases/data warehouses Analyze on-premise database installations for Azure migration Support data lake enterprise business initiatives Support production and non-production environments incidents and requests Code, test, debug, implement, and document data infrastructure design, construction, and remediation Expert knowledge in SQL skills including stored procedure, trigger, index etc. Experience with change management with respect to people, processes, and technologies Develop, maintain, and support business applications (SQL/web-based apps) Streamline and improve internal processes and reporting Drive efficiency and operational improvement using data modelling techniques Support and train users by providing directions, corrections, and enhancements; communicate with users to find solution to case Analyze user requirements, procedures, and problems to provide coaching on system use, recommend changes and automation to improve efficiency Youll need the following qualifications and experience: Bachelors degree in an appropriate field of study like Computer Science, Data Science, or Information Technology Minimum seven years of database administration, data science, data engineering, and/or cloud-based data solution engineering. Previous relevant experience with Microsoft suite of data solutions Experience conducting performance tuning and configuration, creating data models, and managing data warehouses. Its a strong plus if you have: Experience with Healthcare/Mental Health environment Expertise in Python/R programming language Familiar with reporting tools such as Power BI, Tableau, and Cognos Collaborate with team leads to identify gaps and constraints associated with business requirements and processes and aid in providing solutions to resolve the process issues Strong communication and interpersonal skills Strong organization and time management skills Ability to effectively handle multiple priorities Ability to operate across the business and in different environments and cultures Skill Required Years Used Last Used Bachelors degree in an appropriate field Required Database administration, data science, data engineering, and/or cloud-based data solution engineering 7 Years Expert knowledge in SQL skills including stored procedure, trigger, index etc Required Microsoft Azure Required Experience with Healthcare/Mental Health environment Nice to have Expertise in Python/R programming language Nice to have Familiar with reporting tools such as Power BI, Tableau, and Cognos Nice to have Thanks, [email protected] Saiteja. Keywords: artificial intelligence business intelligence rlang information technology Ohio |
| [email protected] View all |
| Wed Sep 06 22:00:00 UTC 2023 |