Talent.com
Omm IT Solutions
Database ArchitectOmm IT Solutions • Saint Paul, MN, us
Database Architect

Database Architect

Omm IT Solutions • Saint Paul, MN, us
1 day ago
Job type
  • Full-time
  • Quick Apply
Job description
Job Description

PLEASE NOTE :

  • The work is expected to be done remotely or hybrid at DCYF's offices.
DESCRIPTION OF PROJECT:
The client ("MNIT") partnering with the Department of Children, Youth, and Families ("DCYF") (collectively "State") is seeking one full-time Database Architect. The State has an initiative to modernize the child welfare information system environment through the implementation of a Comprehensive Child Welfare Information System ("CCWIS"). For additional background, the State plans to hire a DDI vendor to implement a solution. In preparation for the DDI solution, the State is planning to consolidate the data from the 87 county databases into a centralized data lake that the new solution will utilize.
As an Azure Database Architect, this position will participate in the analysis and design, and support development, implementation, and potentially ongoing support of Azure Databases and Data Lakes, with a primary focus on the Data Lakehouse and its integrated data reserves. The responsibilities will include designing, administering, maintaining, and securing data to ensure efficient and reliable data storage solutions. The position will collaborate with cross-functional teams to optimize data workflows, support data-driven decision-making, and implement best practices for data security and integrity in Azure environments. This position also will provide mentorship to other architects and database engineers.

SAMPLE TASKS:
  • Support design and implementation to improve, modernize, and transform data-driven service delivery.
  • Ensure data assets are structured, accessible, secure, and align with DCYF, MNIT, and Enterprise goals.
  • Recommend data platforms and tools to support enterprise data architecture.
  • Develop data models.
  • Ensure data access patterns are optimized.
  • Maintain necessary documentation.
  • Coordinate with necessary teams to meet security standards.
  • Support design and development of disaster recovery solutions.
  • Provide knowledge transfer.



Requirements

DESIRED QUALIFICATIONS:

  • Strong experience with designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
  • Strong experience with Databricks.
  • Strong experience with Oracle databases.
  • Experience developing and implementing data transformation solutions and cloud infrastructure integrations.
  • Experience coding and testing programs and scripts to load data using Azure data load utilities.
  • Experience with CI/CD pipelines.
  • Experience with cloud computing concepts.
  • Experience with tools such as Azure Monitor, Azure Data Factory, SQL Analytics, Query Performance Insight, Azure Resource Manager, Pearl, and Azure CLI/PowerShell for infrastructure management.
  • Experience in mentoring others in the needed technologies.
  • Experience developing and implementing backup and recovery strategies using tools such as Azure Backup or Geo-replication.
  • Experience with role-based access control, encryption, and network security.
  • Strong organizational and time management skills.
  • Desired 10 years’ experience in data architecture or data management.
  • Knowledge of data concepts, data modeling, schema design, and indexing strategies.
  • Knowledge of Azure SQL instances, managed instances, and elastic pools.
  • Knowledge of Data Warehouse Administration and Teradata Data Warehouse.




Requirements
DESIRED QUALIFICATIONS: Strong experience with designing, developing, and implementing data lakes and relational and non-relational databases in Azure. Strong experience with Databricks. Strong experience with Oracle databases. Experience developing and implementing data transformation solutions and cloud infrastructure integrations. Experience coding and testing programs and scripts to load data using Azure data load utilities. Experience with CI/CD pipelines. Experience with cloud computing concepts. Experience with tools such as Azure Monitor, Azure Data Factory, SQL Analytics, Query Performance Insight, Azure Resource Manager, Pearl, and Azure CLI/PowerShell for infrastructure management. Experience in mentoring others in the needed technologies. Experience developing and implementing backup and recovery strategies using tools such as Azure Backup or Geo-replication. Experience with role-based access control, encryption, and network security. Strong organizational and time management skills. Desired 10 years’ experience in data architecture or data management. Knowledge of data concepts, data modeling, schema design, and indexing strategies. Knowledge of Azure SQL instances, managed instances, and elastic pools. Knowledge of Data Warehouse Administration and Teradata Data Warehouse.
Create a job alert for this search

Database Architect • Saint Paul, MN, us

Similar jobs

Cabinet Shop Project Manager / Draftsman, Custom High-End Cabinetry

CSD Custom WoodworksLindstrom, Minnesota, US
Full-time

Job Description Job Description CSD Custom Woodworks is a family-run custom cabinet shop with over 30 years in the business, building high-end cabinetry for clients who value craftsmanship.We're ... Show more

 • Promoted

Product Tester – Remote

OCPAForest Lake, Minnesota, US
$15.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home in the UK to fulfill upcoming contracts with local and international companies.We guarantee 15-25 hours per week with an hourly pay of between £18/hr.Th... Show more

 • Promoted

