About us: Intuitive is an innovation-led engineering company delivering business outcomes for 100''s of Enterprises globally. With the reputation of being a Tiger Team & a Trusted Partner of enterprise technology leaders, we help solve the most complex Digital Transformation challenges across following Intuitive Superpowers: Modernization & Migration Application & Database Modernization Platform Engineering (IaC/EaC, DevSecOps & SRE) Cloud Native Engineering, Migration to Cloud, VMware Exit FinOps Data & AI/ML Data (Cloud Native / DataBricks / Snowflake) Machine Learning, AI/GenAI Cybersecurity Infrastructure Security Application Security Data Security AI/Model Security SDx & Digital Workspace (M365, G-suite) SDDC, SD-WAN, SDN, NetSec, Wireless/Mobility Email, Collaboration, Directory Services, Shared Files Services Intuitive Services: Professional and Advisory Services Elastic Engineering Services Managed Services Talent Acquisition & Platform Resell Services About the job: Title: Lead Database Architect Start Date: Immediately # of Positions: 1 Position Type: Contract Location : Remote across Canada Lead Database Architect - Aurora MySQL Architect with knowledge on APG, DynamoDB, DMS, Data Lake, Kafka/KinesisLead Database Architect on the project w/ following skills: 1/ Aurora MySQL Architect with knowledge on APG, DynamoDB 2/ Understanding of Data APIs 3/ Experience with Amazon DMS for data migration 4/ Experience and understanding of data lakes, and data streaming using Kafka/Kinesis 5/ Managing large scale data based on retention policies Scope: [1] Stale Data Management (one-time customer data removal) - Identification and removal of outdated records - Optimized batch processing with performance monitoring - Table reorganization and space reclamation - Removal of currently closed customers (and associated accounts) from platform - Outcome: ~35% reduction in data volume, 20-30% Cost Savings [2] Data Retention Framework (ongoing data removal) - Policy-driven automated data lifecycle management - Configurable retention rules by data category - Removal of future closed customers (and associated accounts) from platform - Compliance monitoring and reporting, Audit trail maintenance - Outcome: Data management aligned with customer''s performance improvement expectations & business requirements
Job Title
Aurora MySQL Architect