Senior Database Administrator - Express Scripts

The Cigna Group•Mississauga, ON

53d•$95,000 - $115,000•Hybrid

About The Position

Express Scripts Canada is seeking a highly experienced Database Administrator (DBA) to join our Production Operations team. The ideal candidate will have over 10 years of hands-on DBA experience, including advanced expertise in both MS SQL Server and Oracle databases. You will collaborate with business stakeholders, project managers, and senior IS management to deliver robust database solutions, oversee implementation and maintenance, and drive best practices in database design and administration.

Requirements

Post-secondary education in computer science, information systems, or computer engineering.
10+ years of DBA experience strongly preferred
MS SQL Server and Oracle databases Strongly preferred
Experience with data architecting, large-scale data modeling, and business intelligence;
Direct experience implementing enterprise data management processes and decision support.
Strong understanding of relational database structures, theories, principles, and practices.
Experience in capacity planning, performance tuning, and troubleshooting for both SQL Server and Oracle.
Experience with multi-site replication, HA clustering, and disaster recovery solutions.
Knowledge of Web Services and SQL.
Excellent problem-solving and communication skills.
Strategic vision for database direction within the organization.
Hands-on experience with enterprise repository and data modeling tools.
Proficiency with Microsoft Office suite (MS Project, PowerPoint, Visio).

Nice To Haves

Experience with Oracle Exadata, DataGuard and VEEAM backup solutions exposure considered an asset
VEEM backup solutions exposure.
Experience with Oracle Exadata and DataGuard.
Database management/monitoring tools.
Microsoft Dynamics.
Experience with batch scheduling systems.
Knowledge of the Pharmacy Benefit Management Industry.
Bilingualism (French and English) is an asset.

Responsibilities

Lead database performance and capacity planning, defining frameworks and standards.
Collaborate with Project Managers, Software Development, and Business Analysts to ensure successful delivery of multiple initiatives.
Manage performance issues in custom code released to production.
Develop comprehensive test plans and maintain testing scripts.
Evaluate change management requests, including impact analysis and time/cost estimation.
Support and write scripts (Perl, shell, PL/SQL) for database monitoring and maintenance.
Define and implement database system architecture across environments.
Provide off-hour DB support on rotation as required.