We need : A senior (10+ years) Database developer with extensive experience working with Mongo, SQL, Redis and ETL. Experience with Banking or Financial services are a plus but not required.
- Candidates must have Long Projects / Good Tenure, Excellent communication skills and a State issued ID (Not Bills) showing they are Local.
- CANDIDATES MUST ALREADY BE IN CANADA
THE MANAGER WILL CONSIDER RELOCATION FOR CANDIDATES WHO ARE ALREADY IN CANADA AND ARE CURRENTLY LEGALLY ABLE TO WORK IN CANADA NOW.
Required Location : Hybrid / Toronto, ON or Halifax, NS 3 days a week.
Contract status : C-C preferred
Interview Required : Video
Candidate Visa's Accepted : No Opt.
Candidates must be LOCAL to the Hybrid Toronto, ON or Halifax, NS area and COMMUTE into the office THREE TIMES A WEEK.
Job Description :
We are seeking a talented and motivated Database Developer with expertise in MongoDB, SQL, Redis Caching, and ETL / Transformation to join our dynamic team. In this role, you will be responsible for developing and maintaining database solutions, optimizing performance, and ensuring the integrity and reliability of our data infrastructure. You will work closely with cross-functional teams to create and implement data models, perform data mapping, and handle complex ETL transformations. The ideal candidate will be proficient in database design, query optimization, and caching strategies, with an understanding of modern technologies like Node.js being a valuable plus.
Key Responsibilities :
- Design, develop, and maintain MongoDB, SQL, and Redis database solutions.
- Implement ETL (Extract, Transform, Load) processes to ensure seamless data flow between systems.
- Perform data transformation and mapping to ensure data is consistent, accurate, and readily accessible for analytics and reporting.
- Design and optimize database schemas and data models for performance, scalability, and reliability.
- Monitor and tune SQL queries for optimal performance, ensuring minimal latency and maximum throughput.
- Work with Redis to implement caching strategies to improve data retrieval times and reduce database load.
- Collaborate with other teams to design and integrate data solutions that meet business and technical requirements.
- Ensure data integrity and consistency across multiple environments, performing regular data audits and cleanup tasks.
- Maintain up-to-date knowledge of database technologies, industry best practices, and emerging trends in data engineering.
- Provide support for database-related issues, including troubleshooting performance bottlenecks and resolving technical challenges.
Qualifications :
- Proven experience as a Database Developer with a strong focus on MongoDB, SQL, and Redis.
- Expertise in data transformation, ETL processes, and data mapping.
- Solid understanding of database modeling techniques and best practices.
- Experience optimizing complex SQL queries for performance.
- Familiarity with Node.js (a plus) for integrating database systems with backend applications.
- Strong analytical and problem-solving skills.
- Experience with database version control tools and methodologies.
- Knowledge of cloud-based database platforms (e.g., AWS RDS, Azure SQL Database) is a plus.
- Excellent communication skills and the ability to collaborate effectively within a team.
Preferred Skills (Pluses) :
- Experience with Node.js for building and integrating database-driven applications.
- Familiarity with cloud database platforms like AWS or Azure.
- Understanding of advanced data modeling techniques and distributed database architectures.