ExecRecruitment

Data/Information Architect- Oracle & SQL

Blythewood, SC
Full Time
Experienced
Job Title: Data/Information Architect- Oracle & SQL
Location: Blythewood, SC

SCOPE OF THE PROJECT:

This role 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.

Key duties and 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.

Required Skills

  • 3 YEARS PROFESSIONAL DATA MODELING with ERWIN Data or similar data modeling tool                                    
  • 3 + ORACLE 18/19 DBA and/or SQL SERVER 2019, 2022

Education Requirement

High School Diploma

Preferred Skills

  • 3 + years of Experience with BACKUP AND RESTORE of Databases
  • 3+ year ORACLE GRID (CONTROL) 

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):

  • SQL SERVER DBA CERTIFICATION
  • DD BOOST TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR ORACLE DATABASE
  • ORACLE GRID CONTROL
  • ORACLE ASM

PREFERRED CERTIFICATIONS:

  • ORACLE CERTIFIED ASSOCIATE OR OTHER ORACLE CERTIFICATION
Please apply on our secured job site at <<https://intellibee.my.salesforce-sites.com/apps/jobs?id=a0AUU000003mCZp2AM>> or email [email protected]
Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Human Check*