SQL Server Database Production Support
At BNY, our culture allows us to run our company better and enables employees' growth and success. As a leading global financial services company at the heart of the global financial system, we influence nearly 20% of the world's investible assets. Every day, our teams harness cutting-edge AI and breakthrough technologies to collaborate with clients, driving transformative solutions that redefine industries and uplift communities worldwide.
Recognized as a top destination for innovators, BNY is where bold ideas meet advanced technology and exceptional talent. Together, we power the future of finance - and this is what #LifeAtBNY is all about. Join us and be part of something extraordinary.
We're seeking a future team member for the role of SQL Server Database Production Support to join our Technology Engineering Group team. This role is located in Lake Mary, Florida or Pittsburgh, Pennsylvania .
In this role, you'll make an impact in the following ways :
Key Responsibilities :
Oversee administration of SQL Server (2019, 2022) instances across all business lines, including installation, configuration, patching, upgrades, space management, and routine maintenance (statistics updates, reindexing, consistency checks, backup / recovery).
Collaborate with application teams to analyze query performance, utilize Query Store for consistent query performance, and advise on partitioning strategies for large data sets.
Manage Always On Availability Groups and clustering (4-node configurations), ensuring minimal replication lag, guiding secondary read-only usage, and handling planned / unplanned failovers.
Configure SQL Server authentication, create logins / users, and enforce least privilege access for applications and users.
Lead schema change processes using automation tools like GitLab and Liquibase, including rollback procedures.
Utilize Large Language Models (e.g., ChatGPT) to troubleshoot and manage complex SQL Server issues.
Experience with other data platforms (Oracle, Snowflake, Microsoft Fabric, PostgreSQL) is a plus.
To be successful in this role, we're seeking the following :
At BNY, our culture speaks for itself, check out the latest BNY news at :
BNY Newsroom
BNY LinkedIn
Here's a few of our recent awards :
Our Benefits and Rewards :
BNY offers highly competitive compensation, benefits, and wellbeing programs rooted in a strong culture of excellence and our pay-for-performance philosophy. We provide access to flexible global resources and tools for your life's journey. Focus on your health, foster your personal resilience, and reach your financial goals as a valued member of our team, along with generous paid leaves, including paid volunteer time, that can support you and your family through moments that matter.
BNY is an Equal Employment Opportunity / Affirmative Action Employer - Underrepresented racial and ethnic groups / Females / Individuals with Disabilities / Protected Veterans.
Sql Server Database • Lake Mary, FL, United States