Senior Database Administrator to support the modernization projects as well as the maintenance of its legacy systems in the public sector.
1 month ago
Responsibilities:
a. Develop, customize and implement data conversion procedures which extract, transform and load data from source systems to a data warehouse.
b. Generate new databases with the client.
c. Maintain data dictionaries.
d. Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database.
e. Develop and implement security procedures for the database, including access and user account management.
f. Advise programmers, analysts, and users about the efficient use of data.
g. Maintain configuration control of the database.
h. Perform and/or coordinate updates to the database design.
i. Control and coordinate changes to the database, including the deletion of records, changes to the existing records, additions to the database.
j. Develop and coordinate back-up, disaster recovery and virus protection procedures.
k. Monitor system performance and identify problems that arise.
l. Perform problem investigation and resolution, and provide support for applications and developers.
m. Report on metrics regarding usage and performance.
Must Have:
- Experience controlling and coordinating changes to RDBMS databases
- Experience working within an RDBMS database on a UNIX/Linux environment developing release packages
- Experience developing and maintaining Extract Transform Load (ETL) scripts.
- Experience identifying, investigating and resolving problems with data retrieval and design
Nice to Have: Apply
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Database Modeller / IM Modeller to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Design, develop and maintain Logical Data Models. b. Analyze proposed changes to databases from the context of the Logical...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Business Analyst to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilites: a. Evaluate existing procedures and methods, identify and document items such as database content, structure, and application subsystems. b....
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Application/Software Architect to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Perform application integration, maintenance, upgrades, and migration. b. Run diagnostic tests and perform debugging...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior MS Dynamics Developer to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Lead a team of Programmer Analysts and provide guidance, advice and assign tasks. b. Translate functional and business requirements...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Technology Architect to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Develop and manage technology roadmaps for current and future systems. b. Develop technical architectures, frameworks and strategies,...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Project Manager to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Provide subject matter expertise in the areas of Risk Management, Integration Management, Change Management, Planning and Scheduling,...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Intermediate MS Dynamics Developer to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilites: a. Translate functional and business requirements into technical requirements and design specifications. b. Participate in...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Quality Assurance Tester to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Develop the test strategy and Master Test Plans. b. Develop test scenarios and test scripts. c. Lead testing efforts as defined...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued public sector client is hiring a Senior Data Management Specialist to plan, convert, and migrate data on an SAP project.Background:The supply chain project is integrating SAP IBP into their environment which is a cloud-based solution. The organization's data currently resides on-prem as part of the legacy DRP application which is reaching its...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued public sector client is in need of a Secret cleared, Senior Security Analyst to modernize the departmental IT security program in the public sector and provide surge capacity in various areas related to IT security services delivery, such as security assessment of systems and projects, and risk management. Tasks and Deliverables: ...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector Client is looking for a Senior Project Manager to support the Workplace Collaboration Services (WCS) Project. Scope: Development, procurement, and transition to an enterprise Workplace Communication Service providing: The WCS IP Telephony solution was developed as a planned replacement for the SSC Partner departments’ telephone...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector Client is looking for a Senior Secret Cleared Project Manager to support the Network/Email Modernization to support multiple departments and agencies within the Public Sector The Project Management and Delivery Branch (PM&D) is responsible for providing various Departments and Agencies with a bundle of the client's network,...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued public sector client is seeking to hire a Senior Security Engineer to lead and provide guidance for a cryptographic modernization initiative. Background: The Cryptographic Modernization Project (CMP) is an Omnibus project that has been replacing High Assurance End Cryptographic Units (ECU) in the organization's inventory with modernized...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector client is looking for a Senior Business Transformation Architect to support software solution modernization.The client's IM/IT sector is working in close partnership with the supervision sector to advance its transformation agenda in order to modernize its business operations and service delivery mode, with a goal of...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector client requires a Senior Database Modeler to support the data repository and reporting development for a Network Support modernization project.The Database Modeler has both strategic and tactical responsibility for developing and maintaining the Architecture and Data Models for corporate and project specific initiatives. This...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector Client is looking for a Senior Secret cleared Business Consultant to support the Workplace Collaboration Services (WCS) Project. The WCS project will transition up to 75,000 legacy lines to the new fully managed VoIP service valued at over $176M. The high-level target business outcomes are: Reduced monthly operational telephony...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector client requires a Senior Database Modeler to support the data repository and reporting development for a Network Support modernization project.The Database Modeler/Information Management Modeler has both strategic and tactical responsibility for analyzing, designing and developing the Architecture and Data Models for a DataMart and...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector client is seeking a Senior Project Manager to lead the modernization of their Grants and Contributions Information Management System (GCIMS).The work will serve to provide information required for advancement of project approvals through the PHAC/HC Investment planning, project governance/gating and IT gating processes. The resource...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client is hiring a Senior Test Manager to provide testing oversight and to validate test results on an SAP project.Background:The Modernization and Integration of Sustainment and Logistics project is entering its testing phase. The project is part of a large SAP modernization initiative which will improve the organizations ability to track...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires a Senior Java Developer to support the implementation of several incident management response initiatives. Responsibilities:Write software in a Linux and MS Windows development environmentPerform programming in Java, Python and JavaScript (React) to develop and transition new or extend existing modulesPerform UX design...
