Database Modeler

2 weeks ago

Ottawa, Canada ADGA Group Consultants Inc Full time

Company Description

Our culture of commitment, trust, and accountability guides our business, fosters our growth, and is at the core of our relationships with clients, employees and consultants. Whether your projects are complex, large-scale requirements, or dependable, professional resources to execute on time, and on budget, you can count on ADGA to deliver. We are dedicated to your success.

**Job Description**:
**Tasks**:

- Design, implement and maintain various INAC Oracle database systems;
- Install Oracle Database software and tools;
- Create and configure Oracle databases;
- Configure and implement Oracle databases in support of Commercial Off The Shelf software implementations;
- Maintain configuration control of the databases;
- Develop and coordinate backup and disaster recovery procedures;
- Develop and implement security procedures for the databases, including access and user account management;
- Upgrade and patch Oracle Software;
- Define, develop, test, and implement data conversion/load/migration strategies and specifications;
- Review, analyze, and resolve INAC representatives and/or other contractor resources’ (Web Developers, Programmer/Analysts and others at various levels) database requests sent daily to the Database Services mailbox;
- Analyze proposed changes to existing databases and impact on data models and update data models in Erwin;
- Provide assistance to INAC representatives and/other contractor resources (Business and System Analysts, Web Developers, Programmer/Analysts and others at various levels) relating to data issues and data analysis concepts.

**Deliverables**:

- Logical and Physical data models are stored in Erwin;
- Database conversion specifications are saved under the Database Support folder in GCdocs;
- Database backups are made available to the database group (INAC representatives, contractor resources (Database Administrators and Database Analyst at various levels)) when require for restore and are saved as per INAC database backup procedures;
- RFC database changes in production are documented and are saved under the Projects folder on the Database group shared drive;
- Completed database scripts are available to the database group (INAC representatives, contractor resources (Database Administrators and, Database Analysts at various levels)) and are saved under the Projects folder on the Database group shared drive;
- Oracle database software and instance installation, upgrade, or migration procedure and status are saved where appropriate under the Database Support folder in GCdocs;
- Client database requests are documented in Helix ALM Client;

**Qualifications**:

- Minimum 10 years of experience in the past 15 years designing, developing and maintaining logical and physical data models for databases with a minimum of 100 users.
- Minimum 10 years of experience in the design, development and maintenance of data models in OLTP (on-line transaction processing) environments.
- Worked on a minimum of two IT projects for Government or private sector in defining, developing, testing, and implementing data conversion/load/migration strategies and specifications.
- Minimum 5 years of experience leading, assigning work packages and mentoring junior and intermediate level Database Modelers.
- Minimum 5 years of experience writing Structured Query Language (SQL) in an Oracle database (10g, 11g, 12c and higher versions) or MS SQL Server (version 2008 and higher versions) environment.

Additional Information
**Location of Work**:The work will be performed mainly via telework, but work may be performed on premises located throughout the National Capital Region (NCR).

**Security Clearance**:Enhanced Reliability

ADGA commits to putting diversity into action to build a stronger, more representative team and help our customers and communities thrive. We are a proudly Canadian company, striving to further diversity, equity, and inclusion in the workplace and provide every individual with the opportunities and resources to help them reach their full potential.