Data Entry Product Support - No Experience

GLOCPAForest Lake, Minnesota
$15.00 hourly
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Sales Support Analyst

Van Meter IncCottage Grove, MN, United States
Full-time

The Sales Support Analyst plays a key role in supporting profitable growth by partnering closely with Sales, Supplier Operations, and other internal teams to develop, execute, and maintain effectiv... Show more

 • Promoted

Consumer Research Associate (Remote)

GL IncWyoming, Minnesota
$15.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Full Charge Bookkeeper

Robert HalfForest Lake, MN, United States
Permanent

Description We are looking for a detail-oriented Full Charge Bookkeeper to support accounting, payroll, and office administration for a growing operation in Chisago City, Minnesota.This position is... Show more

 • Promoted

Earn Side Money at Home Testing Products

Product Review JobsLINDSTROM, MN, United States
Full-time

Compensation: Varies per assignment.Location: Remote (USA) Company: ProductReviewJobs Thank you for your interest in becoming a Paid Product Tester.This opportunity is for completing market res... Show more

 • Promoted

Administrative Assistant III

Howard UniversityWashington, MN, United States
Full-time

The Talent Acquisition department hires qualified candidates to fill positions which contribute to the overall strategic success of Howard University.Hiring staff "for fit" makes significant contri... Show more

 • Promoted

Cloud Architect

DamcoSaint Paul, MN, United States
Full-time

Cloud ArchitectExperience:State of Minnesota Strong State Experience is mandatory Experience-14YearsLocation:Saint Paul, MN (Remote)Duration:17 MonthsJob Type:C2C,W2Job Description:Description of P... Show more

 • Promoted

BSA

Javen Technologies, Inc.Saint Paul, MN, United States
Full-time

The Business Systems Analyst (BSA) role will support XH strategic initiatives by partnering with business and IT teams to define, document, and manage requirements that drive Sass applications conf... Show more

 • Promoted

Database Developer

HighCloud SolutionsSaint Paul, MN, Minnesota, US
Full-time

Calibri,sans-serif"><b>Title: Database Developer</b></span></span></span></p> <p style="margin-bottom:11px"><span style="font-siz... Show more

Construction Manager - Data Center Design, Engineering and Construction

Meta PlatformsRosemount, MN, United States
Full-time

Construction Manager - Data Center Design, Engineering and Construction.Construction Manager for Data Center Design, Engineering and Construction.This position focuses on overseeing the constructio... Show more

 • Promoted

W2 - Oracle Database Administrator (scripting, IBM Rational CCM, security, troubleshooting) - Remote

TANSON CORPSaint Paul, MN, United States
Remote
Full-time

Description :The work is expected to be done remotely with up to 10 days onsite per year in St.A minimum of two weeks notice will be provided for on-site days.Interviews will be conducted via Micro... Show more

 • Promoted

Client Solutions Manager

Slice Merchant ServicesWyoming, MN, US
Full-time

Excellent opportunity to join a leading, national credit card processing company that has over a decade of industry experience.Slice Merchant Services offers innovative payment processing solutions... Show more

 • Promoted

Information Technology Professional

US NavyLindstrom, MN, US
Full-time

Information Technology Professional (IT/CTN/IS).Information Systems Technicians, Cryptologic Technician Networks, and Intelligence Specialists keep the Fleet connected, informed, and secure by oper... Show more

 • Promoted

DevOps Assoc Mgr.

ClifyXCottage Grove, MN, United States
Full-time

Join Client and help transform leading organizations and communities around the world.The sheer scale of our capabilities and client engagements and the way we collaborate, operate and deliver valu... Show more

 • Promoted

Flexible remote AI work. Your schedule. Paid weekly, straight to your bank account.

Meridian.aiForest Lake, MN, US
Remote
Full-time

Review and label digital content including text, images, and documents.Every task you complete helps improve how technology interprets information and performs in practical settings.Detail-oriented... Show more

 • Promoted

Consumer Insights Analyst

Earn HausCedar, Minnesota, United States
Part-time

We're currently seeking motivated individuals to participate in online surveys and paid gaming opportunities for well-known national brands.If you're looking for a flexible way to earn extra cash f... Show more

 • Promoted

Remote Product Tester - Flexible Studies

BuzzTestersForest Lake, MN
Remote
Full-time

Earn up to $400/week, depending on the number and type of studies you complete.Share honest feedback on products and services from independent brands.Assignments include short online surveys (10–20... Show more

 • Promoted

Systems Applications Business Analyst

Quanex Building ProductsSaint Paul, MN, United States
Full-time

Systems Applications Business Analyst.Quanex is looking for a Systems Applications Business Analyst in St.Cloud or Mounds View, Minnesota.Systems Applications Business Analyst gathers business requ... Show more