Oracle PL-SQL Developer
United States Digital Space LLC
Role: Oracle PL-SQL Developer Location: Toronto, ON Duration: Long Term Contract
Responsibilities
- 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.
- Identify and resolve performance bottlenecks using tools like Oracle Cloud Control, AWR reports, and EXPLAIN PLAN; optimize SQL and PL/SQL code for maximum scalability and speed.
- Install, configure, and upgrade Oracle Database software; manage database storage, plan for capacity growth, and handle routine patching and maintenance.
- Implement and maintain robust security measures, including data encryption, user access controls, and auditing to ensure compliance with company policies and regulatory standards.
- Develop and execute strategies for database backup and disaster recovery using RMAN.
- 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
- A Bachelor's degree in Computer Science, IT, or a related technical field.
- Deep knowledge of Oracle Database architecture (12c, 19c) and advanced PL/SQL programming techniques such as bulk processing, collection types, and error handling.
- Proficiency with TOAD, SQL Developer, and Oracle Enterprise Manager.
- Experience working in Linux/Unix environments, including shell scripting for automation.
- Professional credentials such as Oracle Certified Professional or Oracle Certified Associate are highly valued.
- Knowledge of ESP Scheduler is desirable.
Common Soft Skills
- Analytical Thinking: Ability to troubleshoot complex system issues and design creative data solutions.
- Collaboration: Work effectively with cross-functional teams, including software developers, business analysts, and project managers.
- Communication: Explain technical database concepts to non-technical stakeholders and write detailed technical documentation.
Vacancy posted 8 days ago
Similar jobs that could be interesting for youBased on the Oracle PL-SQL Developer in Toronto, ON vacancy
- Advance your career as an Oracle PL-SQL Developer in Ontario on a long-term contract. Your expertise will drive the design and optimization of critical database systems across the organization. This Oracle PL-SQL Developer position centers on implementing robust database...SuggestedLong term contract
$100k - $120k per year
...into decades and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today. Required Skills Oracle SQL & PL/SQL Development: strong expertise in writing, optimizing, and maintaining stored procedures, packages, and complex queries...SuggestedLong term contractWorldwide- ...at Scotiabank as a Software Engineer specializing in Python and PL-SQL. Contribute to capital markets analytics platforms and Risk and Margin... ...focused on Python, PL/SQL • Experience with databases like Oracle and Postgres • Understanding of Agile methodologies • Experience...Suggested
- Role Oracle CPQ Developer / Consultant Experience 5‑10 Years Summary We are seeking a hands‑on Oracle CPQ (BigMachines) Developer/Consultant with robust, recent (last 2‑4 years) project‑based experience delivering complex CPQ solutions. The ideal candidate should have...Suggested
- Become an Oracle Fusion Cloud Developer in Toronto, focusing on integrations and extensions. This role ensures seamless operations through extensive development and technical design guidance. Global research is seeking a skilled Oracle Fusion Cloud Developer. Your prior...Suggested
$103.52k - $129.39k per year
Position Title: Senior Application Developer - Oracle Fusion (EPM) Employment Type: Permanent, Full-Time Division/Branch: Information and Information Technology (I&T) Division / Digital Platforms and Cybersecurity Branch Pay Range: $103,518 to $129,393 Work...Permanent employmentFull timeWork at office- Elevate your career as a Senior Oracle SQL Developer with Tata Consultancy Services (TCS). Your expertise in Oracle SQL and PL/SQL development will be crucial in optimizing complex queries and stored procedures. TCS, a leader in technology services since 1968, is looking...
- Elevate your career as an Oracle SQL Developer focused on the Siebel Platform in Toronto. This hybrid role emphasizes SQL development and Linux administration, requiring onsite work two days weekly. As an Oracle SQL Developer at our Toronto office, you will bring your 8-10...Work at office
- Join AGCO as a Senior Application Developer focused on Oracle Fusion (EPM) in North York, Canada. Advance your technical skills while working on crucial financial processes and systems. In this permanent, full-time role, the Senior Application Developer will be responsible...Permanent employmentFull time
- Join the ClientLink Development team as a Senior Full Stack Developer specializing in Java and Oracle PL/SQL, based in Toronto with a 4-day hybrid work week. Drive the development of high‑performing wealth management applications while utilizing advanced technologies. This...
$90 - $95 per hour
Job ID: 26-17434 Job Title: Oracle EBS Developer Location: Toronto, ON (Onsite) Duration: 12 Months (possible extension) Client: Public Sector Pay Rate: CAD $90-$95 per hour Responsibilities Proven business knowledge of Oracle Accounts Receivable, Accounts Payable, Payments...Hourly pay- Step into a Junior Software Developer role with the Province of Ontario, located in Toronto. This onsite position requires strong skills in Oracle technologies and Agile practices. Ideal for those with a programming background, this role engages in application design, development...
- Job Description Insight Global is looking for an Oracle Fusion HCM Technical Developer to provide Application Managed Services (AMS) support for a live Oracle Fusion Cloud HCM environment. This role focuses on the technical stability, support, and enhancement of Oracle HCM,...Contract workRemote work
- ...technology startup, is seeking an experienced Oracle Database Administrator (DBA) Consultant... ...applications. Partner with software developers to define database architecture, schema... ...across on‑premises and cloud environments. Develop and maintain database standards,...Internship
- Job Description Insight Global is looking for an Oracle SCM Manufacturing Functional SME to support an ongoing Oracle Fusion Cloud Supply Chain environment, focused on Manufacturing, Inventory, and Costing modules. This is an Application Managed Services (AMS) role, responsible...Remote work
- ...technology will directly support organizations in delivering better employee experiences. In this role, you will help clients optimize their Oracle HCM Cloud systems, ensuring their HR operations run smoothly and efficiently. You will work alongside a collaborative,...
- Join Tata Consultancy Services as an Oracle Fusion Technical Consultant, focusing on enhancing Oracle Cloud applications. Engage in integration... ...Cloud modules. A hands-on approach is essential as you develop components, prepare BI Publisher reports, and handle integrations...
- Enhance your skills as a Senior Oracle EBS Functional Consultant with over 7 years of experience in finance or software sectors. Specialize... ...for functionalities • Educate team members about EBS solutions • Develop and manage comprehensive test plans • Mentor junior staff through...
- Advance your career with Huron as an Oracle HCM Payroll Consulting Manager. This position demands deep expertise in managed services and... ...client relationships through effective communication • Mentor and develop junior engagement team members • Implement Managed Services delivery...
- Join Accenture as a Consulting Lead in Oracle Projects and Assets, guiding clients through implementation and best practices. This senior... ...Experience leading full cycle implementations • Capacity to coach and develop team members Leverage your functional lead experience to drive...
- Devenez Développeur principal d'applications Oracle EPM à la CAJO à Toronto, un poste permanent et stimulant. Concevez et maintenez des solutions innovantes pour les besoins financiers et opérationnels de l'organisation. Ce rôle exige un expert en Oracle Fusion avec au moins...Permanent employment
$102k - $127.5k per year
...workflows, building customer solutions, developing software, configuring applications, providing... ...and Manufacturing implementations (e.g., Oracle ERP Cloud). A minimum of 5 years of... .... Manage stakeholder requirements and develop detailed implementation plans Carry out...Hourly payWork at officeRemote workFlexible hours3 days per week- Advance your career as an Oracle FAH Consultant in Toronto, bringing hands-on expertise in Oracle FAH and strong accounting knowledge. This full-time role focuses on designing robust solutions and ensuring compliance with regulatory standards. In this experienced position...Full time
- Transform Oracle's AI landscape as a Lead AI Systems Engineer. Define and operate next-gen AI systems effectively within Oracle Cloud Infrastructure... ...• Implement AI workflow orchestration and model serving • Develop scalable agent systems and multi-agent coordination • Drive...
- Enhance your career at Huron as a Senior Consultant in Oracle Cloud HCM Recruiting and Onboarding in the U.S. or Canada. Focus on strategic... ...• Collaborate with cross-functional teams for integration • Develop documentation and training materials Requirements: • Bachelor’...
- Title: Oracle Senior Platform Specialist Requisition ID: 247938 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Global Finance – Platform Engineering Team plays a critical role in architectural design, installation...Flexible hours
- Join a pivotal role as the Lead Tester focusing on Oracle Financials modules. Specialize in comprehensive testing strategies and ensure the... ...and analytics via Oracle Transactional Business Intelligence • Develop and execute detailed test cases and scripts • Record and track defects...
- Job Description Insight Global is looking for a Senior Oracle HCM Cloud Functional Consultant to join a leading enterprise team supporting and enhancing their Oracle Cloud environment. This individual will play a key role in configuring, optimizing, and supporting multiple HCM...
- Elevate your career as an Oracle Cloud PLM Project Manager in Toronto. Drive the design, implementation, and optimization of critical PLM... ...applications • Design data migration strategies from legacy systems • Develop SQL queries and APEX applications Requirements: • Expertise in...
$90k - $110k per year
...screen, assess, or select applicants. Job Overview The Java Developer is responsible for the developmental efforts of CMiC’s Tools applications... ...of the Tools application, including those developed with Oracle ADF. Duties & Responsibilities Write high quality and well...Seasonal workNight shift
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Oracle PL-SQL Developer. Be the first to apply!
