Sr Database Engineer (PostgreSQL)ContractMississauga

We are seeking a senior-level Application Developer / PostgreSQL Database Engineer to help build the next generation of a self-service analytics and portfolio management platform. While the team has an existing R Shiny web application, the primary focus of this role is designing and developing the underlying PostgreSQL data platform that will serve as the long-term source of truth for project and portfolio reporting.

The ideal candidate will come from a Data Engineering, Database Engineering, or Backend Engineering background and have experience designing scalable relational databases, building data models, and supporting data-driven applications. This individual will play a key role in establishing historical data tracking, improving data lineage, and creating a structured, scalable foundation for analytics. Experience with web application development, particularly R Shiny, is preferred but secondary to strong database and data architecture expertise.

Responsibilities

• Design and develop a PostgreSQL database to serve as the centralized source of truth for portfolio and project management data.
• Create and maintain logical and physical data models, including table structures, relationships, and schema design.
• Design indexing strategies and optimize database performance for reporting and application workloads.
• Develop solutions to support historical data retention, daily snapshots, and long-term trend analysis.
• Establish data lineage and governance practices to improve visibility and trust in reporting data.
• Partner with stakeholders to understand reporting and application requirements and translate them into scalable database solutions.
• Design and support the applications data access layer.
• Serve as a secondary resource for the teams R Shiny web application to reduce single points of failure.
• Collaborate with application developers to ensure efficient integration between the application and database.
• Support enhancements to existing web-based analytics solutions and self-service reporting capabilities.
• Contribute to application deployment, monitoring, and support activities as needed.
• Implement development best practices including version control, testing, and documentation.
• Support CI/CD processes and deployment automation where appropriate.
• Participate in application modernization efforts, including containerization and cloud-native deployment practices.
• Help establish scalable engineering processes as the platform continues to grow.

Required Qualifications

• 5-7+ years of experience in Database Engineering, Data Engineering, Backend Engineering, or a similar technical role.
• Strong hands-on experience with PostgreSQL.
• Experience designing:Database schemasTable structures and relationshipsPrimary and foreign key strategiesIndexing and query optimizationRelational data models
• Strong understanding of data architecture and data management best practices.
• Experience supporting applications from a database perspective, including the design of data access layers.
• Strong SQL development skills.
• Experience working with large,
  
  
  
  evolving datasets and establishing historical tracking strategies.
• Ability to troubleshoot performance issues and optimize database workloads.
• Strong communication skills and ability to work directly with technical and business stakeholders.

Preferred Qualifications

• Experience with R Shiny.
• Experience developing or supporting web applications using technologies such as:ReactJavaScript/TypeScriptOther modern web frameworks
• Experience with CI/CD pipelines and modern software delivery practices.
• Containerization experience (Docker, Kubernetes, etc.).
• Experience designing analytics or reporting platforms.
• Familiarity with portfolio management, project management, or operational reporting data.
• Exposure to AI-assisted development tools and modern software engineering workflows.
• Experience working with API integrations and application data services.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Everforth Apex Benefits Overview:

In terms of career development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA.