MSSQL Database Consultant

Scotiabank; Torreón; Presencial; MXN 400,000 - 600,000; Jornada completa

Descripción de la vacante

A leading bank in the Americas is looking for a Senior DBA to manage MS SQL databases, performing tasks like troubleshooting, performance tuning, and disaster recovery. The role requires at least 5 years of experience, knowledge of MS SQL Server, and a strong ability to solve technical issues. Join a dynamic team in Torreón committed to enhancing database operational support.

Formación

• 5+ years of experience as a Database Administrator, with at least 2 years in MSSQL.
• Knowledge of SQL Always-On and Database Replication.
• Experience with data encryption and masking.

Responsabilidades

• Support MS SQL databases and provide on-call support.
• Conduct performance tuning and routine maintenance.
• Assist in disaster recovery and high availability tasks.

Conocimientos

MS SQL Server administration

Performance tuning

Troubleshooting

Database backup & recovery

Automation skills

Communication skills

Educación

Post-secondary education in Computer Science

Herramientas

MS SQL Server 2022/2019/2017/2016

Azure IaaS

GCP Cloud SQL

Descripción del empleo

Requisition ID: 224028

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

PURPOSE

The team takes care of end-to-end data platform operational 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, the Senior DBA would be supporting the MS SQL. As a member of the database administration group, the Senior DBA will assist in the team effort to maximize the availability, security, and performance of the databases.

The Senior DBA is required to take shifts and be on-call for rotational after-hours support of the bank’s databases. The Senior DBA must be prepared to provide remote dial-in support, or occasionally on-site support in response to routine monitoring alerts and scheduled & unscheduled maintenance tasks occurring after hours and on weekends.

Key Accountabilities

• Configuration planning & deploying MS SQL servers on cloud and on-premise servers.
• Performance Tunning and general health.
• Do routine maintenance including database rebuilds/re-indexing/expansion and archiving.
• Trouble-shoot MS SQL server problems and assist in the resolution of application problems.
• Server upgrades/migrations.
• Assist in database code promotions & data fixes.
• Disaster Recovery/High Availability (DR/HA), backup & recovery of local and remote replicated databases.
• Provide DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing, etc.
• Involve in database incidents calls and troubleshooting with other teams
  
  

Knowledge & Skills

• You have at least 5+ years of progressive technical working experience as a Database Administrator. At least 2 years of MSSQL Administration and Operation.
• You possess sound practical working knowledge of:
• MS SQL Server 2022/2019/2017/2016
• Windows Servers 2022/2019/2026
• Azure IaaS, MI and DBaaS database Support - GCP Cloud SQL MSSQL database support - Stored Procedures Tunning.
• Setup SQL Always-On & Database Replication
• Data Encryption & Masking
• Database Re-build / De-fragment techniques
• Logical & Physical Backup / Recovery techniques
• MS SQL Services installation/configuration of (SSRS/PowerBI/SSAS/SSIS/PolyBase, R Service)
• SQL Server side and application query tuning.
• You have good analytical, problem solving, trouble shooting and automation skills.
• You are a quick learner, with good interpersonal and communication (verbal/written) skills.
• Experience with the following would be an asset: TSQL, and script language
  
  

Educational Requirements

• Post-secondary education in Computer Science, Math, or related discipline.
• Microsoft Data Platform certification is an asset for this role.
  
  

At Scotiabank, we value the unique skills and experiences that each person brings to the bank and are committed to creating and maintaining an inclusive and accessible environment for all. All employees must comply with the bank's policies, standards, codes, and guidelines related to non-discrimination and workplace accommodations.

"If you need any accessibility accommodations during the process, please inform our Talent Acquisition team."

• Under no circumstances will we request pregnancy or HIV tests.**
  
  

Location(s): Mexico : Ciudad de México : Miguel Hidalgo

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, 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. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.