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 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 changes 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 and implement data conversion of VLD (Very large Data) of OLAP and OLTP environments to Cloud SaaS, PaaS, and 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. Develop complex Oracle PL/SQL programs, SQL Server stored procedures to fulfill project, work request, maintenance requirements. Optimize performance of PL/SQL programs, SQL Server stored procedures. Monitor and analyze incidents, 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, and maintenance. Document and resolve any database problems/issues. Required Skills Expert experience with Microsoft Azure technologies, including Azure pipeline, DACPAC, storage account, disk, file share, Azure Key Vault, Azure portal, virtual machine, Azure DevOps, Data Lake, Data Lakehouse, Azure monitoring tools. Experience with cloud data platforms, data management and data exchange tools and technologies. Experience with data pipeline and workflow development, orchestration, deployment, and automation. Experience in DataOps principles, best practices, and implementation and Agile project development and deployment. Experience in Continuous Integration/Continuous Development/Deployment (CI/CD) and Data provisioning automation. Expert data/database administration experience, e.g., Microsoft Azure SQL database and Synapse database, Oracle, IMS, DB2, etc. Extensive experience with SQL Server Stored Procedures, Oracle PL/SQL, PL/1 development and performance tuning. Seniority Level Mid-Senior level Employment Type Full-time Job Function Information Technology Industries Software Development and Technology, Information and Media If interested, please apply via LinkedIn or share your resume with us at hr@cloudvital.ca. #J-18808-Ljbffr



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


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


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


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


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


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


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