Database Engineer

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

• Technical Knowledge – Profound knowledge in data architecture, real-time analytics, and cloud computing platforms, especially within financial services. Expert knowledge of data modeling, ETL processes, and data warehousing concepts.
• Attention to Detail – Meticulous attention to precision in data handling and system design to ensure the integrity and reliability of our data platforms.
• Problem Solving – Exceptional analytical skills with the ability to tackle complex technical challenges and innovate solutions.
• Communication – Excellent communication skills, capable of articulating complex data concepts to non-technical stakeholders.
• Teamwork – Strong aptitude to work well with others and support a thriving, team-first culture.

Requirements

• Bachelor's or Master’s degree in Computer Science, Data Engineering, or a related field
• Minimum of 5 years of experience as a DBA, Data Engineer, or similar role, with a focus on designing and implementing large-scale data processing systems
• Experience with cloud platforms and services, such as AWS (EMR, S3, Glue), Azure (HDInsight, Data Lake, Data Factory), or Google Cloud (Dataproc, BigQuery)
• Experience with SQL Server and MySQL
• Strong knowledge of and experience with real-time analytics, persistent data stores, data modeling techniques, and adept data pipeline management
• Proficient in various programming languages (Python/C#/Java) and adept with tools required for developing complex APIs and executing streaming or real-time data processes
• Experience with cloud platforms and services, such as AWS (EMR, S3, Glue), Azure (HDInsight, Data Lake, Data Factory), or Google Cloud (Dataproc, BigQuery)
• Familiarity with containerization technologies (e.g., Docker, Kubernetes) and orchestration tools (e.g., Apache Airflow) is considered an asset

Additional Information

• Position Type: Full-Time Permanent
• Work Location: Toronto To learn more about life at RPIA, visit
• Read our firm’s magazine, Voices of RPIA:

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

• Exceptional single and family benefits package that includes health, dental, and vision insurance plus additional Health Care Spending and Wellness credits.
• Employee and Family Assistance Program to support mental well-being and extends to all family members in your household.
• Opportunities for professional and personal growth through: Cross-functional Mentorship Program, Internally-curated Leadership Skills training program, Community outreach opportunities and monthly team socials.

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.