Senior MS-SQL DBA – Performance Tuning

Job title: Senior MS-SQL DBA – Performance Tuning

Job description: We offer:

– To work with some of the best professionals in the business – for a firm that values individual intellect as much as teamwork
– State-of-the-art offices that are designed to maximize collaboration
– Flexible working arrangements
– Enriching challenges that provide opportunity for constant learning and advancement
– An environment which is leveraging technology to its highest potential

Team Profile:

Enterprise Technology & Services (ETS) delivers shared technology services for the Firm supporting all business applications and end users. ETS provides capabilities for all stages of the Firm’s software development lifecycle, enabling productive coding, functional and integration testing, application releases, and ongoing monitoring and support for over 3,000 production applications.

ETS also delivers all workplace technologies (desktop, mobile, voice, video, productivity, intranet/internet) in integrated configurations that boost the personal productivity of our employees. Application and end user services are delivered on a scalable, secure, and reliable infrastructure composed of seamlessly integrated datacenter, network, compute, cloud, storage, and database services.

Position Description:

SQL Server operations DBA team in North America based in Montreal and provides global operations support for SQL Server plant.

The team is responsible for SQL plant’s administration, security, performance, upgrades and manages day-to-day functions like performance troubleshooting, patches and tasks like backup recovery and changes to the environment.

This position is for a senior level SQL Server operation DBA. He/She will be responsible for SQL Server plant’s health and must be able to perform day to day functions like managing security and access, backup and restores, upgrades, performance trouble shooting etc. candidate must have good verbal and written communication skills and should be able to work with others within and outside of the team. Performance and tuning of user issues and code is must have skill.

Qualifications

Required skills:

– Candidate should have at least 8 years’ experience working with Microsoft SQL Server as an operations DBA.
– University degree in computer science or equivalent
– Senior level Performance, Tuning and Troubleshooting experience on large SQL Server production databases is a MUST have requirement.
– A demonstrated proficiency in supporting the database platform of a large organization
– Prior experience with SQL Server Clustering, strong Transact-SQL skills are highly desired
– Ability to quickly troubleshoot and resolve complex problems in a live environment
– Excellent interpersonal skills and ability to articulate complex ideas and solutions to users
– Self-motivation with the ability to work independently and as a strong team player
– Flexibility to support the operations of our businesses, from time to time, on call on a rotation basis

Nice to have:

– Prior experience with Always ON, Replication, Backup and recovery methods including 3rd party tools like nexGen, Database Mirroring, Database capacity planning and Users and Role creation and monitoring.

About us:

Morgan Stanley is a global financial services firm and a market leader in investment banking, securities, investment management and wealth management services. At Morgan Stanley Montreal, we are shaping the future of our global business and contributing to our local community. Our team works across numerous areas.

Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximise their full potential. Our skilled and creative workforce is comprised of individuals drawn from a broad cross section of the global communities in which we operate and who reflect a variety of backgrounds, talents, perspectives and experiences. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing and advancing individuals based on their skills and talents.

Knowledge of French and English is required.

Spotlight on our Montreal Technology Centre: https://www.youtube.com/watch?v=oo5GaXpCwKs
*Video dated October 2019.

Build a career with impact. Visit morganstanley.com for more information.

Company: Morgan Stanley

Expected salary:

Location: Montreal, QC

Job date: Sat, 13 Mar 2021 05:07:19 GMT