Original job description
Job Title: Database Developer
Location: Toronto, ON (3x onsite a week)
Employment Type: Contract
Pay Rate: CAD$45/HR INC
Key Responsibilities
Design and develop database schemas, tables, stored procedures, functions, and other database objects for Oracle, Cassandra, and Spark environments.
Develop logical and physical data models that meet business requirements and ensure data integrity, consistency, and performance.
Design, develop, and implement ETL (Extract, Transform, Load) processes to move data between different database platforms and data sources, using tools like Apache Spark, Apache NiFi, or Oracle Data Integrator.
Optimize database performance by identifying and resolving performance bottlenecks, tuning queries, and implementing indexing strategies.
Write complex SQL queries and NoSQL queries (CQL) to retrieve, manipulate, and analyze data.
Develop Spark applications using Python to process large datasets and perform data analytics.
Design and implement data warehousing solutions using Oracle, Cassandra, and Spark, following best practices for data modeling, ETL, and reporting.
Implement data security measures to protect sensitive data, including encryption, access control, and auditing.
Collaborate with data architects, data scientists, application developers, and other stakeholders to understand business requirements and develop appropriate data solutions.
Create and maintain technical documentation for database designs, ETL processes, and other data-related solutions.
Stay up to date with the latest trends and technologies in database development, data warehousing, and big data processing.
Qualifications
Bachelor's or master s degree in computer science, Engineering, or a related field.
8+ years of experience in database development, with a strong focus on Oracle, Cassandra, and Spark.
Expert-level knowledge of Oracle database architecture and development, including SQL, PL/SQL, and performance tuning.
Strong understanding of Cassandra NoSQL database, including data modeling, CQL, and cluster administration.
Proficiency in Apache Spark, including Spark SQL, Spark Streaming, and Spark MLlib.
Experience with ETL tools and techniques.
Solid understanding of data warehousing principles and best practices.
Experience with data modeling tools and techniques.
Strong analytical and problem-solving skills.
Excellent communication and interpersonal skills.
Ability to work independently and as part of a team.
Oracle Certified Professional (OCP) or equivalent certification is a plus.
Experience with cloud-based database services (e.g., AWS RDS, Azure SQL Database, Google Cloud Spanner) is a plus.
Disclaimer: AI tools may assist in the recruitment process; however, all hiring decisions are made by the recruitment team based on a comprehensive evaluation of candidates.
More about this job
Responsibilities
Design and develop database schemas, data models, database objects, and ETL processes across Oracle, Cassandra, and Spark environments. Optimize database performance, build Spark applications for large-scale data processing, implement data security, and document solutions in collaboration with stakeholders.
Requirements
Requires a bachelor's or master's degree in computer science, engineering, or a related field, and 8+ years of database development experience focused on Oracle, Cassandra, and Spark. Candidates should have strong Oracle SQL and PL/SQL expertise, Cassandra data modeling and CQL knowledge, Spark proficiency, and experience with ETL, data warehousing, and data modeling.
Skills
- Oracle Database Development
- Cassandra
- Apache Spark
- SQL
- PL/SQL
- CQL
- Python
- ETL
- Data Modeling
- Database Performance Tuning
- Data Warehousing
- Spark SQL
- Spark Streaming
- Spark MLlib
- Apache NiFi
- Oracle Data Integrator
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
Keywords
- Oracle
- Cassandra
- Apache Spark
- SQL
- PL/SQL
- CQL
- Python
- Apache NiFi
- Oracle Data Integrator
- ETL
- Data Modeling
- Logical Data Models
- Physical Data Models
- Database Performance Tuning
- Indexing
- Spark SQL
- Spark Streaming
- Spark MLlib
- Data Warehousing
- Data Security
- Encryption
- Access Control
- Auditing
- Oracle Certified Professional
- AWS RDS
- Azure SQL Database
- Google Cloud Spanner
- Big Data Processing
- Database Development
