Database Administrator - ConsultantSunshine Enterprise USA is retained by our valued client to search and recruit for the following executive opening:Job Title: Database Administrator - ConsultantLocation: Blythewood, SCPosition Type: C2C/W2Years of Experience: 10+ yearsDuration of the Contract: 12 monthsAdditional details: Candidate MUST be a SC resident or willing to relocate to SC prior to starting the role at their own expense.Project Scope: The Database Administrator (Consultant) will be responsible for performing advanced data modeling and production database support in both Oracle and MS SQL environments. Key deliverables include:Current-state assessment report of existing ERwin data modelsNew or updated logical and physical data models in ERwin (.erwin files)Data dictionaries and full model documentationVersion-controlled data model repositoryIdentification of data integrity, consistency issues, and duplicate dataReporting and recommendations to address identified issuesWeekly progress reportsFinal project summary at closeoutIn addition, this role will supplement the existing DBA team with production support tasks, including:Daily ticketsVersion updatesSecurity updatesAfter-hours work as requiredYou will collaborate with a team of six database engineers/administrators and work closely with application architects, developers, business analysts, and server support teams.Key Responsibilities:Create and maintain logical and physical data models using ERwin Data ModelerUpdate model documentation and manage metadataPerform reverse and forward engineering of database structuresProvide data modeling best practices and documentation standardsEnsure models support scalability, performance, and integrity requirementsIdentify and resolve data integrity and duplication issuesProduce reports and recommendations based on findingsCollaborate with data architects, DBAs, developers, and business analystsMaintain version control of models and manage repositoriesSupport data governance and compliance effortsPerform similar modeling tasks for MS SQL databases as neededProvide Oracle and MS SQL production DBA support as directed by the DBA ManagerRequired Skills & Experience:3+ years of professional Data Modeling experience using ERwin (or similar tools)Oracle 19c DBA and/or SQL Server 2019/2022 experiencePreferred Skills:SQL Server DBA CertificationDD Boost for Oracle backup/restore operationsOracle Grid ControlOracle ASM CertificationsCertifications:Oracle Certified Associate (OCA) or equivalent Oracle certificationSUNSHINE ENTERPRISE USA LLC is an Equal Opportunity Employer and does not discriminate on the basis of race or ethnicity, religion, sex, national origin, age, veteran disability or genetic information or any other reason prohibited by law in employment.