Database Administrator

4 weeks ago


Old Toronto, Canada Dawn InfoTek Inc. Full time

Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.

Deliverables:

  • • Creation of technical specifications for Azure, SQL and Oracle database systems development
  • • Design, implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards
  • • Undertake special assignments/sub-projects as assigned
  • • Conduct, assess, evaluate and document stakeholder interests and business needs
  • • Create and validate business scenarios and use cases
  • • Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business architecture, as well as traceability to solution logical and physical architectures
  • • Create, review, provide input and support of Enterprise Architecture artifacts for all checkpoints as required
  • • Create system and user interface design and modifications (data & screen) as required
  • • Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output
  • • Ensure alignment and adherence to Ministry of Government Services’ processes and standards
  • • Support the testing team during system and UAT testing
  • • Participate in Knowledge transfer

Skills and Knowledge:

  • • Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL Server, Azure etc.) for business intelligence and analytics applications
  • • Create, test and implement safeguards to maintain data integrity and protect against unauthorized access
  • • Assist with SQL optimization and code reviews to ensure queries are efficient

Mandatory Requirements:

  • • At least 10 years of experience
  • • Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years)

Criteria Ratings MUST TOTAL 100

Criteria 1: Technical Skills 55 Points

  • • Oracle Exadata, Golden Gate, MSSQL, Azure SQL technical knowledge and experience.
  • • Demonstrated experience in modifying database structures using information provided by application developers
  • • Demonstrated experience with monitoring, optimizing and performance tuning using either manual or automated tools
  • • Able to develop and interpret highly complex SQL to support queries and provide feedback for developers.

Criteria 2: Analysis and Problem Solving 30 Points

  • • Research, and evaluation of complex design options.
  • • Superior ability to identify root cause of complex environmental or underlying database specific issues.
  • • Determining areas of risk and recommending innovative alternatives and options for resolution to meet program needs.
  • • Demonstrated experience working within a team environment to troubleshoot and resolve technical problems.

Criteria 3: Communication and Interpersonal Skills 15 Points

  • • Demonstrated writing and negotiation
  • • Oral and written communication skills, Interpersonal and consultative skills,
  • • Experience preparing operational documentation (build guides, procedures, etc)

Job Type: Fixed term contract
Contract length: 12 months

Salary: $65.00-$80.00 per hour

Schedule:

  • Monday to Friday

Work Location: Hybrid remote in Toronto, ON M5G 2B3

#J-18808-Ljbffr

  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Old Toronto, Canada Eastlink Full time

    Designated office: 6080 Young Street, Halifax, NS This position is: Hybrid, at least 3 days per week in office Eastlink is a family owned, entrepreneurial and innovative company headquartered in Halifax, Nova Scotia. We take great pride in being a leader in delivering creative competitive, customer focused telecommunications solutions, and connecting...


  • Old Toronto, Canada Eastlink Full time

    Designated office: 6080 Young Street, Halifax, NS This position is: Hybrid, at least 3 days per week in office Eastlink is a family owned, entrepreneurial and innovative company headquartered in Halifax, Nova Scotia. We take great pride in being a leader in delivering creative competitive, customer focused telecommunications solutions, and connecting...


  • Old Toronto, Canada Eastlink Full time

    Designated office: 6080 Young Street, Halifax, NS This position is: Hybrid, at least 3 days per week in office Eastlink is a family owned, entrepreneurial and innovative company headquartered in Halifax, Nova Scotia. We take great pride in being a leader in delivering creative competitive, customer focused telecommunications solutions, and connecting...


  • Toronto, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade: - Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.; - Prepare and implement database changes according to design; - Promote database changes through Development,...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Old Toronto, Canada ALLTECH CONSULTING SVC INC Full time

    * Work with EFP technical team to plan/prepare and execute migration of e-Business Suite and TPE (Transfer Payment Extension) application from On-Prem Supercluster to Oracle Cloud Infrastructure. * Performance tuning of e-Business Suite R12.2/19c in multi-node RAC environment. * Configure, deploy Oracle Access Manager, Oracle Universal Directory (OUD),...


  • Old Toronto, Canada ALLTECH CONSULTING SVC INC Full time

    * Work with EFP technical team to plan/prepare and execute migration of e-Business Suite and TPE (Transfer Payment Extension) application from On-Prem Supercluster to Oracle Cloud Infrastructure. * Performance tuning of e-Business Suite R12.2/19c in multi-node RAC environment. * Configure, deploy Oracle Access Manager, Oracle Universal Directory (OUD),...


  • Old Toronto, Canada ALLTECH CONSULTING SVC INC Full time

    * Work with EFP technical team to plan/prepare and execute migration of e-Business Suite and TPE (Transfer Payment Extension) application from On-Prem Supercluster to Oracle Cloud Infrastructure. * Performance tuning of e-Business Suite R12.2/19c in multi-node RAC environment. * Configure, deploy Oracle Access Manager, Oracle Universal Directory (OUD),...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Job Title: Database Administrator - Senior** **Location: Toronto, Ontario (Onsite)** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS...


  • Toronto, Canada CareRx Full time

    Job Details Description CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Database Administrator - Senior** **Location: 595 Bay Street,, Toronto, Ontario** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS 11-12 in a Windows environment and SQL Server RDBMS 2008-2019 - Database installation, upgrade, monitoring, troubleshooting,...


  • Toronto, Canada Interac Corp. Full time

    Database Administrator At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like...