Database Administrator

3 days ago


Toronto, Canada CloudVital Full time

Job Title : Database Administrator

Job Type: Full-Time/ Contract

Job Location: Toronto - Onsite

This is an onsite role located in Toronto, requiring you to work in the office 4 to 5 days a week.

- Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
- Deliver detailed system design documents and any other supporting documentation conforming to organization standards.
- Design, develop and optimize data/database CI/CD pipelines.
- Design logical and physical data models using Sybase Power Designer.
- 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.
- Provision data in cloud environment according to requirements.
- Design, develop data loading, data conversion, data migration program.
- Design, develop and implement data conversation of VLD (Very large Data) of Online analytical processing (OLAP) and online transaction processing (OLTP) environments to Cloud Software-as-a-service (SaaS), Platform-as-a-service (PaaS) and Infrastructure-as-a-service (IaaS) environments.
- Design, develop and implement fact/dimension model, data mapping, data warehouse, data lake and data lakehouse.
- Plan, configure, maintain, administrate, tune performance of Oracle, Microsoft Azure SQL database and Synapse database.
- Support cloud-based heterogeneous data replication solution.
- Develop complex Oracle PL/SQL program, SQL server stored procedure to fulfill project, work request, maintenance requirements.
- Optimize performance of PL/SQL program, SQL server stored procedure.
- Monitor and analyze incident, provide timely resolution.
- Perform reference data administration as required.
- Build and test database backup/recovery scripts.
- Build and test database automation scripts.
- Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving, etc
- Document and resolve any database problems/issues.



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


  • Toronto, Canada Financial Services Regulatory Authority of Ontario (FSRA) Full time

    Job Description: PURPOSE OF POSITION Accountable for providing highly specialized senior level technical expertise, oversight and support in the project implementation and administration of FSRA database systems to ensure all business operations are fully supported in the areas of design, setup, configuration, performance, capacity, monitoring, backup and...


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


  • Toronto, Canada CloudVital Full time

    Job Title : Database Administrator Job Type: Full-Time/ Contract Job Location: Toronto - Onsite This is an onsite role located in Toronto, requiring you to work in the office 4 to 5 days a week. Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc. Deliver detailed system...


  • Toronto, Canada CloudVital Full time

    Job Title : Database Administrator Job Type: Full-Time/ Contract Job Location: Toronto - Onsite This is an onsite role located in Toronto, requiring you to work in the office 4 to 5 days a week. Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc. Deliver detailed system...


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


  • Toronto, Ontario, Canada CloudVital Full time

    We are looking for highly skilled Database Administrator professional for one of the leading firm.Job Title : Database AdministratorJob Type:Full-Time/ ContractJob Location:Toronto - OnsiteParticipate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.Deliver detailed system design...


  • Toronto, Ontario, Canada Tekgence Inc Full time

    Hello,Please find the Job description belowDatabase AdministratorToronto ON5 years of experience as a Database Administrator or Database Reliability Engineer, or a similar role with a strong focus on automation and DevOps principles. Deep expertise in at least one, and preferably multiple, database systems Relational IBM DB2(nice to have), PostgreSQL (highly...


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


  • Toronto, Canada BGIS Full time

    Who We Are BGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6,500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients’ businesses. Globally, we manage over 320...