What are the responsibilities and job description for the Data Architect position at Stellar Professionals LLC?
Job Details
Location & Work Arrangement
- Location: Blythewood, South Carolina
- Work Arrangement: 100% On-site (Monday - Friday)
- Contract: This is a Contract position (12 Months, with possibility of extension).
- Candidate Requirement: Must be a South Carolina resident or willing to relocate to SC prior to starting the role.
- Mode of Interview: In-person at the Blythewood Headquarters.
Core Responsibilities
Data Architecture & Modelling (Primary Focus)
- Design, develop, and maintain logical and physical data models using ERwin Data Modeler or similar tools.
- Perform reverse and forward engineering of database structures for both Oracle and MS SQL environments.
- Conduct a current state assessment of existing ERwin models and provide reports on data integrity and consistency issues.
- Identify and aid with duplicate data resolution, providing remediation recommendations.
- Manage version control of data models and maintain comprehensive data dictionaries and model documentation.
- Collaborate with application architects, developers, and DBAs to translate business requirements into efficient data models that support scalability and performance.
Database Production Support
- Supplement the current DBA team with production support activities, including ad-hoc daily tickets, version updates, and security patching.
- May require working beyond normal business hours to ensure system uptime and complete critical updates.
Required Skills & Experience
- Data Modelling: 3 years of professional experience in data modeling with ERwin Data Modeler or a similar industry-leading tool.
- Database Expertise: Proven experience with ORACLE (19c or similar) and/or SQL SERVER (2019, 2022).
- High School Diploma is the minimum educational requirement.
Preferred Skills & Certifications
- Database Certifications: SQL Server DBA certification, Oracle Certified Associate (OCA) or equivalent.
- Oracle Technologies: Experience with DD Boost (for backup/restore), Oracle Grid Control, and Oracle ASM.
- Domain Knowledge: Experience in public sector or government environments is a plus.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.