Database Analyst/Information Management Administrator

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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

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

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

 
Considered an Asset:
· Experience in Public Sector

About NTT DATA:

NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here . If you'd like more information on your EEO rights under the law, please click here . For Pay Transparency information, please click here .