Position Details
Data Architect Ii Apply
Overview:
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client provider of digital technology and transformation, information technology and services
Position: Data Architect II
Location: Issaquah, WA 98027
Duration: 6 Months
Job Type: Temporary Assignment
Work Type: Hybrid
Job Description
- 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
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.
Documentation & Standards
- Create comprehensive documentation of database architecture, data models, and operational processes.
- Define and promote best practices for database development, maintenance, and operations.
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 Governance & Security
- Establish and enforce governance policies for transactional data, including quality, retention, and archiving.
- Implement robust security measures including access controls, encryption, and auditing.
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.
Database Selection & Architecture
- Evaluate and select appropriate relational database technologies (e.g., MySQL, Oracle, PostgreSQL) based on application needs.
- Design resilient architectures with high availability, disaster recovery, and data replication capabilities.
Data Model Design & Optimization
- Design conceptual, logical, and physical data models for transactional systems, ensuring normalization and referential integrity.
- Optimize schema design for performance, including indexing strategies, data types, and selective denormalization for read-heavy workloads.
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 strategies, and secure data practices.
- Experience with real-time data integration and enterprise system interoperability.
- Excellent documentation and communication skills.
TekWissen Group is an equal opportunity employer supporting workforce diversity.
