The information on the AWS Aurora and DataMigration info from Oracle is shared in the linked in vlog: LinkedIn | YouTube | Krishna Sarabu | Joseph DiCaro
There are several blogs supplied by AWS for self-migration and many vendors listed by AWS who can help in the migration of the database.
A few notes are mentioned below:
Scalability
Amazon DMS- Data Migration Service
AWS- Schema Conversion tool – Assessment report in csv – helps to create reports
Oracle to AWS Aurora database migration support.
DMS Trouble shooting blogs!
Best Practices:
Table spaces
Index Types: Hash, B-Tree, GIN, GiST, BRIN, SP-GiST, partial, expression
Data types: 64 base types
Dual Table – Do not mock dual table- use view if necessary
Nulls- PostgreSQL and Oracle use nulls differently
Sequences – in PostgreSQL- each session has its own cache
QA Automation Test Engineer with Cloud experience Azure /AWS
Minimum of 7+ years of QA test experience required · Automation experience of both UI functional tests using selenium webdriver and API tests is required · API testing experience (developing API tests using Postman) is required. · Python scripting experience required · Ability to read and understand code is required · Prior experience testing applications on cloud is preferred · Experience with SQL and No-SQL technologies is required (e.g., Mongo DB, Dynamo DB) · Prior experience in working with AWS is preferred · Prior experience testing asynchronous applications and technologies is required (e.g., Rabbit MQ, Amazon SQS) · Experience using AWS services (such as CloudWatch, SQS, EC2, S3) · Prior experience in Agile-Scrum software development environment is required · Robot Framework experience preferred · Experience with Git and Bit Bucket required · Integrating automated tests in CICD pipeline using Jenkins required · Load and performance testing using tools like JMeter, LoadRunner required · Experience with test case management tools –TestRail preferred · Experience with Jira and Confluence preferred · Experience working with scrum-agile teams preferred · Should have worked on Insurance domain (preferably Travel Insurance) · Expertise in frontend, backend or API and performance testing · Experience with web services (REST), source control management (preferably Git), and continuous integration tools (preferably Jenkins) · Good understanding of Software testing lifecycle and testing concepts. · Should be ready to learn new skills as required and work in a short period · Ability to work in a fast-paced environment with minimal supervision and attitude to adapt. Technical Skills: · Hands on using Postman for API testing. Python scripting, · Hands on Performance Center, JMeter · Defect Tracking using, JIRA, Test Rails. · Ensures latest version of the executable is taken from the Version control tool. · Working experience in Scrum Processes / Agile methodologies Process / Innovation Skills: · Should be able to follow industry best processes · Should be able to bring in ideas to improve productivity and Quality of work · A focus on high quality deliverables and meeting deadlines. · Be someone who will bring innovation and ideas to the table · A collaborative style and a focus on continuous improvement, quality and planning, teamwork, strong communication. Behavioral Skills : · Should be aggressive in making decisions and managing teams · Should have very good communication. · Effectively collaborates and communicates with the stakeholders and ensure client satisfaction · Train and coach members of project groups to ensure effective knowledge management activity. Qualification: · Education qualification: Graduate BTech, BE, BCA, MCA, M. Tech or equivalent technical degree from a reputed college
