Information Technology_USA - USA_Database Administrator

**Please strictly adhere to the following resume naming convention:
ALL CAPS, NO SPACES B/T UNDERSCORES

i.e. PTN_US_9999999_SKIPJOHNSON0413


###: Andres Villegas
Location: 6565 Headquarters Drive , Plano , Texas 75024. 100% onsite. 8AM - 5PM or 9AM - 6 PM
Duration: 6 months
######: 10588571

Role Descriptions: Job SummaryWe are seeking an experienced DBAData Engineer to lead the migration of data from our legacy systems to a new microservice-based System of Record (SOR). The ideal candidate will have strong expertise in data modeling| ETL processes| and database administration with hands-on experience in Aurora PostgreSQL| MongoDB| and Oracle databases. You will be responsible for designing the new data model| ensuring data integrity| and executing the migration with minimal downtime.Key ResponsibilitiesAnalyze 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.Required QualificationsBachelors degree in Computer Science| Information Systems| or related field.Proven experience as a Database Administrator andor 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.

Essential Skills: Job SummaryWe are seeking an experienced DBAData Engineer to lead the migration of data from our legacy systems to a new microservice-based System of Record (SOR). The ideal candidate will have strong expertise in data modeling| ETL processes| and database administration with hands-on experience in Aurora PostgreSQL| MongoDB| and Oracle databases. You will be responsible for designing the new data model| ensuring data integrity| and executing the migration with minimal downtime.Key ResponsibilitiesAnalyze 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.Required QualificationsBachelors degree in Computer Science| Information Systems| or related field.Proven experience as

Top 3 Required Skills:
• 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.
• Top 3 Preferred Skills:
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.
• Education Requirements: Bachelors in Computer Science or other related field
• Years of Experience: 12+ years, Project Code :