Lumen Solutions Group Inc. · 3 months ago
Database Administrator – Consultant
Columbia, SC
Full-time
Onsite
Mid Level
$62/hr - $69/hr
3+ years expLumen Solutions Group Inc. is seeking a Database Administrator – Consultant to support a large-scale system modernization project. The role involves data modeling in ERwin and providing production support for Oracle and SQL Server environments.
Information Technology & Services
Responsibilities
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
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
Qualification
Required
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
Preferred
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
Company
Lumen Solutions Group Inc.
Lumen Solutions Inc., is a dynamic small and minority-owned, Disadvantaged Business Enterprise headquartered in Virginia, USA.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Charanjiv Gadh
Chief Executive Officer
Company data provided by crunchbase