Skip to main content
Post your resume and find your next job on Indeed!

Database Design jobs in Markham, ON

Sort by: -
    • RESTful API design and implementation.
    • Database design principles and data architecture.
    • Significant hands-on experience with Oracle database development.
    • Familiarity with database technologies such as MySQL, MSSQL & MongoDB.
    • Develop and maintain business process workflows, creating detailed design specifications…
    • View all Scotiabank jobs - Toronto jobs
    • Salary Search: Junior Software Engineer salaries in Toronto, ON
    • See popular questions & answers about Scotiabank
    • Develop database objects: stored procedures, functions, triggers etc.
    • Experience with development and database administration for MS SQL Server 2005 and above.
    • Domain-driven design, microservices design patterns.
    • Our compensation policies and practices have been designed to allow colleagues to progress through the…
  • View similar jobs with this employer
    • Leads, evaluates, determines, develops, design and actively looks for opportunities to improve and/or implement system/application efficiencies.
    • Proficient in database management of SQL and NoSQL.
    • To define and design new systems by analyzing current ETL processes.
    • Build multi-dimensional data models.
    • Hold code and design reviews while ensuring that all components are architecturally consistent.
    • Full proficiency with multiple programming languages and/or…
    • Familiarity with database management systems like MySQL and SQL Server for data integration and manipulation.
    • In this role, you will leverage your expertise in…
    • Expert-level SQL skills (complex joins, CTEs, window functions, schema design, index tuning, and database optimization).
    • Hybrid (2 days per week in-person at Toronto office preferred).
    • Skills: Advanced Java Concepts~IBM InfoSphere MDM~Master Data Management (MDM) Experience…
    • Work with internal and external teams on all phases of system lifecycle including requirement gathering, analysis, solution design, implementation, integration,…
    • Searching for solutions within the ERP solution database;
    • Project management, release management, process design, configuration, and testing, preferably in a…
    • Strong understanding of frontend development, specifically microapp design patterns.
    • Hands-on experience in Microservices design, Event driven architecture, ETL…
    • Partner with other functional and delivery teams to research and design the appropriate solution for the different business requirements.
    • Proficiency in SQL and database querying.
    • Work with relational databases, including schema design, queries, and performance optimization.
Get email updates for the latest Database Design jobs in Markham, ON

By creating a job alert, you agree to our Terms . You can change your consent settings at any time by unsubscribing or as detailed in our terms.

Career Resources:

CMiC logo
PL/SQL Developer
CMiC
·
3.4
Toronto, ON
•
Hybrid work
$70,000–$115,000 a year
Permanent
Apply on company site

Job details

$70,000–$115,000 a year
Dental care, Paid vacation, RRSP match, Wellness program
Permanent
Hybrid work in Toronto, ON

Full job description

Headquartered in Toronto, CMiC is a software company focused on the Construction industry. We have built a comprehensive platform for construction companies to manage their most important workflows. Our customers have their choice of a SaaS or Private Hosted platform that includes industry focused modules to manage everything from Financials and Payroll to Project Management and Budgeting. Our market share is very strong in North America and rapidly expanding internationally in regions like Europe, Southeast Asia and the Middle East.

Job Overview
We are seeking a Back-End Developer with deep expertise in Oracle PL/SQL and experience in Java-based REST API development. This role will focus primarily on database development with additional responsibilities in API development and integration. Strong analytical thinking and problem-solving skills are essential to succeed in this role.

Important Information:
  • The overall hiring salary range for this position from Intermediate to Senior level, is $70,000 to $115,000 annually
  • This position is for an existing vacancy
  • We do not use AI to screen, assess, or select applicants

  • 3–7+ years in backend development
  • Significant hands-on experience with Oracle database development
  • Proven experience developing and maintaining PL/SQL code in enterprise environments
  • Experience building and consuming REST APIs in Java
  • Exposure to system integration across multiple applications
  • Experience in performance tuning and troubleshooting production issues
  • Working in Agile/Scrum environments
Analytical Skills
  • Strong problem-solving and root-cause analysis abilities
  • Ability to analyze complex data flows and system dependencies
  • Debugging and troubleshooting complex database and API issues
  • Translating business requirements into efficient technical solutions
  • Identifying performance bottlenecks and optimizing solutions
  • Data-driven decision-making mindset
Attitudes and Aptitudes
  • Detail-oriented, especially with data accuracy and integrity
  • Ownership mindset with accountability for deliverables
  • Continuous learning (especially evolving database and API technologies)
  • Proactive in identifying issues and proposing improvements
  • Collaborative team player with good communication skills
  • Adaptable to changing priorities and requirements
  • Quality-focused with emphasis on maintainability and scalability
  • Logical reasoning and structured thinking
  • Strong attention to detail (critical for database work)
  • Ability to work with abstract data models and complex logic
  • Capability to manage both deep backend processing and API layers

Oracle / PL-SQL
  • Advanced PL/SQL development (packages, procedures, functions, triggers)
  • Strong SQL skills (complex joins, subqueries, performance tuning)
  • Query optimization and execution plan analysis
  • Data modeling (normalized/denormalized schemas)
  • Bulk processing and efficient data handling techniques
  • Use of Oracle development tools (PL-SQL Developer, TOAD, SQL*Plus)
  • Error handling, exception management, and logging
  • Working with large datasets and high-volume transactional systems

API Development
  • Object oriented programming
  • Java programming
  • RESTful API design and implementation
  • Java backend development (Java 8+ preferred)
  • Spring / Spring Boot framework (Nice to have)
  • API documentation (Swagger/OpenAPI)
  • JSON/XML data handling
  • Secure API development (OAuth2, JWT, basic authentication)

Nice to Have
  • IntelliJ experience
  • Oracle JDeveloper experience
  • CI/CD pipelines (Jenkins, GitHub Actions)
  • Database design principles and data architecture
  • Transaction management and concurrency control
  • API lifecycle management and versioning strategies
  • Software development lifecycle (SDLC)
  • Secure coding practices
  • Data integrity and validation techniques
  • Version control systems (Git)

  • Competitive benefits Package (including Health & Dental benefits)
  • Paid vacation and personal days
  • Townhall meetings where all employees are encouraged to participate in open discussions
  • Located on York University’s campus, easily accessible by transit (TTC, GO, etc.), walking distance to shopping and restaurants
  • Outdoor lunch space, including picnic tables
  • An active Social Events Committee (past events include annual seasonal parties, pool and bowling tournaments, karaoke nights, Game nights, BBQ’s, and more)
  • Health and Wellness webinars
  • RRSP Matching Program after 2 years of employment
  • Experience in a rapidly growing, socially responsible corporation

CMiC is an Equal Opportunity Employer. In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, CMiC will provide accommodation to applicants with disabilities throughout the recruitment, selection and/or assessment process. If selected to participate in the recruitment, selection and/or assessment process, please inform Human Resources staff of the nature of any accommodation(s) that you may require.

Let Employers Find YouUpload Your Resume