Job Description: Job Title: Oracle PL-SQL Developer
Location: Toronto, ON
Work Style: Hybrid (2 days per week in-person at Toronto office preferred
Skills: MVS System Administration~Database Optimization and Tuning~Unix / Linux Basics and Commands
Role Descriptions:
- Database Development: Design and implement database objects including tables, views, indexes, and sequences. Write and maintain complex PL/SQL packages, stored procedures, functions, and triggers to implement business logic.
- Performance Tuning: Identify and resolve performance bottlenecks using tools like Oracle Cloud Control, AWR reports, and EXPLAIN PLAN. Optimize SQL queries and PL/SQL code for maximum scalability and speed.
- System Administration: Install, configure, and upgrade Oracle Database software. Manage database storage, plan for capacity growth, and handle routine patching and maintenance.
- Security & Compliance: Implement and maintain robust security measures, including data encryption, user access controls, and auditing. Ensure systems comply with company policies and regulatory standards.
- Backup & Recovery: Develop and execute strategies for database backup and disaster recovery using tools like Oracle Recovery Manager (RMAN).
- Data Migration & ETL: Design and manage ETL (Extract, Transform, Load) processes to migrate data between systems or into data warehouses using utilities like SQL*Loader and Data Pump.
Required Skills & Qualifications
- Education: A Bachelor’s degree in Computer Science, IT, or a related technical field is typically required.
- Expertise: Deep knowledge of Oracle Database architecture (e.g., versions 12c, 19c) and advanced PL/SQL programming techniques such as bulk processing, collection types, and error handling.
- Tools: Proficiency with administrative and development tools like TOAD, SQL Developer, and Oracle Enterpr ise Manager (OEM).
- Environment Knowledge: Experience working in Linux/Unix environments, including shell scripting for automation.
- Certifications: Professional credentials such as Oracle Certified Professional (OCP) or Oracle Certified Associate (OCA) are highly valued for verifying technical proficiency.
- ESP Scheduler - Knowledge on ESP scheduler is desirable.
Common Soft Skills
- Analytical Thinking: Ability to troubleshoot complex system issues and design creative data solutions.
- Collaboration: Working effectively with cross-functional teams, including software developers, business analysts, and project managers.
- Communication: Explaining technical database concepts to non-technical stakeholders and writing detailed technical documentation.
Pay: $45.00-$50.00 per hour
Work Location: Hybrid remote in Toronto, ON (Toronto District)
