| Senior Database Architect 15+ yr Exp candidates only at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=605063&uid= From: Rosalin, Global IT Family [email protected] Reply to: [email protected] Requisition Class: SDA : Senior Database Architect 1 Region Name: State of Ohio Title/Role: DMH - Senior Database Architect 1 / SDA1 (718813) Start Date: 09/25/2023 End Date: 06/30/2024 Hybrid- 30 East Broad Street, Columbus, Ohio 43215 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 Bachelors degree in an appropriate fieldRequired database administration, data science, data engineering, and/or cloud-based data solution engineeringRequired7YearsExpert knowledge in SQL skills including stored procedure, trigger, index etcRequired Microsoft AzureRequired Experience with Healthcare/Mental Health environmentNice to have Expertise in Python/R programming languageNice to have Familiar with reporting tools such as Power BI, Tableau, and CognosNice to have Question 1Where is the candidate currently locatedQuestion 2Has the candidate agreed to work onsite in a hybrid schedule (1 day per week) Thanks & Regards, Rosalin Palo Global IT Family Email: [email protected] www.globalitfamily.com Keywords: artificial intelligence business intelligence rlang information technology http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=605063&uid= |
| [email protected] View All |
| 06:31 PM 06-Sep-23 |