Data/Information Architect - Advanced

Overview

On Site
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 30 day((s))

Skills

UI
Information Technology
Network
Microsoft
Tier 1
Cloud Computing
Recruiting
Training
Partnership
Communication
Project Scoping
Server Administration
Meta-data Management
Documentation
Scalability
Data Integrity
Reporting
Version Control
Data Governance
Regulatory Compliance
Modeling
SQL
Production Support
Management
Data Modeling
Internet Explorer
Information Engineering
ERwin
Database Administration
Microsoft SQL Server
Oracle Grid Control
Microsoft SQL Server DBA
Boost
Backup & Restore
Database
Oracle ASM
Oracle
Oracle Linux

Job Details

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.

Project Scope: The DBA will be responsible for using data modeling tools on ORACLE and MS SQL databases:

  • Current state assessment report of existing ERwin models.
  • New or updated logical and physical data models in ERwin format (.erwin files).
  • Data dictionaries and model documentation.
  • Version-controlled repository of data models.
  • Identify data integrity and consistency issues.
  • Identify and aid with duplicate data resolution.
  • Provide reporting and recommendations to address these issues.
  • Weekly progress reports.
  • Final summary report at project closeout.

This position will also supplement our current sql dba force with production support activities such as adhoc daily tickets, version updates, security updates, etc. and may require working beyond normal business hours. Candidate will be working in a team environment consisting of 6 database engineers and administrators and working directly with application architect, application developers, business analysts, and server support team.

Roles/Responsibilities:

  • Create and update data models and documentation using ERWIN
  • Performing reverse and forward engineering of database structures.
  • Providing best practices for data modeling, metadata management, and documentation.
  • Designing, developing, and maintaining logical and physical data models using ERwin Data Modeler.
  • Ensuring database designs support scalability, integrity, and performance requirements.
  • Identify data integrity and consistency issues. Provide reporting and recommendations to address the issues.
  • Identify and aid with duplicate data resolution.
  • Collaborating with data architects, DBAs, developers, and business analysts to translate business requirements into data models.
  • Managing version control of data models and maintaining model repositories.
  • Supporting data governance and compliance initiatives through effective data modeling strategies.
  • Same modeling activities may be required for MS SQL databases. ORACLE and MS SQL production support activities as needed and directed by the DBA manager.

Mandatory Skills:

  1. 3 + years of DATA MODELING EXPERIENCE. ie ERWIN
  2. 3 + ORACLE 18/19 DBA and/or SQL SERVER 2019, 2022
  3. Education Requirement: High School Diploma

Desirable Skills:

  1. 3 + years of Experience with BACKUP AND RESTORE of Databases
  2. 3+ year ORACLE GRID (CONTROL)
  3. SQL SERVER DBA CERTIFICATION
  4. DD BOOST TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR ORACLE DATABASE
  5. ORACLE ASM
  6. Preferred Certifications: ORACLE CERTIFIED ASSOCIATE OR OTHER ORACLE CERTIFICATION
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About CCS Global Tech