Database Administrator

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**:

- Customize database conversion routines;
- Finalize Conversion Strategy;
- Generate new database;
- Maintain data dictionaries;
- Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database;
- Develop and implement security procedures for the database, including access and user account management;
- Advise programmers, analysts, and users about the efficient use of data;
- Maintain configuration control of the database;
- Perform and/or coordinate updates to the database design;
- Control and coordinate changes to the database, including the deletion of records, changes to the existing records, additions to the database;
- Perform code review on database Create, Read, Update and Delete (CRUD) activities to achieve optimal performance;
- Conduct database performance tests and activities as well as performance monitoring, report findings and propose solutions;
- Analyze database and document differences between databases COTS;
- Conduct database capacity planning, database design and migration;
- Conduct and review security and database authentication;
- Develop and document database installation and configuration and interact with system management team;
- Review and document data extraction, transformation, and loading (ETL) procedures;
- Perform database troubleshooting and document solution;
- Develop and coordinate back-up, disaster recovery and virus protection procedures; and
- Perform any other work related to this category.

**Qualifications**:

- 4+ years of recent experience with at least 5 of the following tasks:

- Backup and recovery strategy;
- System Integration: hardware and software, (COTS and/or custom developed) components into new or existing systems;
- Database architecture and system interfaces;
- System life-cycle management.
- Database capacity planning and performance evaluation;
- Extract Transform Load expertise;
- Database design.
- Experience in business process improvement and knowledge of business intelligence tool-sets;
- Experience developing or working with architectural concepts, strategies, roadmaps, reference architectures, architectural patterns, frameworks and principles;
- 2 years of recent experience preparing technical concept documents, system specifications, and technical proposals in the field of Information Technology / Information management or engineering (i.e., system, database audit, database backup and recovery, database evaluation, capacity planning) experience.
- 2 years of demonstrated experience in at least 3 of the following criteria:

- Communicating database installation and configuration;
- Ability to clearly communicate, in writing and orally;
- Working with multidisciplinary teams in the development of IT systems;

Additional Information

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.

Since being acquired by Commissionaires Ottawa, ADGA has adopted the social mandate of Commissionaires to create meaningful employment opportunities and generate financial resources for veterans of the CAF, RCMP, their families, and fellow citizens who share a passion to contribute to the security and well-being of Canadians.

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.

