Press tab to move to skip to content link
select how often (in days) to receive an alert:
requisition id: 224028
join a purpose-driven, winning team committed to results in an inclusive and high-performing culture.
purpose
the team provides end-to-end data platform operational support for microsoft data platform products globally. Responsibilities include managing physical & logical database services, from deployment and project support to post-go-live support.
reporting to the dba manager, the senior dba supports ms sql. As part of the database administration team, the senior dba helps maximize database availability, security, and performance.
the senior dba must be available for rotational after-hours support, including remote and occasional on-site support for routine monitoring alerts and maintenance tasks during evenings and weekends.
key accountabilities
* configure, plan, and deploy ms sql servers on cloud and on-premise environments.
* perform performance tuning and monitor database health.
* conduct routine maintenance such as rebuilds, re-indexing, expansion, and archiving.
* troubleshoot ms sql server issues and assist in resolving application problems.
* manage server upgrades and migrations.
* support database code promotions and data fixes.
* implement disaster recovery and high availability solutions, including backup and recovery of local and remote replicated databases.
* provide dba support for development and implementation projects, including installations, data loading, migrations, and testing.
* participate in incident resolution and troubleshooting with other teams.
knowledge & skills
* minimum 5+ years of progressive experience as a database administrator, with at least 2 years in mssql administration and operations.
* practical knowledge of ms sql server versions 2016-2022, windows servers 2019-2022, azure iaas, mi, dbaas, and gcp cloud sql mssql support.
* experience with sql always-on, database replication, data encryption/masking, backup/recovery techniques, and sql server services (ssrs, powerbi, ssas, ssis, polybase, r service).
* strong analytical, problem-solving, troubleshooting, and automation skills.
* quick learner with excellent communication and interpersonal skills.
* experience with tsql and scripting languages is an asset.
educational requirements
* post-secondary education in computer science, math, or a related field.
* microsoft data platform certification is an asset.
we value the diverse skills and experiences each person brings and are committed to an inclusive environment. All employees must adhere to policies on non-discrimination and workplace accommodations. If you need accessibility accommodations during the process, inform our talent acquisition team.
note: we will never request pregnancy or hiv tests.
location
mexico: ciudad de méxico, miguel hidalgo
scotiabank is a leading bank in the americas, guided by our purpose: "for every future." we support our customers and communities with a broad range of financial services.
applicants must apply online. Only shortlisted candidates will be contacted.
#j-18808-ljbffr