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 NDA

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.

• 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.

• 3 years of professional data modeling experience with ERwin or similar tools.

• Strong Oracle 19c DBA and/or SQL Server 2019/2022 administration experience.

• 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.

• In-person interviews.

• Interviewers may include technical managers system architects and data managers.

• Scheduling as soon as possible after posting closes.