Database Administrator

3 days ago

Toronto, Canada iPartner Staffing Full time

3 days per week in the office

Expert Oracle and Microsoft SQL Database administration experience

Demonstrated experience with DACPAC

Experience with Azure build automation using Ansible, Terraform, Packer and VSTS

Description

The Services and Deliverables to be provided by the Vendor will include the following:

- Participate in the review of maintenance release artefacts - Use Case, System Requirement Specification, etc.;
- Prepare database change in DACPAC and develop Azure CI/CD release pipeline to promote DACPAC
- Promote database changes through Development, Integration Testing, QA, UAT, Production environments;
- Plan, configure, maintain, administrate, tune performance of Oracle, Microsoft Azure SQL database and Synapse database
- Provide database space calculations for the supported database environments;
- Perform reference data administration as required;
- Design and write data loading and/or conversion scripts/stored procedures;
- Build and test database backup/recovery scripts;
- Build and test database automation scripts
- Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards;
- Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving, etc
- Document and resolve any database problems/issues

Provide effective knowledge transfer to Ministry staff at all stages of this assignment

**Skill Set Requirements**:

- Expert Oracle and Microsoft SQL Database administration experience;
- Expert experience with planning, configuring, maintenance, administration, performance tuning of Microsoft Azure SQL database and Synapse database
- Demonstrated experience with DACPAC
- Experience with Oracle and SQL server stored procedure development
- Experience with Azure build automation using Ansible, Terraform, Packer and VSTS
- Expert experience with git for source code version control, including branching, merging and pull requests
- Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools
- Experience with CI/CD release pipeline

**Job Type**: Fixed term contract
Contract length: 6 months

**Salary**: $300.00-$700.00 per day

Schedule:

- 8 hour shift

Ability to commute/relocate:

- TORONTO, ON: reliably commute or plan to relocate before starting work (required)

**Experience**:

- Azure build automation using Ansible: 1 year (required)
- DACPAC: 1 year (required)
- Expert Oracle and Microsoft SQL Database administration: 2 years (required)
- Database Administrator: 10 years (required)

Work Location: One location

  • Database Administrator

    1 week ago

    Toronto, Canada Bond Brand Loyalty Inc Full time

    Our team is composed of dynamic professionals committed to excellence and continuous improvement. We are seeking a skilled Database Administrator to join our growing team and help us manage and optimize our database systems. As a **Database Administrator** at Bond, you will be responsible for overseeing the performance, security, and integrity of our...

  • Database Administrator

    3 days ago

    Toronto, Canada iPartner Staffing Full time

    Expert Oracle and Microsoft SQL Database administration experience - Experience with Azure build automation using Ansible, Terraform, Packer and VSTS - Expert experience with Oracle GoldenGate - Expert Oracle and Microsoft SQL Database administration experience; - Expert experience with planning, configuring, maintenance, administration, performance tuning...

  • Database Administrator

    2 weeks ago

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

  • Database Administrator

    6 days ago

    Toronto, Canada Intelex Technologies Full time

    **Position Overview** Database is one of the most critical core components in any service infrastructure! If you wish to work with several database technologies and drive infrastructure efficiency through innovative designs, then you should consider a position as a SQL Server DBA / System Admin here at Intelex. In this role you take ownership of defining...

  • Database Administrator

    2 weeks ago

    Toronto, Canada Scotiabank Global Site Full time

    Requisition ID : Join a purpose driven winning team committed to results in an inclusive and high-performing culture. Scotiabanks Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data platform products across the globe where Scotiabank is present. Physical & logical database...

  • Database Administrator

    3 weeks ago

    Toronto, Canada CloudVital Full time

    Job Title: Database Administrator Job Type: Full-Time/Contract Job Location: Toronto – Onsite (Office 4 to 5 days a week) This role is an onsite position located in Toronto, requiring you to work in the office 4 to 5 days a week. Responsibilities Participate in the review of project, work request and maintenance release artifacts – Use Case, System...

  • Database Administrator

    3 weeks ago

    Toronto, Canada CloudVital Full time

    Job Title: Database Administrator Job Type: Full-Time/Contract Job Location: Toronto – Onsite (Office 4 to 5 days a week) This role is an onsite position located in Toronto, requiring you to work in the office 4 to 5 days a week. Responsibilities Participate in the review of project, work request and maintenance release artifacts – Use Case, System...

  • Database Administrator

    3 weeks ago

    Toronto, Canada CloudVital Full time

    Job Title: Database Administrator Job Type: Full-Time/Contract Job Location: Toronto – Onsite (Office 4 to 5 days a week) This role is an onsite position located in Toronto, requiring you to work in the office 4 to 5 days a week. Responsibilities Participate in the review of project, work request and maintenance release artifacts – Use Case, System...

  • Database Administrator

    1 week ago

    Toronto, Canada Artech LLC Full time

    Title: Database Administrator Location: Toronto, Ontario  Duration: 6 Months  Salary Range: Competitive and commensurate with experience Introduction We are seeking an experienced professional to support our diverse database environments, including development, production, and UAT. This role is integral to maintaining the performance, integrity, and...

  • Database Administrator

    19 hours ago

    Toronto, Canada Sync.com Full time

    **About the company** Since 2011, Sync has been on a mission to provide a safe space for the world to collaborate through its award-winning cloud apps and ground-breaking privacy protection features to share big ideas, store important information and collaborate on game-changing projects, making the world a better place. Our core values are constant - four...