GrandRapidsRecruiter Since 2001
the smart solution for Grand Rapids jobs

Database Architect

Company: Brooksource
Location: Grand Rapids
Posted on: February 21, 2021

Job Description:

Database Architect12-month Contract-to-Hire (CTH)Remote/Wyoming, MI$120,000 - $160,000 (DOE)
Database ArchitectOverview:Our client, an industry leading national foodservice distributor, is building a concept datastore in Google Cloud Platform (GCP) called the ICDS (integrated consumption data store). This is a place where systems will come for "cross schema" or "cross database" data. Traditionally, this might be thought of as an operational data store. Additionally, our client is in the process of implementing of SAP S/4 Hana, and several legacy data migrations are underway.We are looking for an experienced Database Architect to work closely with the Database Engineering team, as well as multiple Application Development teams to ensure that the data and applications are consistent with the Data Architecture Standards. Responsibilities:

  • Assist in the design and build of the operational data store, with the goal of distilling the data down to a common format. This role is focused on the design and data modeling, while the DBA's will be doing the hands-on technical work.
  • The physical product is targeted for the Google Cloud Platform and the initial physical components will be in Cloud SQL - likely PostgreSQL but possibly MySQL. There may also be Firestore in the mix, but that's secondary.
  • Work with Development teams to analyze data and ensure consistency with Data Architecture Standards.
  • Ensure applications across the enterprise, and the data within those applications is compatible with current data architecture, and make corrections where needed.
  • Support current database environment and tools, including a Metadata collection tool built in SSIS.
  • Leverage DevOps automation tools as we would seek to automate everything around the datastores. Our legacy environment uses Puppet today and the cloud side uses Terraform.
  • It is likely that we will need to build some services around these datastores so the candidates should also have Python development experience and possibly GCP PubSub (messaging queue).
  • Data structure design is also highly valued, so an understanding of relational and NoSQL data object design is necessary.
  • Map and design the data transfer from legacy systems into SAP S/4 Hana database, then (with Attunity) replicate data back into on-premise Oracle Database/SQL Server.
  • Interface with various technical teams including core data application team and database/ data services teams, as well as third-party managed services consultants (utilized for ongoing support).
    Must Haves:
  • 5+ years' experience working with Oracle Database and SQL Server.
  • Must have background extracting large amount of data, run complex queries, and move large amounts of data.
  • Previous experience as a Database Architect, Data Architect or similar role with strong experience in Data Modeling, Database Design and Data Governance.
  • Understanding Design Patterns
  • Experience in relational database design
  • Experience and strong understanding of Metadata
  • Strong experience working with SSIS (SQL Server Integration Services) and experience automating data Must be capable of supporting Metadata tools and others built in SSIS.
    • Experience working in a cloud environment and understanding the architectural concepts of migrating from on-prem servers to cloud.
      Strongly Preferred:
      • Experience working in an Agile environment. Experience working in a SAFe Agile environment is a bonus
      • Experience supporting legacy applications and databases in an enterprise environment.
      • Experience working in a DevOps environment and experience working with automation tools such as Puppet.
      • Experience working with Data Replication tools. DBA's will work hands-on with these tools, but we need this Architect to understand the tools and processes.
      • Attunity is utilized in this role, but other tools such as Oracle Golden Gate, etc. are sufficient.
      • Experience building and replicating tables and creating tasks is strongly preferred
      • Python Development/Scripting experience.
      • In this role, python will be used to build services around the datastore, and used for data provisioning
      • Experience working with Terraform.
      • Strong experience working with SQL Servers.
        ABOUT EIGHT ELEVEN:At Eight Eleven, our business is people. Relationships are at the center of what we do. A successful partnership is only as strong as the relationship built. We're your trusted partner for IT hiring, recruiting and staffing needs.
        For over 16 years, Eight Eleven has established and maintained relationships that are designed to meet your IT staffing needs. Whether it's contract, contract-to-hire, or permanent placement work, we customize our search based upon your company's unique initiatives, culture and technologies. With our national team of recruiters placed at 21 major hubs around the nation, Eight Eleven finds the people best-suited for your business. When you work with us, we work with you. That's the Eight Eleven promise.

Keywords: Brooksource, Grand Rapids , Database Architect, IT / Software / Systems , Grand Rapids, Michigan

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

ServiceNow SACM Technical Consultant
Description: SACM ServiceNow ConsultantITS PartnersAre you looking for a company that values you as a person Tiered of not seeing value in the work you do ITS Partners is looking for a SACM Technical Consultant (more...)
Company: ITS Partners
Location: Elwell
Posted on: 03/4/2021

Information Technology Specialist (25B)
Description: If you've ever considered a job in IT, become an Information Technology Specialist in the Army National Guard and expand your skills and experience with complex technologies. In this role, you will be (more...)
Company: Army National Guard
Location: Grand Rapids
Posted on: 03/5/2021

Magento Technical Lead/Architect
Description: OverviewPerficient has a career opportunity for a Magento Technical Lead/Architect with our Commerce Business Unit. This candidate will develop and implement eCommerce solutions for our B2C and B2B client (more...)
Company: Perficient
Location: Grand Rapids
Posted on: 03/5/2021

Junior Software Developer
Description: Revature is the fastest growing employer of emerging technology talent. We will hire over 300 new Junior Software Developers in the next 4 weeks. One day someone is going to ask you where you got your (more...)
Company: Revature
Location: South Bend
Posted on: 03/5/2021

Senior Shopify Developer
Description: Senior Shopify Developer Position SummaryThe Senior Shopify Developer is responsible for developing and implementing high-quality, scalable front-end web solutions for e-commerce or web applications using (more...)
Company: CQL
Location: Grand Rapids
Posted on: 03/4/2021

Junior CSS/HTML Developer
Description: Are you ready to get hired in the next 4 weeks Revature is the fastest growing employer of emerging tech talent and has over 300 new Junior CSS/HTML Developer positions available.One day someone is going (more...)
Company: Revature
Location: Lansing
Posted on: 03/5/2021

Systems Administrator - Linux
Description: Systems Administrator - Linux Direct Hire - Remote Los Angeles area preferred As a Systems Administrator or Senior Support Engineer, you are a primary point of contact for client support requests and (more...)
Company: Ledgent Technology
Location: Palms
Posted on: 03/5/2021

Junior Back-End App Developer - LyfeStream
Description: Description br br LyfeStream is an innovative live streaming app We are creating the first ever network for the people by the people. Our platform comprises of innovative technologies in which allows (more...)
Company: 1871
Location: Elwell
Posted on: 03/4/2021

Cable Systems Installer/Maintainer (25L)
Description: Being able to communicate across the battlefield and around the world is crucial to mission success. As a Cable Systems Installer/Maintainer, you will install the lines and equipment that allow units (more...)
Company: Army National Guard
Location: Howell
Posted on: 03/5/2021

Dotnet Developer
Description: .NET Engineer Azure Full-Time 45-75/hr. D.O.E. Grand Rapids, MI remote A leading enterprise retailer headquartered in Grand Rapids is seeking several engineers to join the team to develop and implement (more...)
Company: Brooksource
Location: Grand Rapids
Posted on: 03/4/2021

Log In or Create An Account

Get the latest Michigan jobs by following @recnetMI on Twitter!

Grand Rapids RSS job feeds