BigRio is seeking a SQL Database Engineer to support a data migration initiative. The role involves writing optimized SQL queries, analyzing and validating structured data, and leading the data migration process into MariaDB databases hosted on AWS.
Responsibilities:
- Write optimized SQL queries for data loading, validation, and reconciliation
- Analyze, cleanse, transform, and validate structured data before migration
- Design and execute migration scripts and batch processes
- Ensure data accuracy, consistency, and integrity post-migration
- Troubleshoot migration failures and performance issues
- Collaborate with application and infrastructure teams during migration cycles
- Document migration approach, mapping logic, and validation results
- Lead data migration from flat files (Excel/CSV) into MariaDB databases hosted on AWS
Requirements:
- Strong hands-on experience with SQL
- Experience working with MariaDB
- Solid experience handling Excel and CSV data formats
- Experience performing data migration projects
- Intermediate knowledge of AWS (RDS, EC2, basic networking concepts)
- Expert-level experience
- Comfortable working with AWS-hosted databases
- Ability to manage database configurations and connectivity
- Strong SQL Programming skills
- Strong analytical and problem-solving skills
- Detail-oriented with a focus on data accuracy
- Experience executing structured migration projects
- Comfortable working independently in a remote setup
- Experience with MySQL environments
- Familiarity with AWS database services (RDS, backups, snapshots)
- Understanding of data validation and reconciliation processes
- Experience working with large datasets