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