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.



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


  • Ottawa, Canada Myticas Consulting ULC Full time

    **Database Administrator** **Format**:Contract **Term**:6 Months **Responsibilities**: Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and...


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

  • Database Administrator Level 3

    Found in: Talent CA C2 - 2 weeks ago


    Ottawa, Canada Renaud Consulting IMIT Solutions Full time

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


  • Ottawa, Canada Community Navigation of Eastern Ontario Full time

    Make lives better by connecting the community to the resources they need. Every day. The Community Navigation of Eastern Ontario (CNEO) is a non-profit, bilingual organization that helps to connect people through multilingual mediated access to community, social, health and government services in their community. CNEO has been operating 211 Services in...


  • Ottawa, Canada S I Systems Full time

    Sr. Database Administrator to work with MongoDB for large insurance client - 5003 Job Type: Contract Positions to fill: 1 Start Date: May 20, 2024 Job End Date: May 16, 2025 Pay Rate: Hourly: Negotiable Job ID: 137251 Sr. Database Administrator to work with MongoDB for large insurance client - 5003Duration: 1 year (possibility of extension)Location:...


  • Ottawa, Canada S I Systems Full time

    Sr. Database Administrator to work with MongoDB for large insurance client - 5003 Job Type: Contract Positions to fill: 1 Start Date: May 20, 2024 Job End Date: May 16, 2025 Pay Rate: Hourly: Negotiable Job ID: 137251 Sr. Database Administrator to work with MongoDB for large insurance client - 5003Duration: 1 year (possibility of extension)Location:...


  • Ottawa, Canada S I Systems Full time

    Sr. Database Administrator to work with MongoDB for large insurance client - 5003 Job Type: Contract Positions to fill: 1 Start Date: May 20, 2024 Job End Date: May 16, 2025 Pay Rate: Hourly: Negotiable Job ID: 137251 Sr. Database Administrator to work with MongoDB for large insurance client - 5003Duration: 1 year (possibility of extension)Location:...

  • Database Implementation Consultant

    Found in: Jooble CA O C2 - 2 weeks ago


    Ottawa, ON, Canada Adecco Canada Full time

    ServiceNow CMBD Technical Advisor Adecco is currently recruiting for a ServiceNow CMBD Technical Advisor for a 1-year hybrid contract opportunity. This role is with our Crown corporation client in downtown Ottawa, ON. The ServiceNow CMBD Technical Advisor will have the following responsibilities: Perform ServiceNow Configuration Management Database...


  • Ottawa, Canada Ottawa Centre for Cognitive Therapy Full time

    The Ottawa Centre for Cognitive Therapy (OCCT) is seeking a full-time Administrative Assistant. **Please submit a resume AND cover letter to be considered.** **Overview** **Responsibilities** - Scheduling both in-person and remote appointments for a team of 13 clinicians, considering specific scheduling preferences - Billing and collecting payment from...


  • Ottawa, Canada exp Full time

    Are you ready to design your future? Be our next **Contract Administrator!** **Your work environment at EXP** In this role, you will join our team based in **Ottawa **office. - Perform standard administrative functions - Edit, construct and format reports, proposals and other technical documents - Review Proposals, Standing offer agreements and Draft...


  • Ottawa, Canada Carleton University Full time

    **Duties and Responsibilities**: The Departmental Administrator reports to, consults with, and provides administrative support to the Chair, and implements operational needs and goals as communicated by the Chair. The primary responsibilities include: (i) overseeing and coordinating the unit’s day-to-day administrative functions which includes office,...


  • Ottawa, Canada Blyth Academy Full time

    **Responsibilities** - Monitoring attendance and notifying families of late or absent students - Entering and maintaining accurate information in various databases and Student Information Systems - Assisting in planning school events such as Parent Teacher Interviews, Open Houses, and Graduation - Taking inventory of office/classroom supplies and placing...

  • Campus Administrator

    3 weeks ago


    Ottawa, Canada Blyth Academy Full time

    **Responsibilities** - Monitoring attendance and notifying families of late or absent students - Entering and maintaining accurate information in various databases and Student Information Systems - Assisting in planning school events such as Parent Teacher Interviews, Open Houses, and Graduation - Taking inventory of office/classroom supplies and placing...

  • Administrative Assistants

    Found in: Talent CA 2 C2 - 2 weeks ago


    Ottawa, Canada CB Canada Full time

    Company DescriptionFounded in 1967, ADGA is a privately owned and operated Canadian company. We employ over 700 highly skilled team members who apply their knowledge and expertise in service delivery of advanced technology solutions for clients in the Defence, Security and Enterprise Computing markets across Canada.Celebrating over 50 years in business, we...


  • Ottawa, Canada Ottawa Centre for Cognitive Therapy Full time

    The Ottawa Centre for Cognitive Therapy (OCCT) is seeking a full-time Administrative Assistant. **Please submit a resume AND cover letter to be considered.** **Overview** **Responsibilities** - Scheduling both in-person and remote appointments for a team of 13 clinicians, considering specific scheduling preferences - Billing and collecting payment from...

  • Administrative Assistant

    Found in: Talent CA C2 - 2 weeks ago


    Ottawa, Canada EXP Full time

    Contract Administrator Ottawa, ON   Are you ready to design your future? Be our next  Contract Administrator! Your work environment at EXP In this role, you will join our team based in the Ottawa, ON office. Perform standard administrative functions Edit, construct and format reports, proposals and other technical documents Review...


  • Ottawa, Canada TK Elevator Canada Ltd Full time

    The company **What we expect**: **Your responsibilities** - Perform administrative duties on behalf of the branch - Manage front reception responsibilities - Respond to customer inquiries and/or redirect to appropriate department - Perform AP duties - Perform administrative tasks associated with the processing of weekly payroll for the entire branch -...


  • Ottawa, Canada CVE Inc. Full time

    **Company Profile**: **CVE Inc. Career and Vocational Evaluation **has been providing unparalleled services to the disability community, employers, insurance providers, worker compensation boards, and government ministries since 1993. We specialize in providing employment, disability and claims management services necessary to either resolve disability...


  • Ottawa, Canada COMsolve Inc. Full time

    System Administrator / Developer for the Canadian Numbering Administrator - an undergraduate degree in computer science and 2 years of practical work experience; - a college program diploma in Information technology/computer systems technology and 2 years of practical work experience; or - equivalent practical work experience. Mandatory skills include: -...