Database Architect

Company: Complete Corporate Solutions
Location: Lansing
Posted on: February 20, 2021

Job Description:

• The Database Architect is responsible for creating logical and physical data models that support the department's business functions and facilitate data standardization and governance. The Database Architect works closely with the Project Team to provide insight into strategic data manipulation. Responsibilities
  • Serve on the Management Technical Team.
  • Review and analyze department data, data fields, data structure, data models to assess the quality of the data and recommend steps to be taken to cleanse, standardize and model the data as part of the DCBS Project.
  • Work closely with the Project Sponsors, Business Product Owners, Business Office SME's and other project stakeholders so that the importance of data is broadly and consistently understood.
  • Collaborate with other architects to research and develop enterprise data standards.
  • Provide guidance and recommendations to DIFS Governance Board in relation to data governance and standards.
  • Act as the point of contact between the Governance Boards and Project Team for data quality issues and communications.
  • Remain the Data Champion throughout the lifecycle of the DCBS Project effort.
  • Creates Data Integrity Plan to ensure inclusion of data management in all future projects and system maintenance.
  • Educate Project Team, Project Sponsors and DIFS employees on the importance of being good stewards of DIFS data and maintaining rules, structure and standards for data ongoing.
  • Determine DCBS database structural requirements by analyzing DIFS existing database, business operations, current applications, and programming; and understanding DIFS objectives.
  • Work closely with the Technical Leads to create project data models and assess where enterprise data should be utilized.
  • Educate Project Team on the data model and use of data conversion tool(s). Ensures appropriate tools are used for data conversions.
  • Define and maintain enterprise standards for the data architecture.
  • Practice Agile Methodology throughout the project lifecycle.
  • Work closely with Application Developers to implement and support data-oriented development efforts.
  • Verify all application data designs while maintaining enterprise standards for data.
  • Create scripts to implement the physical data model in the database (i.e. create the tables, views, sequences, etc.).
  • Assist Application Developers in creating database code units (e.g. functions, procedures, packages)
  • Assist Application Developers in tuning SQL queries and creating appropriate access paths (i.e. indexes)
  • Create and submit requests to have the database scripts promoted to QA and production.
  • Create and execute the Data Migration Plan to select, prepare, extract, transform and transfer data to the new database in the correct form and quality; meeting DIFS data retention schedules. - provided by Dice

Keywords: Complete Corporate Solutions, Lansing , Database Architect, IT / Software / Systems , Lansing, Michigan