Database Architect

Database Architect

Job Information
Author pmnationtalk
Date May 6, 2021
Deadline Open
Type Full Time
Company Express Scripts Canada
Location Mississauga, ON
Category Arch / Engineering
Client Express Scripts Canada
Contact Information
Apply Now!

Express Scripts Canada is looking for a Database Architect to be part of the Infrastructure Strategy and Operations (ISO) team. The primary objective of the Database Architect will be to be a technical lead for ISO team working closely with Business stakeholders, Project Managers, IS Management to understand processes, business requirements and translate them into Database technology solutions.

The Database Architect role requires ability to create and analyze solutions based on business value while maintaining best design/development practices, procedures and guidelines throughout the Infrastructure Operations lifecycle.

Furthermore, the Database Architect acts as a subject matter expert in different Databases on various platforms, has the ability to perform end-to-end impact analysis of source system changes, capacity planning, performance tuning and troubleshooting.


  • Lead the Database design, conversion, migration, performance and capacity planning practice by defining and building the framework and standards, and delivering the related services
  • Work closely with Infrastructure team members, Project Managers, Software Development and Business Analysts to ensure successful delivery of Steady State for all projects and initiatives
  • Manage performance issues in all custom code released to production for optimal performance
  • Work closely with Technical Leads from other departments to ensure comprehensive solution design, and test plans according to business specifications and ensure that defects and fixes across prioritized systems are documented, tracked and closed
  • Evaluate change management requests to determine optimum testing process for the degree of change being implemented; including Time & Cost estimation with Impact analysis
  • Aid in the support/writing of Perl, OS (Shell, PowerShell) and PL/SQL scripts written to both monitor and maintain the Databases and support applications
  • Define Database architectures to be implemented uniformly across Production and Non-Production environments
  • Ability to provide after-hours Database support and guidance as required


  • Post-secondary degree in Computer Science, information systems or computer engineering
    • 8+ years of Database experience in Oracle, PostgreSQL, SQL Server, MySQL (MariaDB), MongoDB – with emphasis on Oracle, PostgreSQL
    • Comfortable with databases running in RedHat Linux, Windows environments;
    • Extensive experience with high volume transaction systems in a 3-tier architecture
    • Strong experience with highly available configurations (RAC), replication (DR), data migration scenarios, PI/PHI data de-identification
    • Familiar with adjacent technologies and products: GoldenGate, Oracle Enterprise Manager, Oracle Data Integrator (ETL), Advanced Security, Auditing databases, Oracle Wallet, Erwin or PowerDesigner
    • Prior exposure to performance and administration of SAN and NAS systems (NetApp Storage):
      LUN provisioning, FC, cloning/snapshotting
      Good knowledge of Security, certificates, shell scripting
    • Substantial experience with RHEL / CentOS, including hardware components (CPU, RAM, OS activity info), performance tuning
    • Good knowledge of Virtual Machines, including VMware specifics regarding database deployments in VMs, performance matters, constraints, benefits
    • Sound knowledge of networks, VLANs, subnets, firewalls, load balancers, Virtual IP addresses, DNS
    • Working experience in using capacity planning for cost-effective strategies to plan and design, for temporary scenarios and to meet long-term needs

Skills & Abilities:

  • Strong understanding of Database structures, theories, principles, and practices;
  • Proficient in scripting tools for automation, monitoring and tuning
  • Strong knowledge of Oracle products and technologies: Database, ASM, Data Warehouse, and associated products (OEM, GG, ODI)
  • Good understanding of middleware products and technologies: Oracle BI, Oracle WebLogic, including HA configurations
  • Excellent problem-solving skills, a self-starting attitude and presentation skills
  • Excellent communication skills and ability to communicate across multiple levels within the organization: Management, Production Operations, IT, Systems Administration, etc.
  • Prior exposure to the Health Care business is an asset
  • Excellent knowledge of backup and recovery scenarios
  • Be able to provide a strategic Database direction for the organization
  • Hands-On Knowledge of Microsoft Office suite (including MS Project, MS Power Point, Visio)
  • Flexible and adaptable to working additional hours and/or overtime
  • Occasional travel to Montreal and/or within the GTA

Express Scripts Canada is a Cigna company

Express Scripts Canada is a subsidiary of Express Scripts, a Cigna company. Cigna Corporation (NYSE: CI) is a global health service company dedicated to improving the health, wellbeing and peace of mind of those we serve. Cigna offers an integrated suite of health services through Cigna, Express Scripts, and our affiliates including medical, dental, behavioural health, pharmacy, vision, supplemental benefits, and other related products.

About Express Scripts Canada

Express Scripts Canada is a leading health benefits manager and has been recognized as one of the most innovative. Our clients include Canada’s leading insurers, third party administrators and governments. We work with these clients to develop industry-leading solutions to deliver superior healthcare in a cost-controlled environment. We provide Active Pharmacy™ services to more than 7 million Canadian patients and adjudicate more than 100 million pharmacy, dental, and extended health claims annually. Through our proprietary consumer intelligence, clinical expertise, and patients-first approach, we promote better health decisions for plan members, while managing and reducing drug benefit costs for plan sponsors.

It will be a condition of employment that the successful candidate obtains an Enhanced Reliability Clearance from the Federal Government. The candidate will be required to provide supporting documentation to receive clearance if required.

We offer a competitive salary and benefits package, along with a positive work environment built on solid corporate values, integrity, mutual respect, collaboration, passion, service and alignment.

We are an equal opportunity employer that promotes a diverse, inclusive and accessible workplace. By embracing diversity, we build a more effective organization that empowers our employees to be the best that they can be.

We are committed to creating a working environment that is barrier-free and we are prepared to provide accommodation for people with disabilities.

If you require accommodation in completing the online application process, please email: [email protected] Do not email [email protected] for an update on your application or to provide your resume as you will not receive a response.

Send To Friend Email Print Story

NationTalk Partners & Sponsors Learn More