Sunshine Enterprise USA ยท 1 month ago
IT \- SCDMV \- Data\/Information Architect \- Advanced
Sunshine Enterprise USA is an IT Services company, and they are seeking a Database Administrator (Consultant) to perform advanced data modeling and production database support in Oracle and MS SQL environments. The role involves collaborating with a team of database engineers and administrators to ensure data integrity and support production tasks.
EmploymentHuman ResourcesRecruitingStaffing Agency
Responsibilities
Create and maintain logical and physical data models using ERwin Data Modeler
Update model documentation and manage metadata
Perform reverse and forward engineering of database structures
Provide data modeling best practices and documentation standards
Ensure models support scalability, performance, and integrity requirements
Identify and resolve data integrity and duplication issues
Produce reports and recommendations based on findings
Collaborate with data architects, DBAs, developers, and business analysts
Maintain version control of models and manage repositories
Support data governance and compliance efforts
Perform similar modeling tasks for MS SQL databases as needed
Provide Oracle and MS SQL production DBA support as directed by the DBA Manager
Qualification
Required
3+ years of professional Data Modeling experience using ERwin (or similar tools)
Oracle 19c DBA and/or SQL Server 2019/2022 experience
Preferred
SQL Server DBA Certification
DD Boost for Oracle backup/restore operations
Oracle Grid Control
Oracle ASM
Oracle Certified Associate (OCA) or equivalent Oracle certification