Position Summary

The Senior Oracle, Cassandra, and Spark Database Developer is a highly skilled professional responsible for designing, developing, implementing, and maintaining advanced database solutions across relational and NoSQL platforms. This role requires expertise in Oracle, Cassandra, and Apache Spark, as well as a strong understanding of data warehousing, big data frameworks, and ETL processes.

The Senior Developer will collaborate with data architects, data scientists, and application developers to deliver scalable, high-performance solutions that meet complex business requirements.

Key Responsibilities

• Database Development: Design and develop schemas, tables, stored procedures, functions, and other objects across Oracle, Cassandra, and Spark environments.

• Data Modeling: Create logical and physical data models ensuring data integrity, consistency, and optimal performance.

• ETL & Data Integration: Design and implement ETL processes using tools such as Apache Spark, Apache NiFi, or Oracle Data Integrator.

• Performance Optimization:
  Identify and resolve performance bottlenecks through tuning, indexing strategies, and query optimization.

• Query Development: Write advanced SQL and CQL (Cassandra Query Language) for complex data retrieval and manipulation.

• Big Data Processing: Develop Spark applications using Python for large-scale data processing and analytics.

• Data Warehousing: Design and implement solutions leveraging Oracle, Cassandra, and Spark to support enterprise data warehouse needs.

• Data Security: Implement encryption, access control, and auditing practices to safeguard sensitive data.

• Collaboration: Partner with data architects, data scientists, and developers to translate business requirements into technical solutions.

• Documentation: Create and maintain technical documentation for database designs, ETL processes, and related systems.

• Continuous Learning: Stay current on emerging trends and best practices in database development, data warehousing, and big data technologies.

Qualifications & Experience

• Bachelors or Masters degree in Computer Science, Engineering, or related field.

• 8+ years of experience in database development with specialization in Oracle, Cassandra, and Spark.

• Expert knowledge of Oracle database architecture, SQL, PL/SQL, and performance tuning.

• Strong hands-on experience with Cassandra data modeling, CQL, and cluster management.

• Proficiency in Apache Spark, including Spark SQL, Spark Streaming, and MLlib.

• Experience with ETL design, development, and optimization.

• Solid knowledge of data warehousing principles, data modeling tools, and best practices.

• Strong analytical, problem-solving, and debugging skills.

• Excellent communication and interpersonal skills; ability to work both independently and in cross-functional teams.

• Preferred Certifications: Oracle Certified Professional (OCP) or equivalent.

• Experience with cloud-based database services (AWS RDS, Azure SQL Database, Google Cloud Spanner) is considered an asset.

Location: Onsite. Toronto, ON or Ottawa, ON

Type of Job: Temporary, Contractor

Contract Start/End Date: Nov 1, 2025 to Oct 31, 2026

Length of Contract: 12 months with the possibility of extension