Senior Database Developer/DBA for 6-8 month hybrid contract in Toronto. Requires 10+ years Oracle/PL/SQL experience, PostgreSQL/MS SQL knowledge, and database performance tuning.
Responsibilities
Design, develop, and maintain database schemas, tables, views, indexes, and stored procedures in ETL application & DW packages. Develop and optimize PL/SQL packages, triggers, and functions for Oracle databases. Write efficient SQL queries and scripts for data manipulation and reporting. Development of programs/packages/procedures/functions in Oracle, PostgreSQL, MS SQL Server databases. Implement backup and recovery strategies and ensure data integrity and security. Collaborate with application developers and business analysts to support data-driven solutions. Troubleshoot and resolve database-related issues in development, test, and production environments. Document database architecture, processes, and configurations for compliance and auditing. The position involves majority of time in development & testing and very less time of DBA activities like installation of database software and creation/maintenance of databases.
Requirements
10+ years of experience in Oracle Database and PL/SQL programming. Proficiency in SQL and query optimization techniques. Working knowledge of PostgreSQL and MS SQL Server databases. Experience with database performance tuning and indexing strategies. Understanding backup/recovery, high availability, and disaster recovery concepts. Familiarity with data modeling and normalization techniques. Experience with Unix/Linux environments and shell scripting. Exposure to BI tools and data warehousing concepts (ETL framework). Bachelor’s degree in Computer Science, Information Technology, or related field. Knowledge of cloud platforms (GCP). Experience in working with Telecom Inventory system and Telecom performance data. MUST be able to work 2 days in Toronto office, 3 days WFH. Only qualified candidates who meet the MUST HAVE requirements AND are Canadian Citizen, PR or open work permit.
Database Administrator and Analyst managing donor database systems for a digital hospital. Responsible for data integrity, system configuration, and supporting fundraising processes.
Senior Oracle DBA overseeing Oracle environments and leading cloud migrations for clients in Managed Services. Focused on performance, security, and high availability of database resources.
Senior Database Administrator managing production, non - production, and DR databases for Canadian Tire Corporation. Ensuring high availability and performance while driving automation and modernization initiatives.
Database Manager leading operational excellence for Oracle and Mongo platforms at Intact. Mentoring teams and driving transformation with cloud and AI strategies.
Oracle Database Administrator responsible for the configuration and administration of databases at Desjardins. Ensuring the integrity, security, and performance of the Oracle database services.
Database Administrator providing technical support and administration of IDMS databases for a consulting firm specializing in digital transformation. Collaborating to support operational processes and software upgrades.