Database Administrator - Consultant

Job Title: Database Administrator - Consultant Location: Onsite (Relocation required) Duration: 12+ Months (Strong possibility of extension) Work Authorization: No Visa Transfers Remote: No (Onsite required) Pre-Employment Checks: Drug, Criminal, Credit, e-Verify, ND Why This Position is Open 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. Scope of the Project 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. ssisting with production DBA support: ad-hoc tickets, version/security updates, and after-hours coverage as needed. Daily 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. Required Skills 3+ years of professional data modeling experience with ERwin or similar tools. Strong Oracle 19c DBA and/or SQL Server 2019/2022 administration experience. Preferred Skills SQL Server DBA certification. Experience with DD Boost for Oracle backup/restore operations. Oracle Grid Control. Oracle ASM. Education Minimum: High School Diploma. Preferred: Oracle Certified Associate or equivalent Oracle certification. Interview Process In-person interviews. Interviewers may include technical managers, system architects, and data managers. Scheduling as soon as possible after posting closes. ***Lumen and / or its clients will not provide equipment (Laptop, monitor, etc.) to the selected contractor. The contractor must have their own equipment. Access to a virtual desktop set up (software) will be provided by Lumen's client, allowing the user access to the required systems and technology.*** Lumen Solutions Group Inc. is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans. Lumen Solutions Group, Inc.