Database Offres d'emploi - Toronto, ON

We are currently seeking a full-time permanent Database Engineer to join our Technology team.

As a Database Engineer, you will be responsible for ensuring the performance, availability, and security of databases within the organization. You will also play a crucial role in designing, implementing, and maintaining large-scale data processing systems that handle sizable amounts of structured and unstructured data. Your role involves managing, maintaining, and optimizing databases to meet the needs of the business and its users, architecting data pipelines, optimizing data workflows, and ensuring the scalability, reliability, and performance of data solutions. You will work closely with other members of the IT team to ensure seamless integration and efficient operation of database systems.

The duties and responsibilities of the Database Engineer include but are not limited to :

• Design and Architecture : Develops database schemas, tables, and relationships. Designs scalable and fault-tolerant data architectures that leverage modern design principles to process and analyze large datasets.
• Database Configuration : Ensures proper settings and configurations are in place for optimal performance and security of all Relational Database Management Systems.
• Data Ingestion and Integration : Develops robust data ingestion pipelines to collect, extract, transform, and load (ETL) data from various sources, including databases, streaming platforms, and APIs. Implements data processing workflows to cleanse, enrich, and transform raw data into usable formats for analytics, reporting, and machine learning applications.
• Performance Tuning : Monitors database performance and identifies opportunities for optimization. Tunes database queries, indexes, and other performance-critical elements to enhance efficiency and response times.
• Backup and Disaster Recovery : Implements and manages backup and disaster recovery procedures to safeguard data against loss or corruption. Tests procedures regularly to ensure reliability.
• Application Performance Optimization : Optimizes data processing algorithms, data structures, and resource utilization to maximize performance, reduce latency, and improve throughput in big data systems.
• Security Management : Enforces security best practices to protect sensitive data from unauthorized access, breaches, or cyberattacks. Manages user access privileges, roles, and permissions, and data lineage throughout various data processing system.
• Troubleshooting and Issue Resolution : Investigates and resolves database-related issues, such as performance bottlenecks, and system errors. Provides timely support to stakeholders. Collaborates with cross-functional teams to resolve system issues.
• Automation and Scripting : Develops scripts and automation workflows to streamline repetitive tasks, such as data imports, exports, and maintenance activities. Embraces automation tools to improve operational efficiency.
• Research and Innovation : Stays abreast of emerging trends, technologies, and best practices in big data, machine learning, and artificial intelligence. Experiments with new tools and techniques to drive innovation and enhance data engineering capabilities.
• Documentation and Reporting : Maintains comprehensive documentation of database configurations, data processing procedures, and security policies.

Critical Competencies

Requirements

Additional Information

RPIA is proud to be Great Place to Work Certified™. What sets us apart?

RPIA is an Equal Opportunity Employer

We believe in the power of diversity of thought, and we aspire to have an inclusive workplace that mirrors the fabric of our community. We strongly encourage applications regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, or disability status. We are committed to providing an accessible and equitable application and hiring process and will make accommodations should you require it at any point. We encourage you to connect with us at if you require accommodation during the recruitment process.

Our culture is defined by our five core values : excellence, partnership, transparency, integrity, and community. Our clients often say the outstanding service we deliver is as important to them as the returns we achieve for them. With over 100 employees and $14 billion under management for a broad investor base of institutions and private clients, we proudly remain privately owned by employees who invest alongside our clients.