Database Administrator - Consultant

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., * 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., * 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.

• 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., * Minimum: High School Diploma.
• Preferred: Oracle Certified Associate or equivalent Oracle certification.