Current jobs related to Sr Secret Cleared Oracle DBA to develop database changes for a large pensions initiative - Ottawa Ontario HB, Montréal - S I Systems


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our 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 time

    Our valued public sector client is currently seeking a Senior Secret Cleared Change Manager to Assist on Multiple IM/IT Implementation Projects that are ongoing within their department. The Successful Candidate Must Have: 10 years within the past 15 experience as a change management consultant where you were responsible for analyzing and developing...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued public sector client is currently seeking a Senior Secret Cleared Technology Architect to develop technical architectures, frameworks and strategies. This is an exciting project that is set to enable departments to transition to a more digital goverament in order to improve citizen service. It involves developing solutions with departments and...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued Defence client is seeking a Senior Top-Secret Cleared Technical Architect for an initial 1-year contract (possibility for a total duration of 5 years) in Ottawa, ON As the successful candidate you will lead the development of Architecture and Design documentation to provide the client with critical capabilities to effectively conduct classified...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued Public Sector Client is seeking a Senior Secret Cleared Business Process Specialist to Lead Table-Top exercises (TTX) on a large modernization initiative Job Description:Our client has a need to build a service line that would offer Table-Top exercise services to the entire cyber security division. This creates an opportunity to simulate...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our Valued Public Sector Client is seeking the services of a Senior Secret Cleared Security Architect to assist in building a new Targeted Enterprise Architecture (TEA) on a large Business Transformation initiative within the Public Sector The Business Transformation team is working on building a new targeted enterprise architecture (TEA) that will respond...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued Public Sector Client requires a Senior Secret Cleared Project Manager to provide support on multiple on-going large-scale Cyber Security and Cloud Transformation initiatives within the Public Sector The resource will be working on all aspects of the business required to deliver on the client's Cyber Security and Cloud Operations mandate for...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued defence client is seeking a Senior Business Analyst for an initial contract until March 31, 2025. As the successful candidate you will support the modernization of the Naval Training System (NTS) through digital integration, enhancing the existing ecosystem for naval training with a cutting-edge software package, including improvements to the...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued public sector client is seeking a Senior Secret Cleared Project Manager to manage the improvement of cyber security and IT security Our client’s Project Management and Delivery division is responsible for providing strategic guidance on cyber security; integrating with areas of risk management, information security, policy, and technical support...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our Valued Public Sector client is in need of a Senior, Secret Cleared Storage and Backup Systems Administrator (10+ years) to work alongside technical analysts and advisors to execute operational projects and ensure IT solutions are deployed and documented expediently. The Storage and Backup Operations Group within Shared Services Canada is responsible for...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued defence client is seeking a Senior Technical Architect for an initial contract until March 31, 2025. As the successful candidate you will support the modernization of the Naval Training System (NTS) through digital integration, enhancing the existing ecosystem for naval training with a cutting-edge software package, including improvements to the...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued public sector client is currently seeking a senior secret cleared web multi-media content consultant to develop interactive prototypes and content diagrams for usability testing and presentations. This is an exciting project that is set to enable departments to transition to a more digital goverament in order to improve citizen service. It...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our Valued Public Sector Client is seeking a Senior Change Manager to create a Benefits Realization Plan for a large HR modernization initiativeThe client's vision is to have a User-centric, Seamless, Digital and inclusive HR Service. The consolidation of the HR Peoplesoft system is also required for a major Offboarding project. Overall, The goal is to...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued Public Sector client requires a Senior Change Manager to develop strategy, plan, and approach to assist users with the launch of a new platform. The large-scale transformation is set to launch on the new platform in December 2024. The transition to the new system necessarily introduces changes to individuals and teams who are directly or...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued defence client is seeking a Senior Business Analyst for an initial contract until March 31, 2025. As the successful candidate you will support the modernization of the Naval Training System (NTS) through digital integration, enhancing the existing ecosystem for naval training with a cutting-edge software package, including improvements to the...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued public sector client is currently seeking a Senior Secret Cleared Project Manager to support the full life cycle of a digital government transformation. This is an exciting project that is set to enable departments to transition to a more digital government in order to improve citizen service. It involves developing solutions with departments...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued public sector client is looking for a Sr Business Analyst (Secret cleared) to support an App Dev project on an Agile environment.The successful candidate will play a crucial role in the LaunchARP (Air Readiness and Performance) project by analyzing client requirements and developing user stories that accurately capture these requirements. This...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued public sector clients are looking for a Secret Cleared Senior Business Process Consultant (10+ years) to provide recommendations on process optimization in enhancing service delivery within the public sector. The teams clients currently have demands that exceed their ability to deliver. They are in need of a Business Process Consultant to work...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

    Our valued public sector client is looking to hire a Sr Gateway Architect (Secret Cleared) to develop the System Implementation Plan, Life Cycle Support Plan, SOP, CONOPS for a federal govt clientBackground:Within DND, the various classified systems range from Secret and above. Each of these systems provides nearly identical services and each has an...


  • Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full time

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

Sr Secret Cleared Oracle DBA to develop database changes for a large pensions initiative

3 months ago


Ottawa Ontario HB, Montréal, Canada S I Systems Full time
Sr Secret Cleared Oracle DBA to develop database changes for a large pensions initiative

Our valued Public Sector client requires a Senior Secret Cleared Oracle DBA to develop database changes for a large pensions initiative.

The resource will work with the project development team and the data modeler to develop the required database changes needed to support the database enhancement project.

Must haves:

  1. Experience exporting/importing Oracle Schemas
  2. Experience in query performance tuning activities (Explain plans, InitTrans, etc.)
  3. Experience DB setup and platform tuning (SGA, Shared Memory, Huge Pages, etc.)
  4. Experience generating and interpreting Automatic Workload Repository (AWR) reports

Tasks:

  1. Support the ETL and warehouse Services group to deliver the reporting solution on an Oracle database.
  2. Support for evolving business requirements and emerging priorities.
  3. Design, Development, and testing of scripts.
  4. Define technical requirements, technical design, data architecture, data flow from sources, through to integration into target Oracle databases.
  5. Developing functions, stored procedures, and packages.
  6. Prepare ETL target data mapping and specification documentation.
  7. Test and implement processes for the new data architecture and data integration solution.
#J-18808-Ljbffr