We welcome applications from candidates authorized to work without sponsorship
Must Have:
- Proven experience as a Database Administrator and/or Data Engineer, with a focus on data migration projects.
- Hands-on experience with Aurora PostgreSQL, MongoDB, and Oracle databases.
- Strong expertise in data modeling tools and techniques
- Proficiency in ETL tools and scripting languages (e.g., Python, SQL, Shell scripting).
- Familiarity with microservices architecture and associated data management challenges.
- Experience with cloud platforms (AWS preferred) and cloud-native database services.
- Strong problem-solving skills and attention to detail.
- Excellent communication and collaboration skills
Roles & responsibilities
- Analyze existing legacy data systems and understand data structures, dependencies, and quality issues.
- Design and develop scalable, efficient data models aligned with the microservice-based SOR architecture.
- Plan and execute data migration strategies, including extraction, transformation, and loading (ETL) from legacy systems to the new platform.
- Develop and optimize database schemas and queries in Aurora PostgreSQL, MongoDB, and Oracle DB.
- Collaborate with software architects, developers, and business analysts to ensure data requirements are met.
- Develop scripts, stored procedures, and automation tools to facilitate data migration and validation.
- Monitor and optimize database performance, ensuring data consistency and integrity throughout the migration process.
- Implement data validation and reconciliation processes to verify successful migration.
- Document data models, migration processes, and best practices.
- Provide ongoing support and troubleshooting during and after migration.
- Ensure compliance with data governance, security policies, and regulatory requirements.
