Data Architect

Overview

On Site
$50 - $60
Contract - W2
Contract - 18 Month(s)

Skills

Modernization
RDBMS
ACID
DataModeling
PerformanceTuning
Scalability
HA/DR
Replication
Integration
Security
Governance
Documentation
Architecture

Job Details

Role: Data Architect
Location: Issaquah, WA

Role Summary

The Database Architect will lead the modernization of legacy transactional database systems, guiding their upgrade, migration, and eventual decommissioning. This role focuses on designing resilient, secure, and scalable architectures that support high-volume transactional workloads while ensuring compliance with organizational standards and governance policies.

Key Responsibilities

< data-start="590" data-end="619">Lifecycle Management</>

  • Plan and guide the upgrade, migration, and decommissioning of legacy transactional databases.

  • Ensure alignment with organizational policies for data retention, archiving, and compliance.

< data-start="814" data-end="848">Documentation & Standards</>

  • Create comprehensive documentation of database architecture, data models, and operational processes.

  • Define and promote best practices for database development, maintenance, and operations.

< data-start="1046" data-end="1078">Integration & Data Flow</>

  • Design and oversee integration of transactional databases with enterprise systems and applications.

  • Define real-time data ingestion and consumption patterns to ensure seamless and consistent data flow.

< data-start="1288" data-end="1323">Data Governance & Security</>

  • Establish and enforce governance policies for transactional data including quality, retention, and archiving.

  • Implement robust security measures such as access controls, encryption, and auditing.

< data-start="1527" data-end="1568">Performance Tuning & Scalability</>

  • Identify and resolve performance bottlenecks in transactional systems.

  • Develop strategies for scaling databases using techniques such as sharding, clustering, and connection pooling.

< data-start="1759" data-end="1801">Database Selection & Architecture</>

  • Evaluate and select appropriate relational database technologies (e.g., MySQL, Oracle, PostgreSQL).

  • Design resilient architectures with high availability, disaster recovery, and data replication.

< data-start="2005" data-end="2046">Data Model Design & Optimization</>

  • Design conceptual, logical, and physical data models for transactional systems with proper normalization and referential integrity.

  • Optimize schema design for performance through indexing strategies, data type selection, and selective denormalization.

Qualifications

  • Proven experience in legacy system modernization and transactional database architecture.

  • Deep understanding of ACID principles and relational database technologies.

  • Strong knowledge of performance tuning, scalability techniques, and secure data practices.

  • Experience with real-time data integration and enterprise system interoperability.

  • Excellent documentation and communication skills.

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.

About Nineteen Eleven Solutions