TAG HR

Database Administrator (BB-3EBE6)

Found in: Neuvoo Bulk CA

Description:

Job Description

MANDATORY CRITERIA Oracle Database Administrator

References must be provided for each project/employment experience.

Item

Mandatory Criteria

Resource Instructions

M1

The Bidder must demonstrate that the proposed Database Administrator meets the qualifications specified in the Task Based Informatics Professional Services Supply Arrangement for the I.2 Database Administrator — Level 3.

10+ years of experience as Database Administrator

Please indicate which bullets in your resume apply to this requirement by placing (M1) beside the bullet.

Please provide full reference information for contacts from each cited project

M2

The Bidder must demonstrate that the proposed resource has a minimum of five (5) years of experience within the last eight (8) years from the date of bid closing installing and configuring an Oracle (11g or above) Relational Database Management System (RDBMS) in an Enterprise environment consisting of more than 10 Oracle databases and a minimum of four (4) servers.

Please indicate which bullets in your resume apply to this requirement by placing (M2) beside the bullet.

Please provide full reference information for contacts from each cited project

M3

The Bidder must demonstrate that the proposed Database Administrator has a minimum of two (2) years of experience within the last eight (8) years from the date of bid closing applying performance monitoring and tuning techniques and procedures in an Oracle RDBMS environment using Oracle Enterprise Manager Grid Control.

Please indicate which bullets in your resume apply to this requirement by placing (M3) beside the bullet.

Please provide full reference information for contacts

M4

The Bidder must demonstrate that the proposed Database Administrator has a minimum of seven (7) years of experience within the last ten (10) years from the date of bid closing writing and evaluating SQL scripts including writing and tuning SQL and PL/SQL code for stored procedures, functions and triggers.

Please indicate which bullets in your resume apply to this requirement by placing (M4) beside the bullet.

Please provide full reference information for contacts

M5

Within the last ten (10) years, the Bidder must demonstrate that the proposed resource has at least five (5) years of experience working in a Unix and Linux environment, writing, designing and automating scripts.

Please indicate which bullets in your resume apply to this requirement by placing (M5) beside the bullet.

M6

The Bidder must demonstrate that the proposed resource has at least two (2) years of experience performing Oracle database (11g or above) backups/restores using Simpana CommVault.

Please indicate which bullets in your resume apply to this requirement by placing (M6) beside the bullet.

M7

