Database Administrator

We are looking for an experienced Database Administrator to join one of our esteemed client!

Job Title: Database Administrator

Job Type: Full Time/ Contract

Job Location: Toronto

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

• Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
• 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 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 databases.
• Develop complex Oracle PL/SQL stored procedure to fulfill project, work request, maintenance requirements.
• Optimize performance of PL/SQL program, SQL server stored procedure.
• 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

• Expert experience with Microsoft Azure technologies, including Azure pipeline, DACPAC, storage account, disk, file share, Azure key vault, Azure portal, virtual machine, Azure Dev Ops, 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 Continuous Integration/Continuous Development/Deployment (CI/CD) and Data provisioning Automation.
• Experience with digital product, data analysis, data exchange, data provisioning, and data security.
• Experience with structured, semi-structured, unstructured data collection, ingestion, provisioning and exchange technological development.

• Extensive experience with SQL Server Stored Procedure, Oracle PL/SQL, PL/1 development and performance tuning.
• Experience with Golden Gate.

If you feel you are fit for the role or have someone in your circle with the relevant experience then please apply via Linked In or share your profiles with us at