This job has closed.

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 Microsoft SQL Server and cloud services. The role involves ensuring high availability, performance, resilience, and regulatory compliance of enterprise data assets while collaborating with various teams to deliver a reliable data foundation.

BankingFinancial Services

Growth Opportunities

No H1B

U.S. Citizen Only

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 SQLSnowflakeT-SQL scriptingPowerShellData integrationITIL change managementMicrosoft Power BIMS Office proficiencyCommunication skills

Required

Bachelor's degree in computer science, information systems or equivalent experience

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

Azure SQL (Managed Instance and/or Azure SQL Database) and Snowflake (roles, warehouses, storage, cost management) hand-on experience

Automating with PowerShell and/or Azure CLI experience

Strong T - SQL scripting skills

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

MS Office proficiency

Excellent written and verbal communication skills