Database Administrator

Job Title : Data / Information Architect - Advanced

Location : Blythewood, SC 29016 (Onsite)

Duration : 12 months with possible extension

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

Required skills (rank in order of importance) :

• 3 Years Professional Data Modeling with ERWIN Data or similar data modeling tool
• Oracle 19 DBA and / or SQL Server 2019, 2022

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