Sr. Oracle PL/SQL Application Developer

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

Astra-North Infoteck Inc. is looking for a Senior Application Developer in Toronto, Ontario. The role involves designing, developing, and maintaining applications using Oracle and SQL, alongside monitoring application performance and collaborating with infrastructure teams. Candidates should have strong hands-on experience with Oracle Database, knowledge of performance tuning, and familiarity with Linux commands. The work is hybrid, requiring two days in the office each week, which allows for flexibility and collaborative work environments.

Qualifications

• Strong hands-on experience with Oracle Database.
• Good understanding of database partitioning and performance tuning.
• Good understanding of application monitoring tools (Dynatrace or similar).
• Working knowledge of Linux/Unix commands and shell scripting.
• Experience with Ansible scripting for automation.

Responsibilities

• Design, develop, and maintain applications using Oracle and SQL-based systems.
• Monitor and analyze application performance using tools like Dynatrace.
• Collaborate with infrastructure teams to understand and support application environments.
• Assist in deployment, release management, and production support activities.

Skills

Oracle Database

Database partitioning

Performance tuning

Application monitoring tools

Linux/Unix commands

Ansible scripting

Dev, QA, Prod environments

Job description

Job Description: Role: Senior Application Developer

Hybrid 2 days a week in office

Key Responsibilities

• Design, develop, and maintain applications using Oracle and SQL-based systems
• Work on database objects including partitions, indexing, and performance optimization
• Monitor and analyze application performance using tools like Dynatrace
• Support and manage marketing campaigns, preferably using Unica (good to have)
• Raise and manage Change Requests (CRs), ensuring proper documentation and approvals
• Collaborate with infrastructure teams to understand and support application environments
• Develop and maintain automation scripts using Ansible
• Perform system-level troubleshooting using Linux commands
• Participate in client meetings, gather requirements, and provide technical solutions
• Ensure adherence to coding standards, security, and best practices
• Assist in deployment, release management, and production support activities

Required Skills and Qualifications

• Strong hands‑on experience with Oracle Database
• Good understanding of database partitioning and performance tuning
• Good understanding of application monitoring tools (Dynatrace or similar)
• Working knowledge of Linux/Unix commands and shell scripting
• Experience with Ansible scripting for automation
• Familiarity with project infrastructure and environments (Dev, QA, Prod)

Preferred Skills (Good to Have)

• Experience with Unica Campaign or similar campaign management tools
• Exposure to incident management and CR processes
• Knowledge of CI/CD pipelines
• Experience working in Agile/Scrum environments