Database designer • toronto on
Scotiabank’s Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data platform products across the globe where Scotiaban... Show more
Join our Enterprise Technology Services team!.Our team is responsible for analyzing, resolving, building, and maintaining complex backend databases in support of multiple business applications.Coor... Show more
Backend Application Developer - Job Description.We are currently looking for an experienced application developer who is well-versed in database-centric application development and will support the... Show more
Our Toronto client is a recognized leader in the fashion industry.They require a highly-qualified .TECHNICIAN/ TECHNICAL DESIGNER.Work with the Creative Director, CEO, Product Developers and Design... Show more
We are seeking an Intermediate Database Administrator to manage the physical design, administration, and optimization of enterprise database management systems (DBMS).This role requires a technical... Show more
Up to 5 days onsite ( subject to HM's discretion) - 525 University Avenue Toronto.The Database Administrator will support the next phase of the modernization strategy, OH is committed to migra... Show more
Pay at Intact is about much more than just salary.Multiple benefits offered to support.Wellness account and much more.Share plan & other savings: up to.Employee Share Purchase Plan (ESPP) – with In... Show more
Database Administration (DBMS).Develops and optimizes database code (schemas| queries| procedures) Supports performance tuning and indexing Builds migration scripts and data validation checks Ensur... Show more
Are you a hands-on database developer who loves designing scalable data systems, optimizing complex queries, and building robust data solutions? RBC is looking for a Lead Database Developer to help... Show more
Architect, design, and mature the ServiceNow CMDB, including class models, relationships, attributes, and lifecycle states.Lead the transition toward a fully CSDM‑aligned CMDB, ensuring data struct... Show more
BMO is an organization driven by a shared Purpose: Boldly Grow the Good in business and life.It calls on members of its team, to create lasting, positive change for its customers, its communities, ... Show more
Database Engineering - Master-Level Internship.Hours (approximately 3 months) .Remote (with hybrid options in Toronto).The Vosyn internship is unique.Remuneration is equivalent to $32.CAD per ... Show more
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Develop and maintain applications on Oracle / MS SQL database based on business requirements.De... Show more
At SAP, we keep it simple: you bring your best to us, and we'll bring out the best in you.We're builders touching over 20 industries and 80% of global commerce, and we need your unique talents to h... Show more
Join Livingston and grow your career in the constantly changing world of international trade.Livingston is a market leader offering customs brokerage, international trade consulting, compliance and... Show more
At Stantec, we have some of the world’s leading professionals passionate about enabling our business to be its best.Our business teams include finance, procurement, human resources, information tec... Show more
Are you a hands-on database developer who loves designing scalable data systems, optimizing complex queries, and building robust data solutions? RBC is looking for a Lead Database Developer to help... Show more
Marsh McLennan’s Database Services team is growing rapidly, and we have an exciting opportunity for a creative and inquisitive Senior Database Administrator skilled in Postgres and Oracle.This hybr... Show more
Story Behind the Need:
Scotiabank’s Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data platform products across the globe where Scotiabank is present. Physical & logical database services, from deployment, project support and after go live steady state support is the essence of what we do.
Reporting to the DBA Manager/Lead, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud. As a member of the database administration group, you will assist in the team effort to maximize the availability, security, and performance of the databases.
Candidate Value Proposition:
The successful candidate will have the opportunity to work within Scotiabank. We are technology partners who help the business transform how our employees around the world work. You will get to work with and learn from diverse industry leaders, who have hailed from top technology.
Typical Day in Role:
• Configuration planning & deploying MSSQL servers on public cloud and on-premise
• servers.
• Performance tunning, capacity planning and monitoring.
• Database maintenance/housekeeping including database rebuilds/re-indexing/expansion and
• archiving.
• Trouble-shoot MSSQL server problems and assist in the resolution of application problems.
• MSSQL Server Software currency resolution including Patching/Upgrades/Migrations.
• Assist in database code promotions & data fixes following internal change control process.
• Disaster Recovery/High Availability (DR/HA) support with backup, recovery and
• failover/failback of local and remote replicated databases.
• Provide DBA support to development/implementation projects as assigned, doing
• installations, database loading, migrations, testing, and go live support etc.
• Follow Database best practices, security and change control process of the bank.
Candidate Requirements/Must-Have skills:
1. 8-10+ years of progressive technical working experience as a Database Administrator.
2. 5+ years of experience with Public Cloud including GCP Cloud SQL (MSSQL) and Azure MI/DBaaS/IaaS database administration.
3. Hands on experience with MSSQL Services (SSRS/SSAS/SSIS/PolyBase, R Service, Power BI etc.) and MSSQL Instance/Database Installation/Configuration/Hardening.
5. Hands on experience with Scripting and Automation with Power Shell, C#, VB Scripts, SSIS, TSQL etc.
Nice-To-Have Skills:
• Microsoft and/or Google Data Platform certification.
• Windows Servers 2019/2016 and prior versions.
• AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity.
• Application side tuning vs. server-side tuning.
• Setup MSSQL Always-On, Availability groups & Database Replication.
• Logical & Physical Backup/Recovery/Compression techniques.
Soft Skills:
• You have good analytical, problem solving, trouble shooting and automation skills.
• You are a quick learner, with good communication (verbal/written) skills to be collaborate with other technical teams and business stakeholders. This includes attending meetings and sharing technical documentations.
Best vs. Average Candidate:
• Must meet the must-have requirements.
• Previous experience working in FI with regulatory/compliance environment.
Education:
• Post-secondary education in Computer Science, Math, or related discipline.
Candidate Review & Selection
• One round interview – Hiring manager & team member (1 hour)
o 90% of the interview will be assessing technical skills listed in the must-have requirements such as Public Cloud, Database Security, etc. and 10% will be assessing soft skills/team fit.
Job 70494
