Database Administrator

2 weeks 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



  • Toronto, Canada iPartner Staffing Full time

    Role: RQ04307 - Database Administrator - Intermediate Must haves: - Microsoft SQL Database Administration - Minimum 5 years' experience - Microsoft Database migration experience to new hardware - Database tuning and optimization - Strong documentation skills **Job Type**: Fixed term contract **Salary**: $300.00-$700.00 per day Schedule: - 8 hour...


  • Toronto, Canada iPartner Staffing Full time

    Must haves: - Expert level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x; UNIX OS (Operating System) and Linux OS, utilities, shell scripting - **Expert level knowledge of Oracle 12c/19c database administration**, maintenance, security implementation include:, upgrade and...


  • Toronto, Canada Cloud Vital Full time

    We are looking for an experienced IT professional with knowledge and advanced skills around in Database Administration for one of the dynamic companies!Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert...


  • Toronto, Canada Cloud Vital Full time

    We are looking for an experienced IT professional with knowledge and advanced skills around in Database Administration for one of the dynamic companies!Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert...

  • Database Administrator

    Found in: Appcast CA C2 Glassdoor - 1 week ago


    Toronto, Canada Cloud Vital Full time

    We are looking for an experienced IT professional with knowledge and advanced skills around in Database Administration for one of the dynamic companies!Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert...

  • Database Administrator

    Found in: Whatjobs CA C2 - 1 week ago


    Toronto, Canada Cloud Vital Full time

    We are looking for an experienced IT professional with knowledge and advanced skills around in Database Administration for one of the dynamic companies! Job Role: Database Administrator Job Type: Full -Time/Contract Location: Toronto, Canada (Hybrid working Model) Skills Required: · Expert Oracle and Microsoft SQL Database administration experience; ·...

  • Database Administrator

    Found in: Appcast CA A2 P - 1 week ago


    Toronto, Canada Cloud Vital Full time

    We are looking for an experienced IT professional with knowledge and advanced skills around in Database Administration for one of the dynamic companies!Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert...


  • Toronto, Canada Cloudvital Technologies Full time

    We are hiring Mainframe DB2 for one of the fast growing dynamic company Job Title: Database Administrator Job Location: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote **_ **Required skills**: - Extensive hands-on experience in the use of z/OS and related software packages and tools - Extensive experience...

  • Database Administrator

    Found in: Talent CA C2 - 2 weeks ago


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

  • Oracle Database Administrator

    Found in: Whatjobs CA C2 - 6 days ago


    Toronto, Canada Procom Full time

    Oracle Database Administrator On behalf of our client in the Banking Sector, PROCOM is looking for an Oracle Database Administrator. Oracle Database Administrator - Job DescriptionOracle Installation, Database creations and upgrades from lower Database versions to higher versionsTroubleshooting connectivity and addressing any system concernsPerform...


  • 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. We are currently seeking competent individuals to fulfill the role of **Database...


  • 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. **We are currently seeking competent individuals to fulfill the role of Database...


  • Toronto, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...


  • Toronto, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...


  • Toronto, Canada Q1 Technologies Full time

    **Role -DB2 Database Administrator** **Location - Toronto, ON** **Duration - Full Time** **Job Description-** "- Experience in a database administration role, with primary focus on DB2 and the ability to manage Oracle or PostgreSQL - Completion of a post-secondary college diploma or university degree in a related discipline or a combination of education,...


  • Toronto, Canada iPartner Staffing Full time

    3 days a week in the office 10+ years of experience in database administration, maintenance, optimization, and fine tuning of databases 5+ years of experience in database development using SQL, SQL Plus, Stored Procedures, transitional databases Working knowledge of MS SQL Server 2008 to 2019 and maintenance, setup, configuration, deployment,...


  • Toronto, Canada Dentons Full time

    INTRODUCTION The Global Database Administrator will maintain the database services used by Dentons, including a mixture of cloud and on premises solutions. The individual will be accountable for the monitoring of database performance, database optimization, and responding to queries around the data held in these systems. WHY DENTONS Dentons is designed to...

  • database administrator

    Found in: Talent CA 2 C2 - 6 days ago


    Toronto, Canada KDigitalLabs INC Full time

    Education: Expérience: EducationCollege/CEGEPTasksCollect and document user's requirementsData ScienceDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database...

  • database administrator

    Found in: Talent CA 2 C2 - 2 weeks ago


    Toronto, Canada KDigitalLabs INC Full time

    Education: College/CEGEPExperience: 1 year to less than 2 yearsTasksCollect and document user's requirementsData ScienceDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and...

  • Database Administrator

    Found in: Whatjobs CA C2 - 2 weeks ago


    Toronto, Canada The Mabin School Full time

    Database Administrator / IT Helpdesk Duration : 20 hrs / week over 3-4 days / week Location : Toronto, ON Please note this is a hybrid role.   About The Mabin School:  The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada’s first independent...