Senior Database Migration Engineer - SII Group USA : Job Details

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.