Database Administrator - Consultant
Lumen Solutions Group, Inc., Blythewood, South Carolina, United States, 29016
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.
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.