Database Architect (598048)
Lansing, MI
12 Months
 
Interview Mode: Phone In Person
 
Short Description:
Designs, develops, and manipulates database management systems, multidimensional databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database.
 
Complete Description:
Years of Experience:
8-11 years of experience in the field or in a related area.
 
Job Description:
This position is the expert responsible for Data Services architecture, governance and implementation. The Database admin implements enterprise data services governance within the state metadata management repository, and ensures all data services designs are integrated in to the state data framework. 
 
Individual tasks related to the duty:
• Create and maintain the metadata repository. Including developing and maintaining a formal description of the data, data structures, and data flow diagrams.
• Develop and maintain the agency-wide data model for to ensure integrated use across all applications.
• Coordinate and integrate system data models and design to promote data sharing, eliminate redundancy, and provide for the efficient and effective use of the state’s data resources.
• Provide data modeling and design guidance including identification of data entities, data dependencies and data relationships.
• Define and enforce data standards, procedures, and guidelines to ensure data integrity, dependability, quality, and usability through the use of appropriate security, verification, and data management practices.
• Proven experience supporting large scale application development and development teams
• Proven experience tuning/scaling large scale (near 1 TB size) databases
• Proven experience “modernizing” legacy data layers
• Experience with various forms of ETL
• Perform development of a data management strategy, to ensure data security and appropriate data retention.
• Research and promote opportunities to provide data reuse, balancing the issues of centralization and replication.
• Ensure data integration with internal organizations and with external business and IT communities.
• Promote standardizing data in collaboration with application developers, business analysts, and Data Base Administrators.
• Develop a Master Data Management strategy supporting, and consistent with, Enterprise Information Management.
 
Skills:

• Knowledge and proven skills in data modeling Required 8 Years
• Knowledge and proven skills in MS SQL Server and/or Oracle SQL Required 10 Years
• Develops strategies for data acquisitions, archive recovery, and implementation of a database. Required 8 Years
• Demonstrated experience with data management strategy, to ensure data security and appropriate data retention Highly desired 8 Years
• Research and promote opportunities to provide data reuse, balancing the issues of centralization and replication. Desired 5 Years
• Demonstrated experience in SQL Tuning Required 5 Years
•  
  
  Regards,
  Ravi
  
  Key Business Solutions, Inc.
  
  || Office: 916 646 2080 Ext 218 || Fax: 916 646 2081
  
  Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.