ADGA s'engage à mettre la diversité en action pour bâtir une équipe plus forte et plus représentative et aider nos clients et nos communautés à prospérer. Nous sommes une entreprise fièrement canadienne. Nous nous engageons pour promouvoir la diversité, l'équité et l'inclusion dans le milieu de travail et d'offrir à chaque personne les possibilités et les ressources qui lui permettront de réaliser son plein potentiel.

  • Database Modeler/information Management Modeler

    4 weeks ago

    Ottawa, Canada Maplesoft Group Full time

    Maplesoft Group is currently seeking a Database Modeler/Information Management Modeler - Level 2 for our Federal Government client. The following responsibilities are associated with the “Statement of Work” but are not limited to: Primary Responsibilities - The Data Architect has both strategic and tactical responsibility for developing and maintaining...

  • Data Modeler

    2 weeks ago

    Ottawa, Canada CGI Full time

    Position Description: Security clearance: Must be able to meet the requirements for obtaining a secret level clearance. Your future duties and responsibilities: Data Modeling and Database Design - Proficiency in conceptual, logical, and physical data modeling. Translate business requirements into comprehensive data models ensuring scalability,...

  • Data Modeler

    5 days ago

    Ottawa, Canada Maplesoft Group Full time

    Maplesoft Group is currently seeking a Data Modeler for our Federal Government client. The following responsibilities are associated with the “Statement of Work” but are not limited to: Primary Responsibilities Under the direction of the Assistant Director, ITS Data Operations: - Assist with creation of Conceptual/Logical/Physical Models for data...

  • Computational Modeler

    4 weeks ago

    Ottawa, Canada Geofirma Engineering Ltd. Full time

    Geofirma Engineering Ltd. is looking for a computational modeler to join our team working on groundwater flow, contaminant transport, and geomechanics. You would be joining a team of experienced professionals who conduct leading-edge modelling for radioactive waste management, carbon sequestration, energy storage, and other significant subsurface activities....

  • Database Analyst

    1 week ago

    Ottawa, Canada RealDecoy Full time

    **To qualify, you**: - **Must be able to obtain and maintain a valid Canadian Security Clearance at the level of SECRET; and**: - **Must be a citizen of Canada.** - Must hold a Bachelor’s degree in Computer Science. - Must have a minimum of 3 years’ experience within the last five (5) years: As a Database Analyst/Information Management...

  • Senior Data Modeling Architect

    7 days ago

    Ottawa, ON, Canada S.i. Systems Full time

    Senior Data Engineer Job Description: Our public sector client is looking for a Senior Data Engineer to develop data connections and processes for data models within an existing data infrastructure. Our client is modernizing its IM/IT environment to support digital operations and enable technology excellence in service to Canadians. There is a requirement...

  • Full-time Advancement Database and Financial Officer

    5 days ago

    Ottawa, Canada Algonquin College Full time

    Department: Advancement Services (Nadia Greco) Position Type: Full-Time Support Salary Range: $32.42-$37.57-Hourly Scheduled Weekly Hours: 36.25 Anticipated Start Date: May 13, 2024 Length of Contract: NA Posting Information Support Staff employees, as defined by the full-time Support Staff Collective Agreement, will be given first...

  • Senior Data Engineer to develop data connections and processes for data models within an existi[...]

    1 week ago

    Ottawa, Canada S.i. Systems Full time

    Senior Data Engineer Job Description: Our public sector client is looking for a Senior Data Engineer to develop data connections and processes for data models within an existing data infrastructure. Our client is modernizing its IM/IT environment to support digital operations and enable technology excellence in service to Canadians. There is a requirement to...

  • Senior Data Engineer to develop data connections and processes for data models within an existi[...]

    2 days ago

    Ottawa, Canada S.i. Systems Full time

    Senior Data Engineer Job Description: Our public sector client is looking for a Senior Data Engineer to develop data connections and processes for data models within an existing data infrastructure. Our client is modernizing its IM/IT environment to support digital operations and enable technology excellence in service to Canadians. There is a requirement to...

  • Senior Data Engineer to develop data connections and processes for data models within an existi[...]

    4 weeks ago

    Ottawa, Canada S.i. Systems Full time

    Senior Data Engineer Job Description: Our public sector client is looking for a Senior Data Engineer to develop data connections and processes for data models within an existing data infrastructure. Our client is modernizing its IM/IT environment to support digital operations and enable technology excellence in service to Canadians. There is a requirement to...

  • Senior Data Engineer to develop data connections and processes for data models within an existi[...]

    1 week ago

    Ottawa, Canada S.i. Systems Full time

    Senior Data Engineer Job Description: Our public sector client is looking for a Senior Data Engineer to develop data connections and processes for data models within an existing data infrastructure. Our client is modernizing its IM/IT environment to support digital operations and enable technology excellence in service to Canadians. There is a requirement to...

  • Senior Data Engineer to develop data connections and processes for data models within an existi[...]

    7 days ago

    Ottawa, ON, Canada S.i. Systems Full time

    Senior Data Engineer Job Description: Our public sector client is looking for a Senior Data Engineer to develop data connections and processes for data models within an existing data infrastructure. Our client is modernizing its IM/IT environment to support digital operations and enable technology excellence in service to Canadians. There is a requirement...

  • Data Architect

    3 weeks ago

    Ottawa, Canada Talasoft Full time

    Responsibilities may encompass, but are not restricted to: Collaborate closely with internal and external stakeholders, including Business, IITB, and System Integrators, to comprehend data requirements and use cases. In conjunction with Enterprise Architecture, craft, oversee, and maintain architectures for data management services and solutions. Provide...

  • Data Architect

    4 weeks ago

    Ottawa, Canada Talasoft Full time

    Responsibilities may encompass, but are not restricted to: Collaborate closely with internal and external stakeholders, including Business, IITB, and System Integrators, to comprehend data requirements and use cases. In conjunction with Enterprise Architecture, craft, oversee, and maintain architectures for data management services and solutions. Provide...

  • Data Architect

    3 weeks ago

    Ottawa, Canada Talasoft Full time

    Responsibilities may encompass, but are not restricted to: Collaborate closely with internal and external stakeholders, including Business, IITB, and System Integrators, to comprehend data requirements and use cases. In conjunction with Enterprise Architecture, craft, oversee, and maintain architectures for data management services and solutions. Provide...

  • Spatial Analyst

    4 weeks ago

    Ottawa, Canada Canadian Wildlife Federation Full time

    **_Your Connection to Wildlife_**: - As one of Canada’s largest not for profit leaders in wildlife conservation, research, and advocacy, we are seeking to fill the following position..._ **Spatial Analyst** **Location**: CWF's Head Office in Ottawa, ON. **Reports to**: Senior Spatial Ecologist **Fixed-term** for 1-year **Who we are** The Canadian...

  • SAP BI Data Architect

    4 weeks ago

    Ottawa, ON, Canada Talasoft Full time

    Collaborate closely with internal and external stakeholders, including Business, IITB, and System Integrators, to comprehend data requirements and use cases. In conjunction with Enterprise Architecture, craft, oversee, and maintain architectures for data management services and solutions. Provide advanced expertise in data architecture, encompassing...

  • Data Integration Analyst

    1 week ago

    Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    Poste chez Canadian Medical Protective Association • DATA INTEGRATION ANALYSTCONTRIBUTING TO THE CMPAActuarial Services supports the CMPA's mission and goals through proper valuation of the Association's liabilities. This is accomplished through detailed actuarial work following the Standards of Practice set by Canadian Institute of Actuaries. The...

  • Data Integration Analyst

    1 week ago

    Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    Position at Canadian Medical Protective Association • DATA INTEGRATION ANALYSTCONTRIBUTING TO THE CMPAActuarial Services supports the CMPA's mission and goals through proper valuation of the Association's liabilities. This is accomplished through detailed actuarial work following the Standards of Practice set by Canadian Institute of Actuaries. The...

  • Data Architect

    4 weeks ago

    Ottawa, ON, Canada Talasoft Full time

    Responsibilities may encompass, but are not restricted to: Collaborate closely with internal and external stakeholders, including Business, IITB, and System Integrators, to comprehend data requirements and use cases. In conjunction with Enterprise Architecture, craft, oversee, and maintain architectures for data management services and solutions. ...