Sr Lead, Infra DB Admin

About Northern Trust:

Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.

Northern Trust is proud to provide innovative financial services and guidance to the world’s most successful individuals, families, and institutions by remaining true to our enduring principles of service, expertise, and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service.

GENERAL DESCRIPTION:

This is an exciting opportunity for an experienced Microsoft SQL server Database Administrator who can immediately begin to add value to the Northern Trust Database Engineering division.

The successful candidate will be part of a high touch team of DBAs engaged in supporting new Project development, Engineering efforts and Production Health/Stability at Northern Trust.

The DBA will be responsible for sharing the support of the existing database infrastructure, working on problem resolution, root cause analysis (RCA) , deep dive troubleshooting.

The DBA will be required to fully understand the inner workings of the Northern Trust Database Environment they support.

You will be working with database administrators, application owners, business partners and other Infrastructure divisions to deliver the best possible product and solution for Northern Trust.

Proactive engagement with Engineering and Managed Services teams will be needed to address issues in the infrastructure and avoid potential outages.

Responsibilities and Required Skills

• Strong experience with the management of Microsoft SQL server;

• Senior level technical skills in MS SQL Server 2008 R2 through 2022 including system installation and upgrade, backup and recovery, data server migration, release management, troubleshooting, performance tuning, working with developers and third party vended products. Expertise in SSIS jobs, SQL server Agent Job, Control M jobs and maintenance plans

• Experience with management of Microsoft SQL server failover clustering, Always On, Availability Groups, replication and database mirroring features.

• Familiar with Installing and supporting particular features such as Integration Services, Reporting Services and Analysis Services.

• Experience and managing 3rd party vendor applications. Good working knowledge of, and confidence administering on Windows.

• Scripting skills required for automation of database jobs e.g. Monitoring, Alerting, stats gathering.

• Ability to thoroughly research and independently handle Audit and Regulatory requests.

• Experience working within Agile project management processes.

• Methodical and accurate while delivering tasks, working within project deadlines.

• Systematic approach to identifying issues and pursuing paths to resolution;

• Ability to foresee relevant issues and assist in proposing possible solutions, Performance and Tuning expertise a must, root cause analysis in a Firecall situation;

• Experience with MS SQL Enterprise Monitoring tools;

• Management of multiple schemas/databases through system development, User Acceptance testing and production environment;

• Fixing or enhancing infrastructure scripts (backups, expanded monitoring and alerting, etc)

• Space and Capacity Validation.

• Fixing systemic problems that arise from an incident.

• Updating build scripts that have new requirements (new user account, new permissions, different configuration, new versions etc.)

• Building out and scheduling maintenance jobs

• Deploying scripts across the environment

• Proactively validating the environment (services missing, inconsistent configurations, periodic checks and fixes) and addressing the problems

• Focus on Production stability and resiliency.

COMPETENCIES

Ability to cope in a technically complex and fast-changing environment, and to respond calmly and rationally to changing priorities in a deadline-driven situation.

Strong planning and organizing skills including the ability to manage several work streams simultaneously.

Ability to think strategically and evaluate options in the short, including capacity planning at medium and long term.

Good communication skills with a capacity to present, discuss and explain issues coherently and logically both in writing and verbally.

Clear decision-making ability with the facility to judge complex situations and assess when to escalate issues.

Ability to balance conflicting and changing demands through prioritization and a pragmatic approach.

Demonstrated leadership ability to plan and delegate work.

Good team player, self-motivated and able to work on own initiative.

Qualifications

• Minimum of 9 years of experience in administrating medium to large databases in complex enterprise environments

• Strong scripting and automation skills using PowerShell

• Experience with SQL Server AlwaysOn on large database clusters

• Experience with Azure SQL Server and Azure SQL Server MI

• Database experience from working on engineering or project implementations team

• BS in Computer Science or equivalent experience

• Cohesity backup knowledge a plus

• Experience in the Financial Industry a plus

• Exposure on other Database Management Platforms a plus

Working with Us:

As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas.

Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose.

We’d love to learn more about how your interests and experience could be a fit with one of the world’s most admired and sustainable companies! Build your career with us and apply today. #MadeForGreater

Reasonable accommodation

Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com.

We hope you’re excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people.

Apply today and talk to us about your flexible working requirements and together we can achieve greater.