Apply on Employer Site

Kearny Bank · 2 days ago

AVP/Database Architect

Fairfield, NJ

Full-time

Onsite

Mid Level

$110K/yr - $135K/yr

2+ years exp

Kearny Bank is seeking an AVP/Database Architect responsible for administering, securing, and optimizing the Bank's database platforms across on-premises and cloud services. The role involves ensuring high availability, performance, and regulatory compliance of enterprise data assets while collaborating with various teams to deliver a reliable data foundation for reporting and automation initiatives.

BankingFinancial Services

Growth Opportunities

No H1B

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”), Transit 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, 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 Subject Matter Expert (“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

Qualification

Microsoft SQL ServerAzure SQLSnowflakePowerShellT-SQL scriptingData integrationITIL change managementMicrosoft Certified Azure Database Administrator AssociateMicrosoft Certified Azure Data Engineer AssociateSnowflake SnowPro Core CertificationCompTIA Security+ certificationMS Office proficiencyCommunication skills

Required

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 T‑SQL scripting skills required

Data integration (ADF/SSIS), secure data movement, and managing on-premise/cloud connectivity experience required

MS Office proficiency required

Excellent written and verbal communication skills