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.

• 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, Azure Data Factory/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 controls, encryption at rest/in transit (Transparent Data Encryption (TDE), TLS) and data classification/retention policies.
• Monitor platforms with jobs, alerts and dashboards (SQL Agent, Azure Monitor/Log Analytics, Snowflake ). Automate routine tasks using Power Shell, T‑SQL 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 SMEs, Infrastructure/Networking and Info Sec on data modeling, connectivity, network paths (e.g., Express Route) and secure vendor integrations.
• Create and maintain current system documentation, SOPs, and architecture/runbook diagrams; train peers and provide knowledge transfers.

• 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, 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) hands‑on experience required.
• Automating with Power Shell and/or Azure CLI required.
• Strong T‑SQL 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 (DP‑300) preferred.
• Microsoft Certified:
  Azure Data Engineer Associate (DP‑203) preferred.
• Snowflake Snow Pro Core Certification preferred.
• ITIL® 4 Foundation;
  CompTIA Security+ certification or equivalent preferred.
• MS Office proficiency required.
• Excellent written and verbal communication skills.

Regular attendance and punctuality are essential functions. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential functions.

The job requires routine office tasks such as typing, taking notes, reading/reviewing, computer work, filing, copying and answering phones. Tasks may require viewing, standing, stooping, kneeling or crouching and lifting. The position requires flexibility and willingness to be available during normal business hours and may include early mornings, evenings and weekends.

The successful candidate must be legally authorized to work in the U.S. The Bank will not sponsor a candidate for a visa or work authorization.

$110,000 to $135,000 annually.

Mid‑Senior level

Full‑time

Other

Banking