| NEED Database Architect with Strong Azure at Ohio at Strong, Arkansas, USA |
| Email: [email protected] |
| From: goutham, IT Strategies inc [email protected] Reply to: [email protected] Client is State of Ohio Hybrid One day a week in Office - Columbus Prefer Ohio Residents; May consider Relocation candidates Interview - Be prepared for In Person (TBA) Role is Database Architect with Strong Azure Background Also please read the "Strong Plus" last para IMPORTANT that one reads the last but one para on "qualification and experience" this is to do with Data Science background Short Description Sr. Database Architect hybrid and currently requires weekly (one day a week) on site presence at the State of Office Tower. Complete 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 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 modeling 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 modeling 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 Keywords: artificial intelligence business intelligence rlang information technology |
| [email protected] View all |
| Sat Sep 09 03:01:00 UTC 2023 |