What are the responsibilities and job description for the Data Modeler / Database Administrator (Data Modeler/DBA)- W2 Only position at Information Resource Group, Inc.?
Job Details
Role: Data Modeler / Database Administrator (Data Modeler/DBA)- W2 Only
Location: Blythewood, SC
Duration: One Year Contract with possibility of extensions
Interview Process: Interviews will take place on-site at the Blythewood
Job Description:
This role will focus on Data Modeling using ERWIN or a similar tool and Reverse Engineering and requires at least 3 years of experience. DBA experience is a plus but not the main focus of the role.
Agency's Information Technology is a professional information processing group dedicated to maintaining and improving IT functions and reliability.
Daily duties / 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 mana
Required Skills:
- 3 years of professional data modeling with ERWIN data or similar data modeling tool
- 3 years' experience with Oracle 18/19 DBA and/or SQL Server 2019, 2022
Preferred Sills:
- 3 years of experience with Database backup and restore
- 3 year Oracle Grid (Control)