Data Architect

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

Data Modeling
Data Integration
Enterprise Architecture
Extract
Transform
Load
Database Architecture
Cloud Computing
Database Design
Microsoft SQL Server
Oracle
Oracle Cloud

Job Details

  • Database Architecture & Design:
    • Develop logical and physical data models for complex applications.
    • Design schemas, tables, indexes, and relationships for optimal performance.
    • Define data governance policies, standards, and best practices.
  • Technology Strategy & Planning:
    • Create database architecture roadmap aligned with business goals.
    • Evaluate and recommend database technologies (Oracle RAC, SQL Server AlwaysOn, cloud solutions).
    • Plan for high availability, scalability, and disaster recovery.
  • Performance & Optimization:
    • Design for query efficiency, indexing strategies, and storage optimization.
    • Collaborate with DBAs and developers for performance tuning.
  • Integration & Security:
    • Define data integration strategies across systems and platforms.
    • Ensure compliance with security standards and regulatory requirements.
  • Collaboration & Leadership:
    • Work closely with application architects, business analysts, and DBAs.
    • Provide technical guidance and mentorship to development teams.

Required Skills & Qualifications:

  • Technical Expertise:
    • Strong experience in Oracle 12c/19c and SQL Server 2016/2019 architecture.
    • Proficiency in data modeling, PL/SQL, T-SQL, and performance tuning.
    • Knowledge of ETL processes, data warehousing, and cloud databases (Azure SQL, Oracle Cloud).
  • Additional Skills:
    • Familiarity with enterprise architecture frameworks.
    • Strong understanding of high availability solutions (Oracle RAC, AlwaysOn Availability Groups).
    • Excellent analytical and problem-solving skills.
  • Experience:

10+ years of experience in database design and architecture.

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.