Description:
Design, update the existing integration solutions to move data between on-premises and cloud solutions using Oracle technology such as Integration Cloud, Oracle Data Integrator, and custom PL/SQL.
Review and analyze database implementations for existing enterprise applications.
Modify database management system (DBMS) objects to support enterprise application development.
Review and analyze system requirements, perform data, and gap analysis, and recommend solution options.
Perform code reviews, promotions and conduct testing activities.
Collaborate with application developers, software testers, and project stakeholders on microservice based cloud applications in an agile team environment.
Research, design, document, test, and implement complex SQL and PL/SQL scripts
Ensure compliance with HIPAA regulations, industry best practices and technical requirements in all database-related activities.
Participate in Scrum events.
Hybrid – Candidate must be able to work 3 days onsite at 222 Jarvis St or 5700 Yonge St Toronto, OR 49 Place D'armes Kingston and 2 days remote
Must Haves:
5+ years’ experience using Oracle, SQL, PL/SQL.
Experience using Git.
Experience with data migration and data archiving techniques and strategies.
Experience with data modelling and UML.
Knowledge of record keeping techniques and data audit best practices.
Experience with Point in Time Architecture.
Experience troubleshooting coding and identifying/correcting database design flaws.
Experience identifying and implementing process optimization.
Collaborate with Agile team on microservice architecture systems.
Participate in Scrum events.
Knowledge of emerging Oracle features and industry trends.
Experience with Azure DevOps, Git.
Experience with PowerDesigner, Microsoft Office 365 suite, including Microsoft Teams and Microsoft Visio.
Knowledge of RESTful services, HTML, Java, object-oriented programming
Any Gradute