Job summary:

Job description:

*** Webcam interview *** long term project initial PO for 3 years with multiyear extensions *** *** Remote ***

*** Need 3 verfiable references ***

Summary of Work:

This position will plan for, develop, test, and support database migrations to new databases within a Cloud environment

Minimum Job Specific Skills/Qualifications Required (in order of relative importance):

• 5+ years experience designing complex, normalized, relational application databases, including Oracle. 
• 5+ years experience designing, developing, and deploying relational databases in a cloud environment, especially Azure and/or AWS, ensuring the integrity and security of the database. 
• Experience migrating an on premises or cloud Oracle DB to any one cloud based solution such as Azure SQL, MySQL, Azure Oracle in VM, AWS Aurora, or AWS RDS. 
• Excellent written and verbal communication skills, with both technical and non technical audiences. 
• Experience analyzing requirements, researching alternatives, and making successful recommendations for database solutions. 
• Experience developing and executing successful migration plans from one database solution to another (e.g., Maria DB to MY SQL, Oracle to Azure SQL, not from one Oracle DB to another Oracle DB). 
• Demonstrated knowledge and successful execution of the principles and techniques of the full database design, modeling, development, testing, and documentation lifecycle. 
• Demonstrated knowledge and successful execution of the principles and techniques of systems implementation, including conversion, data reconciliation, and documentation. 
• Experience developing and documenting relational database models, based on functional specifications and conceptual object models. • 
• Experience developing and documenting database schemas based on relational models. 
• Experience building and deploying relational databases based on database design, models, and schemas. 
• Experience administering relational databases and conducting performance optimization to meet SLAs. 
• Experience analyzing database configuration to research and resolve database and application issues. 
• Extensive experience with function and stored procedure packages using SQL. 
• Experience with database performance monitoring and tuning tools and techniques. 
• Experience developing data scrubs to correct data based on knowledge of the application. 
• Principles of information systems architecture for enterprise wide systems deployment such as multi tier, web based, distributed system architecture and development principles, and internet/intranet application delivery mechanisms. 
• Experience coordinating with 3rd party vendors to resolve database software issues

Additional Skills/Qualifications Desired:

• Experience with software and tools ERwin Data Modeler, Toad, Eclipse, JIRA, Clear Quest, and Subversion. 

Description of Tasks and Responsibilities:

• Research, analyze, present alternatives, including cost and performance analysis, and recommend cloud alternatives to the current databases.
• Develop and document a plan to migrate to a new database, including conversion, data migration, and data reconciliation.
• Design, develop, and document the structure for the new database, including database models and schemas, ensuring the integrity and security of the database.
• Lead and execute the build and deployment of the new database.
• Lead and execute the migration to the new database, including conversion and data reconciliation.
• Administer the new database and provide plans and instructions for administration activities.
• Conduct performance optimization to meet SLAs.
• Analyze reported issues and provide recommendations for resolving.
• Develop auditable data scrubs to correct data issues.
• Provide a monthly status report.

Contact the recruiter working on this position:

The recruiter working on this position is Fazal(Shaji Team) Uddin
His/her contact number is +(1) (703) 4684697
His/her contact email is fazal@msysinc.com

Our recruiters will be more than happy to help you to get this contract.