Tasks may include but are not limited to the following:

Define and Design New Database Structures:

• Develop database schema and structures in Oracle hosted on AWS or Azure ensuring alignment with FSIR project requirements.
• Create tables, relationships, and indexes to accommodate SIN data and ensure scalability for future needs.

Develop Data Conversion Strategies:

• Define a comprehensive strategy for migrating data from legacy systems to AWS-hosted Oracle databases.
• Develop database conversion specifications to ensure data consistency, accuracy, and minimal downtime during migration.

Data Cleansing and Preparation:

• Identify and resolve issues such as duplicate records, inconsistencies, and outdated data during the cleansing process.
• Collaborate with stakeholders to validate and approve data migration plans and procedures.

Implement and Maintain Database Accuracy and Timeliness:

• Develop automated procedures for regular data validation and updates, ensuring the accuracy and integrity of SIN data.
• Establish monitoring mechanisms to ensure data availability and timeliness for operational and analytical use cases.

Enhance and Optimize Existing Database Systems:

• Analyze current SIN database systems and recommend improvements to enhance performance, security, and scalability.
• Integrate modern data storage solutions, including data lakes and connectors, to meet FSIR requirements.

Develop and Enforce Security Protocols:

• Collaborate with security teams to implement tokenization and encryption for sensitive SIN data.
• Establish robust access controls and auditing mechanisms to safeguard data integrity and compliance with Government of Canada policies.

Support Database Integration:

• Work closely with application developers and architects to ensure seamless integration between frontend systems and backend databases.
• Define and document APIs for secure data access and validation across systems.

Collaborate with Users and Stakeholders:

• Conduct workshops and one-on-one sessions with users to understand their database requirements and address performance concerns.
• Mediate and resolve conflicts between data use cases to ensure alignment with project goals.

Knowledge Transfer and Coaching:

• Provide training and coaching to FSIR team members on database architecture, management, and best practices.
• Document all procedures, conversion strategies, and maintenance protocols for future use.

Mandatory Qualifications:

10+ years experience within the last ten (15) years as an Database Analyst/Information Management Administrator

• define new database structures;
• define data conversion Strategy;
• define database conversion specifications;
• finalize conversion Strategy;
• Work very closely with the users to maintain and safeguard the database;
• identify requirements for improvements to existing databases by determining users’ information requirements and system performance and functional requirements;
• develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database;
• mediates and resolves conflicts among users’ needs for data;
• advise programmers, analysts, and users about the efficient use of data; and
• conduct knowledge transfer and coaching of the team members.

One (1) projects with a minimum duration of four (4) consecutive months within the 7 last years:

• Expertise in Oracle database management and optimization.
• Proficiency in advanced SQL query development.
• Knowledge of data migration strategies and tools, including ETL processes and frameworks.
• Experience with data security protocols, including tokenization, encryption, and role-based access control.
• Implementation of Data lakes on AWS or Azure
• Familiarity with data lake solutions and connectors for scalable data storage and analytics.
• Strong understanding of legacy database systems and conversion to modern environments.
• Experience using tools like ERwin Data Modeler, SQL Plus, and other data modeling and management software.
• Ability to work collaboratively in Agile teams and leverage tools like Azure DevOps for task tracking and sprint planning.

University degree or college/CEGEP Diploma related to computer science, information technology, or engineering from a Canadian post-secondary institution, or the equivalent as established by a recognized Canadian academic credentials assessment service, if obtained outside Canada. A copy of the degree, diploma or equivalency must be provided.

Please refer the Job description for details