AVP/Database Architect

Overview Responsible for administering, securing and optimizing the Bank's database platforms across on‑premises Microsoft SQL Server and cloud services (e.g., Azure SQL, Microsoft Fabric and Snowflake). Ensure high availability, performance, resilience and regulatory compliance of enterprise data assets. Implement and test backup/restore processes aligned to Recovery Point Objective / Recovery Time Objective ("RPO/RTO"). Partner with Data Analytics, Infrastructure and Information Security to deliver a reliable, well‑governed data foundation that enables reporting, automation and AI initiatives. Responsibilities Administer on‑premises SQL Server (installation, configuration, patching), Azure SQL (PaaS/MI), and Snowflake environments; manage schemas, roles, and resource usage. Implement, monitor, and continuously improve backup, restore, and disaster recovery procedures; validate RPO/RTO via periodic restore tests and documented runbooks. Design and maintain high availability configurations (e.g., Always On Availability Groups, failover strategies) and capacity plans across environments. Proactively tune performance (indexes, statistics, query plans), remediate blocking/long‑running queries, and optimize resource consumption. Build and operate data ingestion and integration pipelines to Snowflake (e.g., via Fiserv Data Compass, ADF/SSIS, secure file transfers); manage the Microsoft Data Gateway cluster and refresh schedules supporting BI workloads. Harden data platforms using least privilege, role‑based access control, encryption at rest/in transit (Transparent Data Encryption ("TDE"), Transport Layer Security ("TLS")), and data classification/retention policies. Monitor platforms with jobs, alerts and dashboards (SQL Agent, Azure Monitor/Log Analytics, Snowflake ACCOUNT_USAGE). Automate routine tasks using PowerShell, TSQL and/or Azure CLI. Execute changes through formal change management with peer review, version control, and documented rollback procedures; participate in after‑hours maintenance windows as needed. Support audits and examinations (internal audit, external/third party), provide evidence, and resolve findings related to database configuration, access, and recovery. Collaborate with Data Analytics, Application Subject Matter Experts ("SMEs"), Infrastructure/Networking, and InfoSec on data modeling, connectivity, network paths (e.g., ExpressRoute), and secure vendor integrations. Create and maintain current system documentation, standard operating procedures ("SOPs"), and architecture/runbook diagrams; train peers and provide knowledge transfers. Qualifications Bachelor's degree in computer science, information systems or equivalent experience required. Minimum 2 years experience administering Microsoft SQL Server in production including installation, High Availability and Disaster Recovery ("HA/DR"), backup/restore, performance tuning and security. Information Technology Infrastructure Library ("ITIL") change management and operations in regulated financial services environments required. Azure SQL (Managed Instance and/or Azure SQL Database) and Snowflake (roles, warehouses, storage, cost management) hand‑on experience required. Automating with PowerShell and/or Azure CLI experience required. Strong TSQL scripting skills required. Data integration (ADF/SSIS), secure data movement and managing on‑premise/cloud connectivity experience required. Microsoft Power BI Gateway clusters and performance/refresh optimization experience preferred. Microsoft Certified: Azure Database Administrator Associate (DP300) preferred. Microsoft Certified: Azure Data Engineer Associate (DP203) preferred. Snowflake SnowPro Core Certification preferred. ITIL 4 Foundation; CompTIA Security+ certification or equivalent preferred. MS Office proficiency required. Excellent written and verbal communication skills. WORKING CONDITIONS The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Regular attendance and punctuality are essential functions of every job. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential functions. Perform routine and typical tasks of an office such as typing, taking notes, reading/reviewing, computer work, filing, copying, answering phones, etc. that may require employee to view, stand, stoop, kneel, or crouch and lift. Position requires flexibility and willingness to be available to work generally during normal business hours, but can include early mornings, evenings and weekends. The successful candidate will be required to prove on the first day of work that they are legally authorized to work in the U.S. The Bank will not sponsor a candidate for a visa or for work authorization. COMPENSATION $110,000 to $135,000 annually #J-18808-Ljbffr