Database Administrator – Consultant

Lumen Solutions Group Inc.•Columbia, SC

32d•Onsite

About The Position

This role has been created to support a large-scale system modernization project and to address increased workload in data modeling and production database support. The consultant will work as part of a 6-member database engineering and administration team. The role involves both data modeling in ERwin and production support for Oracle and SQL Server environments. Responsibilities include: Conducting current-state assessment reports of existing ERwin models. Creating new or updated logical and physical data models in ERwin format (.erwin files). Developing data dictionaries and comprehensive model documentation. Maintaining a version-controlled repository of data models. Identifying data integrity and consistency issues and recommending resolutions. Supporting duplicate data resolution initiatives. Providing weekly progress updates and a final summary report. Assisting with production DBA support: ad-hoc tickets, version/security updates, and after-hours coverage as needed.

Requirements

3+ years of professional data modeling experience with ERwin or similar tools.
Strong Oracle 19c DBA and/or SQL Server 2019/2022 administration experience.
Minimum: High School Diploma.

Nice To Haves

SQL Server DBA certification.
Experience with DD Boost for Oracle backup/restore operations.
Oracle Grid Control.
Oracle ASM.
Preferred: Oracle Certified Associate or equivalent Oracle certification.

Responsibilities

Create, update, and manage data models and documentation in ERwin.
Perform reverse and forward engineering of database structures.
Implement best practices for data modeling, metadata management, and documentation.
Design and maintain logical and physical data models aligned with scalability, integrity, and performance requirements.
Identify and remediate data quality and consistency issues.
Collaborate with architects, DBAs, developers, and business analysts to translate requirements into data models.
Maintain model repositories with version control.
Support data governance and compliance initiatives.
Provide Oracle and MS SQL production support as directed by the DBA manager.
Conducting current-state assessment reports of existing ERwin models.
Creating new or updated logical and physical data models in ERwin format (.erwin files).
Developing data dictionaries and comprehensive model documentation.
Maintaining a version-controlled repository of data models.
Identifying data integrity and consistency issues and recommending resolutions.
Supporting duplicate data resolution initiatives.
Providing weekly progress updates and a final summary report.
Assisting with production DBA support: ad-hoc tickets, version/security updates, and after-hours coverage as needed.