Senior Database Administrator to support the modernization projects as well as the maintenance of its legacy systems in the public sector.
3 months 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 public sector client is hiring a Senior Test Manager to provide testing oversight and to validate test results on an SAP project.Background:The initiative is a key component of the ongoing program to improve effectiveness and efficiency of the Logistics within the organizations Supply Chain. As part of this modernization, it will integrate functionality...
-
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: ...
-
Senior Database Administrator
3 weeks ago
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires a Reliability cleared Senior Database Administrator (Oracle) to prepare infrastructure for the upcoming cloud transformation and improve maintenance efficiency. The client require Database Administrator support services for Oracle environment for in-operations while adhering to the SDLC best practices. Responsibilities:...
-
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 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 Network Architect to lead large network modernization initiative. The network was designed and implemented over a decade ago. Over the years, the network has become increasing complex and difficult to manage, given the numerous technology changes, adaptations and additions. The Network Modernization project...
-
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...
-
Senior Database Administrator
3 weeks ago
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires a Reliability cleared Senior Database Administrator (MS SQL Server) to prepare infrastructure for the upcoming cloud transformation and improve maintenance efficiency. The client require Database Administrator support services for MS SQL environment for in-operations while adhering to the SDLC best practices. ...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued public sector client is seeking a Senior Cloud Architect to develop infrastructure architecture with SAP experience.Background:The organization is in the process of selecting a cloud product (Azure or AWS) to host its SAP system and sub-systems. The required consultant will assist in establishing a design which features a cloud to ground...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeS.i. Systems' valued public sector client is building a pool of Senior Organizational Development Consultants to work on an as-needed basis over the next 4+ years, primarily in providing advice and guidance on Human Resourcing strategies for a public sector Real Property organization. Three years ago, the Client assumed real property custodial...
-
Senior Architect
3 months ago
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued public sector client is in need of a Senior Azure Synapse Architect to identify Cloud (Azure) solutions to support the implementation of new intelligence systems. Project Description: This project is supporting a IM/IT strategic plan to implement new cloud solutions across the organization for many intelligence systems. Responsibilities: ...
