Database Architect - Locals Preferred

  • M-99, Lansing, MI, USA
  • Contract

Job Description

Job Title: Database Architect

Location: Lansing, MI

Duration: 12+ Months contract

 

Description:

  • Analyze data and structure of legacy database; develop and maintain data models; drive data model review; design and implement replacement Oracle or MS SQL Server relational database; and migrate data. *Must have strong technical and soft skills.
  • The Client Department of Insurance and Financial is beginning its modernization efforts to replace its primary business application, OBase.  This effort will require analysis of both the content and structure of the underlying Oracle database containing 600+ tables, modeling and design of a new Oracle or MS SQL Server database, and migration of existing data to the new database.
  • Candidate for this position must have excellent soft skills as this person will work closely with both the business and technical teams.

 

Job Description:

  • Support the modernization effort from a data perspective by working closely with both business and technical teams
  • Perform current state data model assessments/target data models and gap analysis
  • Analyze legacy database, including both data content and structure to derive necessary information
  • Define and analyze data requirements needed to support business processes
  • Counsel with Subject Matter Experts on specific topics in order to accurately capture existing business rules/principles
  • Establish data modeling naming standards, abbreviations, guidelines and best practices
  • Develop and maintain conceptual, physical and logical data models
  • Drive the data model review process and solicit user’s feedback
  • Propose new database architecture, support data migration from an existing Legacy system to a new structure

 

Skills:

  • Experience supporting a business from the data perspective with a strong business understanding
  • Experience building and validating data models
  • Experience using data modeling tools
  • Expert understanding of relational databases and proficiency in writing queries (SQL and PL/SQL)
  • Expert understanding of database design tradeoffs, impacts on user expectations and performance levels
  • Experience in defining and enforcing data standards, procedures, and guidelines to ensure data integrity, dependability, quality and usability
  • Experience developing and publishing data architecture standards/guidelines governing data services, data security and privacy, and data integration
  • Strong knowledge of data governance standards
  • Ability to develop data migration strategies for moving, duplicating, retiring data from legacy systems to new applications
  • Proven ability to establish a high level of trust and confidence in both the business and IT communities
  • Strong teamwork and interpersonal skills at all levels
  • Proven influencing skills, strong collaboration, and mentoring capabilities
  • Ability to communicate effectively to all levels of the organization in a proactive, contextually appropriate manner
  • Strong organizational skills
  • Proven track record of achieving results in challenging environments
  • Experience in Agile/Scrum development environments

Qualifications

Required/Desired skills:

  1. Extensive experience in the Information Technology field as a developer, application architect, or database architect
  2. Effective communication and collaboration skills working with business and technology partners
  3. Experience with relational databases including Oracle and Microsoft SQL Server
  4. Experience in data analysis, modeling, and database design
  5. Experience in data modeling; including conceptual, logical and physical
  6. Hands-on experience with data modelling tools
  7. Experience with Agile/Scrum development environments

Additional Information

Locals Preferred