Job Title: Database Administrator
Duration: 12+ Months
Location: Columbia, SC (100% On-site)
This role supplements the current SQL DBA team with production support activities, including daily ticket resolution, version updates, security updates, and other operational tasks. The position requires collaboration in a team environment with database engineers, application architects, developers, business analysts, and server support staff. Occasional work beyond standard business hours may be required.
Responsibilities include:
Using data modeling tools on Oracle and MS SQL databases.
Conducting current state assessment reports of existing ERwin models.
Developing new or updated logical and physical data models in ERwin format (.erwin files).
Creating data dictionaries and model documentation.
Managing a version-controlled repository of data models.
Identifying data integrity and consistency issues, and assisting with duplicate data resolution.
Providing reports and recommendations to resolve issues.
Delivering weekly progress reports and a final summary report at project closeout.
Create and update data models and documentation using ERwin.
Perform reverse and forward engineering of database structures.
Provide best practices for data modeling, metadata management, and documentation.
Design, develop, and maintain logical and physical data models using ERwin Data Modeler.
Ensure database designs support scalability, integrity, and performance requirements.
Collaborate with data architects, DBAs, developers, and business analysts to translate business requirements into data models.
Manage version control of data models and maintain repositories.
Support data governance and compliance initiatives through effective data modeling strategies.
Perform modeling activities for both Oracle and MS SQL databases.
Provide Oracle and MS SQL production support as directed by the DBA manager.
3+ years of professional data modeling experience (ERwin Data Modeler).
Oracle 19 DBA and/or SQL Server 2019/2022 experience.
High School Diploma (or equivalent).
SQL Server DBA Certification.
DD Boost knowledge to support backup and restore operations for Oracle databases.
Oracle Grid Control experience.
Oracle ASM experience.