Database Administrator – ConsultantLocation: 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, NDAWhy This Position is OpenThis 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 ProjectThe 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.Daily ResponsibilitiesCreate, 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 Skills3+ years of professional data modeling experience with ERwin or similar tools.Strong Oracle 19c DBA and/or SQL Server 2019/2022 administration experience.Preferred SkillsSQL Server DBA certification.Experience with DD Boost for Oracle backup/restore operations.Oracle Grid Control.Oracle ASM.EducationMinimum: High School Diploma.Preferred: Oracle Certified Associate or equivalent Oracle certification.Interview ProcessIn-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.