Sorry, this job is no longer available.

Database Analyst Advisory

 

Requisition ID: 36635

Join the Global Community of Scotiabankers to help customers become better off.

Job  Purpose:

The  incumbent would be an experienced  DBA who would be supporting the MS-SQL and Postgres database environment.  Would be required to manage and support databases for Production support and new projects.  As a member of the database administration group,  the incumbent will assist in the team effort to maximize the availability, security, and performance of the databases.

 

Key Accountabilities:

  • Configuration planning  and deploying  MS-SQL / Postgres  servers on cloud and on-prem servers.  Performance  and  general health / capacity   monitoring.  
  • Tuning and load balancing of servers.   Do routine maintenance including database rebuilds/re-indexing/expansion  and archiving.   
  • Trouble shoot  MS-SQL/Postgres   server problems, and assist in the resolution of  application  problems. 
  •  Server  upgrades and conversions.  
  • Assist in  promotions, data conversions. 
  • DR/HA, Backup  and  recovery of   local  and  remote replicated databases.  
  • Provide  beeper support to production systems  as assigned;  involves  week end and after hours support  on a rotating  basis.    
  • Provide DBA support to  development/implementation projects as assigned,  doing  installations, database loading, conversions,  testing etc.   
  • Prepare change control documentation.

 

Functional Competenices:

  • Sound practical knowledge of - MSSQL  2017/2016/2014/2012/2008, Windows 2012/2008 servers, Windows client  and Linux. 
  • Azure IaaS and DBaaS  database deployment and tools,   DB access with AD, firewall IP/Port, domain trust/authentication,  database device configuration/installation,  stored procedures, Setup  SQL Always-On,  Mirroring, Clustering and  database  replication, Data encryption and Masking ,  database re-build / de-fragment techniques,   logical & physical backup / recovery techniques, MSSQL services (SSRS/SSAS/SSIS/PolyBase,R Service), OLAP, Power BI, Application side tuning vs.  server side  tuning. 
  • Minimum  5  years of practical DBA  experience. Good analytical, problem solving, trouble shooting and automation skills. Quick learner, with good interpersonal and communication skills.    Experience  with  following would be an asset - Postgres, .Net, ASP,  C# , Power shell ,  Linux shell scripting.

 

Education/Experinece:

  • Post secondary education  in computer science, math,  or related discipline.   MCSE Data Platform certification preferred.

 

Location(s):  Canada : Ontario : Toronto

As Canada’s International Bank, we are a leader when it comes to inclusion. We are a diverse and global team, speaking more than 100 languages with backgrounds from more than 120 countries. We value the unique skills and experiences each individual brings to the bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Candidates selected for an interview will be contacted directly.  If you require accommodation during the recruitment and selection process, please let us know. We will work with you to provide as seamless a recruitment experience as possible.

Company
ScotiaBank
Posted
09/15/2018
Type
Full time
Location
Toronto, 08, CA