Vice President, Production Services Infrastructure Support at BNY

Lake Mary, Florida, United States -

Full Time

Start Date

Immediate

Expiry Date

02 Mar, 26

Salary

0.0

Posted On

02 Dec, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Performance Tuning, Query Optimization, High Availability, Disaster Recovery, Security Management, Access Management, Database Schema Management, Automation Tools, AI Tools, Oracle, Snowflake, Microsoft Fabric, PostgreSQL, Azure SQL, Clustering

Industry

Financial Services

Description

SQL Server Platform Management: 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). Performance Tuning & Query Optimization: Collaborate with application teams to analyze query performance, utilize Query Store for consistent query performance, and advise on partitioning strategies for large data sets. High Availability & Disaster Recovery: Manage Always On Availability Groups and clustering (4-node configurations), ensuring minimal replication lag, guiding secondary read-only usage, and handling planned/unplanned failovers. Security & Access Management: Configure SQL Server authentication, create logins/users, and enforce least privilege access for applications and users. Database Schema Change Management: Lead schema change processes using automation tools like GitLab and Liquibase, including rollback procedures. Leverage AI/LLM Tools: 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. Bachelor's degree in computer science or a related discipline, or equivalent work experience required; advanced degree preferred. 8 - 10 years of related infrastructure experience required; experience in the securities or financial services industry is a plus. Experience managing Always On SQL Server clusters with 4-node configurations. SQL Server or Azure SQL certification; experience managing Azure SQL Managed Instances. Familiarity with AI/LLM tools for database management. Additional experience with other database platforms is advantageous.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

Oversee administration of SQL Server instances and manage performance tuning and query optimization. Ensure high availability and disaster recovery while leading schema change processes and leveraging AI tools for troubleshooting.