What are the responsibilities and job description for the Senior Database Migration Engineer position at SII Group USA?
We are seeking a Senior Database Migration Engineer with expertise in database migration, ETL processes, AWS deployment , and data reporting to support a high-stakes project.
Your role is ensuring the efficient and secure migration of critical data between systems while optimizing processes for scalability and compliance with industry standards.
Key Responsibilities :
Database Migration :
Migrate data from Oracle to MySQL Aurora, ensuring system uptime and processing throughout.
Develop, execute, and optimize iterative ETL (Exact Transform Load) processes.
Translate data mapping documentation into executable SQL scripts.
Design and implement migration strategies, including bulk migrations and incremental delta migrations.
Create Migration Validation Reports detailing migration results to ensure complete and accurate data transfer.
System Configuration & Deployment :
Configure and deploy database systems using Terraform scripts in AWS.
Set up backup and recovery solutions, ranging from basic scheduling in AWS to custom scripts or third-party hardware integrations.
Integrate monitoring systems (Zabbix, CloudWatch, or custom solutions) for database performance management.
Ensure configurations comply with industry standards and government security guidelines.
High Availability & Disaster Recovery :
Implement robust HA / DR solutions for database systems in cloud or on-premises environments.
Reporting Solutions :
Configure, deploy, and maintain Oracle Business Intelligence / Analytical Server solutions.
Collaborate with SMEs to create and customize reports tailored to client specifications.
Proactive Problem Solving :
Proactively identify gaps in data and methodology, questioning assumptions to improve efficiency.
Communicate effectively with SMEs and team members to resolve issues and ensure task completion.
Qualifications : US CITIZEN
Technical Skills :
Advanced experience with Relational Database Management Systems (RDBMS).
Strong SQL expertise for developing and executing migration processes.
Hands-on experience with Oracle to MySQL Aurora migrations.
Proficiency with Terraform for AWS configuration.
Familiarity with BI tools like Oracle Business Intelligence or similar.
Professional Experience :
Minimum 5-7 years of experience in database migration and system configuration.
Proven track record of working with high-availability and disaster recovery systems.
Demonstrated ability to lead data migrations with minimal supervision while challenging existing methodologies for greater efficiency.
Soft Skills :
Strong communication and collaboration skills to interact with SMEs and stakeholders.
Proactive problem-solver with a detail-oriented approach.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Senior Database Migration Engineer?
Sign up to receive alerts about other jobs on the Senior Database Migration Engineer career path by checking the boxes next to the positions that interest you.