Depuis son acquisition par Les Commissionnaires Ottawa, ADGA a adopté le mandat social de Les Commissionnaires qui consiste à créer des possibilités d'emploi significatives et à générer des ressources financières pour les anciens combattants des FAC, de la GRC, leurs familles et leurs concitoyens qui partagent la passion de contribuer à la sécurité et au bien-être des Canadiens.

  • Database Administrator

    2 months ago

    Ottawa, Canada Cloudvital Technologies Full time

    **Job Title**: Database Administrator **Job Type**: Hybrid **Job Location**: Ottawa - **This is a Hybrid role with 3 days in office and 2 days remote**_ We are looking for Database Administrator for one of the fast-moving dynamic companies. **Required Skills**: - Strong experience with Postgres 9/10/11/12/13, Oracle 12/19. - 5+ years of experience in...

  • Database Administrator

    3 weeks ago

    Ottawa, Canada Targeted Talent Full time

    We are looking for an experienced Senior Database Administrator for our client. This is a permanent position that is remote to start with later relocation to Calgary or Winnipeg. Our client is a global enterprise company with a product that you've likely used.This position requires the ability to code as well as perform the duties of a database...

  • Database Administrator

    2 weeks ago

    Ottawa, Canada NSERC Full time

    **Database Administrator**: **Location of Position**: - Ottawa, ON**Job Status**: - Term appointment**Job Category**: - Information and Innovation Solutions /**Number of Positions Being Staffed**: - 2**Classification**: - GR-08**Security Clearance Required**: - Secret**Salary**: - $82,279 - $101,576 per year**Language Requirements**: - English or...

  • Database Administrator

    2 days ago

    Ottawa, Canada Distributel Full time

    Since 1988, Distributel, a division of Bell Canada, connects Canadians to the people, passion, and priorities that matter. By constantly challenging ourselves to simplify, add utility, and humanize the ways people do business with us, we will create a valuable experience for our customers in every way. Join an award-winning organization in its mission to...

  • Database Administrator

    4 days ago

    Ottawa, Ontario, Canada ADGA Group Consultants Inc Full time

    Company DescriptionOur 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...

  • Database Administrator

    4 days ago

    Ottawa, Ontario, Canada Distributel Full time

    Since 1988, Distributel, a division of Bell Canada, connects Canadians to the people, passion, and priorities that matter. By constantly challenging ourselves to simplify, add utility, and humanize the ways people do business with us, we will create a valuable experience for our customers in every way.Join an award-winning organization in its mission to...

  • SQL Database Administrator

    5 days ago

    Ottawa, Ontario, Canada CB Canada Full time

    Ref ID: Classification: Database AdministratorCompensation: $43.00 to $51.00 hourlyOur client is looking for a database administrator with knowledge of databases who can fix the data corruption issues that are behind many of the issues with the calculator.Job Description•Provide database monitoring and support for mission-critical...

  • Junior Database Administrator

    4 weeks ago

    Ottawa, Canada Liberal Party of Canada Full time

    **Location**: Ottawa, ON HQ - On-site **Reports To**: Senior Director of Legal Affairs & Party Services **Summary**: If you enjoy working in the dynamic, fast-paced environment of elections and nominations while handling various projects with multiple stakeholders and bring your expertise in data administration and management, this is an amazing...

  • Junior Database Administrator

    2 months ago

    Ottawa, Canada Liberal Party of Canada Full time

    **Location** Ottawa, ON HQ - On-site **Reports to** Senior Director of Legal Affairs & Party Services **Summary** **If you enjoy working in the dynamic, fast-paced environment of elections and nominations while handling various projects with multiple stakeholders and bring your expertise in data administration and management, this is an amazing...

  • Oracle Database Administrator

    2 months ago

    Ottawa, Canada ADGA Group Consultants Inc Full time

    Company Description **Job Description**: Within this role, the Oracle Database Administrator will perform the following tasks in support of Oracle Enterprise Server and Systems Management, including, but not limited to: - The provision of guidance to MCSC team members on applicable techniques as well as existing coding structures in programming and program...

  • Oracle Database Administrator

    4 days ago

    Ottawa, Ontario, Canada ADGA Group Consultants Inc Full time

    Company DescriptionJob Description:Within this role, the Oracle Database Administrator will perform the following tasks in support of Oracle Enterprise Server and Systems Management, including, but not limited to:The provision of guidance to MCSC team members on applicable techniques as well as existing coding structures in programming and program coding;...

  • Cloud Database Administrator

    2 months ago

    Ottawa, Canada Thales DIS CPL Canada, Inc Full time

    Location: Ottawa, Canada Thales people architect identity management and data protection solutions at the heart of digital security. Business and governments rely on us to bring trust to the billons of digital interactions they have with people. Our technologies and services help banks exchange funds, people cross borders, energy become smarter and much...

  • Database Team Lead

    4 weeks ago

    Ottawa, Canada Canadian Bank Note Company, Limited Full time

    **Internal Job Title**:Database Team Lead **Job Type**:Permanent Full-Time **Location**: 18 Auriga Dr, Ottawa ON **Work Model**:Hybrid **Position Summary** As the Database Team Lead in our corporate Information Services department, you will be responsible for leading the daily management of corporate database platforms, including Microsoft SQL Server,...

  • Intermediate Database Administrator

    2 months 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...

  • Intermediate Database Administrator

    5 days ago

    Ottawa, Ontario, Canada ADGA Group Consultants Inc Full time

    Company DescriptionOur 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...

  • database analyst

    7 days ago

    Ottawa, Canada 8084947 CANADA INCORPORATED Full time

    Education: Bachelor's degreeExperience: 2 years to less than 3 yearsTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesLead and co-ordinate teams of data...

  • Database Administrator Level 3

    4 days ago

    Ottawa, Ontario, Canada Renaud Consulting IMIT Solutions Full time

    Description: Responsibilities ·TheContractor'sresourcesmayberequired,butarenotlimitedto,toperformthefollowing: ·Providedatabasesupportanddatabaseadministrationtasksonprojectsandoperations,ConfigureandoptimizetheOracle12cinfrastructure, ·Performnecessaryoptimizationstothedatabaseenvironment,investigateandresolvedatabaseperformanceproblems, ...

  • database analyst

    5 days ago

    Ottawa, Ontario, Canada 8084947 CANADA INCORPORATED Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesLead and co-ordinate teams of data administrators in...

  • database analyst

    5 days ago

    Ottawa, Canada 8084947 CANADA INCORPORATED Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesLead and co-ordinate teams of data administrators in...

  • Database Analyst

    4 weeks ago

    Ottawa, Canada The Royal Ottawa Mental Health Centre Full time

    **Position Information** **Posting Number**: - ROM23-054E**Title**: - Database Analyst (TFT 1.0 FTE)**Position Status**: - Temporary Full-time**Contract End Date**: - 03/31/2024**FTE**: - 1.0**Job Schedule**: - Days**Department**: - Data & Analytics**Union**: - Non-union**Site**: - Royal Ottawa Mental Health Centre**About The Royal** - As one of...