Icon hamburger
US
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply Now
Thumsup

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.
I331136gn3zddhz6blm

Data Architect w/SQL Server

Fahrenheit IT Dimondale Contractor
Apply Now

This Data Architect with SQL Server will serve as 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.

Designs, develops, and manipulates database management systems, multidimensional databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database.

Essential Tasks and Duties:

  • 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.

Required Qualifications:

  • Knowledge and proven skills in data modeling - 8 years’ required
  • Knowledge and proven skills in SQL Server and/or Oracle SQL – 10 years’ required
  • Develops strategies for data acquisitions, archive recovery, and implementation of a database – 8 years’ required
  • Demonstrated experience with data management strategy, to ensure data security and appropriate data retention – 8 years’ highly desired
  • Research and promote opportunities to provide data reuse, balancing the issues of centralization and replication – 5 years’ desired
  • Demonstrated experience in SQL tuning – 5 years’ required
 

Recommended skills

Data Management
Meta Data Management
Application Development
Data Modeling
Extract Transform Load (Etl)
Data Integration
Apply to this job.
Think you're the perfect candidate?
Apply Now

Help us improve CareerBuilder by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

Job ID: BHJOB22580_175322

CAREERBUILDER TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.