Database Administrator

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.