Within the last ten (10) years, the Bidder must demonstrate that the proposed resource has at least five (5) years of experience configuring the following security settings in the Oracle 11g and above tool:

  • User Security; and
  • Access Control; and
  • Privilege Management.
  • Please indicate which bullets in your resume apply to this requirement by placing (M7) beside the bullet.

    Please provide full reference information for contacts from each cited project who can confirm the details

    Other

    Security Clearance Information

    Please complete the security table above in full

    Other

    Client References

    Please provide full reference information for contacts from each cited project who can confirm the details contained in your resume. Contacts must be in a lead or management position and must clearly correspond with projects in your resume

    RATED CRITERIA

    Item

    Rated Criteria

    Self-Score

    Resource Instructions

    R1

    The Bidder should demonstrate that the proposed resource has experience, within the last eight (8) years from the date of bid closing, configuring and administering Oracle Data Guard with Data Guard Broker.

    /20

    Please indicate which bullets in your resume apply to this requirement by placing (R1) beside the bullet.

    Max: 20 points

    • Less than 6 months = 0 Points
    • 6 months to 1 year = 10 Points
    • More than 1 year = 20 Points

    R2

    Within the last eight (8) years from the date of bid closing, the Bidder should demonstrate that the proposed resource has work experience performing Oracle database (11g or above) backups/restores using tools other than Simpana CommVault.

    /20

    Please indicate which bullets in your resume apply to this requirement by placing (R2) beside the bullet.

    Max: 20 points

    • Less than 1 year = 0 Points
    • 1 year to 2 years = 10 Points
    • More than 2 years = 20 Points

    R3

    The Bidder should demonstrate that the proposed resource has experience, within the last eight (8) years from the date of bid closing developing PL/SQL and SQL Code.

    /20

    Please indicate which bullets in your resume apply to this requirement by placing (R3) beside the bullet.

    • Less than 2 years = 0 Points
    • 2 years to 5 years = 10 Points
    • More than 5 years = 20 Points

    R4

    The Bidder should demonstrate that the proposed resource has experience, within the last eight (8) years from the date of bid closing writing or designing automated scripts in a Unix/Linux environment.

    /10

    Please indicate which bullets in your resume apply to this requirement by placing (R4) beside the bullet.

    Max: 10 points

    • Less than 1 year = 0 Points
    • 1 year to 2 years = 5 Points
    • More than 2 years = 10 Points

    R5

    The Bidder should demonstrate that the proposed resource has experience using Oracle Designer.

    Max: 10 points

    • Less than 6 months = 0 Points
    • 6 months to 1 year = 5 Points
    • More than 1 year = 10 Points

    /10

    Please indicate which bullets in your resume apply to this requirement by placing (R5) beside the bullet.

    R6

    The Bidder should demonstrate that the proposed resource has experience using Toad for Oracle database management toolset.

    /10

    Please indicate which bullets in your resume apply to this requirement by placing (R6) beside the bullet.

    • 1 year to 2 years = 5 Points
    • More than 2 years = 10 Points

    R7

    The Bidder should demonstrate that the proposed resource has one or more of the following certifications:

    Certification of Oracle Database SQL Certified Expert; or

    Certification of Oracle Database SQL Certified Professional; or

    Certification of Oracle Advanced PL/SQL Developer Certified Professional; or

    Certification of Oracle Database 11g or above Administrator (OCP)

    The Bidder must submit acceptable proof of certification of its proposed resource in its proposal. Acceptable proof of certification is a copy of the certification document.

    /20

    Please provide a copy of your certifications – note: it is mandatory that this be included in the bid submission

    Max: 20 points

    10 points per certification up to 20 points

    R8

    The Bidder should demonstrate that the proposed resource has at least a two-year program post-secondary diploma in computer science engineering (computer, science-related or computer system-related engineering) or management information systems from a recognized university or college.

    The Bidder must submit acceptable proof of education and / or Canadian equivalency of its proposed resource in its proposal. Acceptable proof of education is a copy of a degree, diploma from a recognized educational institution.

    Proposed resources with foreign educational credentials are required to provide proof of Canadian equivalency. Please consult the Canadian Information Centre for International Credentials at www.cicic.ca for further information.

    /10

    Please provide a copy of your degree/diploma as well as all relevant certifications – note: it is mandatory that this be included in the bid submission

    Max: 10 points

  • Diploma of a 2-year program = 3 point
  • Diploma of a 3-year program = 6 points
  • Bachelor or above degree = 10 points
  • R9

    Within the last ten (10) years, the Bidder should demonstrate that the proposed resource has experience configuring at least one (1) of the following security settings in the Oracle 11g and above tool:

  • Auditing; and/or
  • Transparent Data Encryption.
  • /6

    Please indicate which bullets in your resume apply to this requirement by placing (R9) beside the bullet.

    Max: 6 points

    3 points per security setting, up to a maximum of 6 points.

    R10

    Within the last ten (10) years, the Bidder should demonstrate that the proposed resource has work experience managing, monitoring, configuring and tuning in a Real Application Clusters and Data Guard environment.

    /10

    Please indicate which bullets in your resume apply to this requirement by placing (R10) beside the bullet.

    • < 6 months = 0 Points

    • 6 months to 1 year = 2 Points

    • > 1 year to 2 years = 4 Points

    • > 2 years to 3 years = 6 Points

    • > 3 years = 10 Points

    TOTAL POINTS AVAILABLE

    /136

    Min. points required

    82/136



    MANDATORY CRITERIA MS SQL Server Database Administrator

    References must be provided for each project/employment experience.

    Item

    Mandatory Criteria

    Resource Instructions

    M1

    The Bidder must demonstrate that the proposed Database Administrator meets the qualifications specified in the Task Based Informatics Professional Services Supply Arrangement for the I.2 Database Administrator — Level 3

    10+ years of experience as Database Administrator

    Please indicate which bullets in your resume apply to this requirement by placing (M1) beside the bullet.

    Please provide full reference information for contacts from each cited project

    M2

    The Bidder must demonstrate that the proposed resource has a minimum of five (5) years of experience within the last eight (8) years from the date of bid closing installing and configuring a clustered MS SQL Server (2008 and above, including 2019) Relational Database Management System (RDBMS) in an Enterprise environment consisting of a minimum of two (2) installed instances in Active/Active or Active/Passive clustered server architecture.

    Please indicate which bullets in your resume apply to this requirement by placing (M2) beside the bullet.

    Please provide full reference information for contacts from each cited project who can confirm the details contained in your resume.

    M3

    The Bidder must demonstrate that the proposed Database Administrator has a minimum of three (3) years of experience within the last eight (8) years from the date of bid closing applying performance monitoring and tuning techniques and procedures in an MS SQL Server RDBMS environment.

    Please indicate which bullets in your resume apply to this requirement by placing (M3) beside the bullet.

    Please provide full reference information for contacts

    M4

    The Bidder must demonstrate that the proposed Database Administrator has a minimum of seven (7) years of experience within the last ten (10) years from the date of bid closing writing and evaluating SQL scripts including writing and tuning SQL and Transact-SQL code for stored procedures, functions and triggers.

    Please indicate which bullets in your resume apply to this requirement by placing (M4) beside the bullet.

    Please provide full reference information for contacts

    M5

    The Bidder must demonstrate that the proposed resource has at least two (2) years of experience managing MS SQL Server databases (2008 and above) and implementing maintenance plans for backup, restores, database optimisation, etc.

    Please indicate which bullets in your resume apply to this requirement by placing (M5) beside the bullet.

    M6

    The Bidder must demonstrate that the proposed resource has at least two (2) years of experience configuring and managing MS SQL Server (2008 and above) software and any of its components (such as Reporting Services or Integration Services, Server Management Studio, etc.)

    Please indicate which bullets in your resume apply to this requirement by placing (M6) beside the bullet.

    Please provide full references

    M7

    The Bidder must demonstrate that the proposed resource has at least two (2) years of experience configuring and managing database and server access rights to MS SQL Server (2016 or above) leveraging MS Active Directory users and Groups.

    Please indicate which bullets in your resume apply to this requirement by placing (M7) beside the bullet.

    M8

    Within the last ten (10) years, the Bidder must demonstrate that the proposed resource has at least five (5) years of experience configuring the following security settings in the MS SQL Server 2008 and above tool:

  • User Security; and
  • Access Control; and
  • Privilege Management.
  • Please indicate which bullets in your resume apply to this requirement by placing (M8) beside the bullet.

    Please provide full reference information for contacts from each cited project who can confirm the details

    Other

    Security Clearance Information

    Please complete the security table above in full

    Other

    Client References

    Please provide full reference information for contacts from each cited project who can confirm the details contained in your resume. Contacts must be in a lead position

    RATED CRITERIA

    Item

    Rated Criteria

    Self-Score

    Resource Instructions

    R1

    The Bidder should demonstrate that the proposed resource has experience, within the last eight (8) years from the date of bid closing, configuring and administering SQL Server version 2008 or Above.

    /20

    Please indicate which bullets in your resume apply to this requirement by placing (R1) beside the bullet.

    Max: 20 points

    • Less than 1 year = 0 Points
    • 1 year to 2 years = 10 Points
    • More than 2 years = 20 Points

    R2

    The Bidder should demonstrate that the proposed resource has work experience within the last eight (8) years from the date of bid closing configuring and managing MS SQL Server database backup and recovery using maintenance plans.

    /20

    Please indicate which bullets in your resume apply to this requirement by placing (R2) beside the bullet.

    Max: 20 points

    • Less than 1 year = 0 Points
    • 1 year to 2 years = 10 Points
    • More than 2 years = 20 Points

    R3

    The Bidder should demonstrate that the proposed resource has experience, within the last eight (8) years from the date of bid closing developing Transact-SQL and SQL Code.

    /20

    Please indicate which bullets in your resume apply to this requirement by placing (R3) beside the bullet.

    • Less than 2 years = 0 Points
    • 2 years to 5 years = 10 Points
    • More than 5 years = 20 Points

    R4

    The Bidder should demonstrate that the proposed resource has experience using Microsoft SQL Server Management Studio.

    /10

    Please indicate which bullets in your resume apply to this requirement by placing (R4) beside the bullet.


    • 1 year to 2 years = 5 Points
    • More than 2 years = 10 Points

    R5

    The Bidder should demonstrate that the proposed resource has one or more of the following certifications:

  • Microsoft Certified Solutions Associate (MCSA/MCSE), or
  • Microsoft Certified Database Administrator (MCDBA), or
  • Microsoft SQL Database Administration (MCSA), or
  • SQL Server 2012/2014 (MCSA), or
  • SQL 2016 or above Database Administration (MCSA)
  • The Bidder must submit acceptable proof of certification of its proposed resource in its proposal. Acceptable proof of certification is a copy of the certification document.

    /10

    Please provide a copy of your certifications – note: it is mandatory that this be included in the bid submission

    Max: 20 points

    10 points per certification up to 20 points

    R6

    The Bidder should demonstrate that the proposed resource has at least a two-year program post-secondary diploma in computer science engineering (computer, science-related or computer system-related engineering) or management information systems from a recognized university or college.

    The Bidder must submit acceptable proof of education and / or Canadian equivalency of its proposed resource in its proposal. Acceptable proof of education is a copy of a degree, diploma from a recognized educational institution.

    Proposed resources with foreign educational credentials are required to provide proof of Canadian equivalency. Please consult the Canadian Information Centre for International Credentials at www.cicic.ca for further information.

    /10

    Please provide a copy of your degree/diploma as well as all relevant certifications – note: it is mandatory that this be included in the bid submission

    Max: 10 points

  • Diploma of a 2-year program = 3 point
  • Diploma of a 3-year program = 6 points
  • Bachelor or above degree = 10 points
  • R7

    Within the last ten (10) years, the Bidder should demonstrate that the proposed resource has experience configuring at least one (1) of the following security settings in the MS SQL Server 2008 and above tool:

  • Auditing; and/or
  • Transparent Data Encryption.
  • /6

    Please indicate which bullets in your resume apply to this requirement by placing (R7) beside the bullet.

    Max: 6 points

    3 points per security setting, up to a maximum of 6 points.

    TOTAL POINTS AVAILABLE

    /106

    Min. points required

    64/106


    calendar_today2 days ago

    Similar jobs

    location_onCanada

    work TAG HR

    Apply:
    I expressly authorise the Terms and Conditions