Sr. Database Architect

  • Posted 2 days ago | Updated 2 hours ago

Overview

Remote
Hybrid
Accepts corp to corp applications
Contract - W2
Contract - 4 Month(s)

Skills

Amazon Dynamodb
Data Migration
Business Requirements
Maintenance
Database
Kafka
Mysql
Data management
Amazon Kinesis
Audit
Batch Processing
DMS
Compliance Monitoring

Job Details

Title: Sr. Database Architect

Duration: 4 Months

Location : Canada (Remote)

Sr. 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

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.