Database Administrator

We are seeking an experienced Microsoft SQL Server Database Administrator (DBA) to support a major Securities-Backed Lending (SBL) platform implementation. The project will implement Supernova’s SBL system, integrate with lending, brokerage, and trust platforms, automate underwriting and decisioning processes, and replace the existing FastNet/Broadridge collateral monitoring system. The DBA will be responsible for the design, administration, monitoring, security, availability, and performance of enterprise SQL Server databases across on-premises and Azure cloud environments.

Key Responsibilities

Install, configure, administer, and maintain Microsoft SQL Server databases across Windows-based on-premises and cloud environments.

Monitor production databases to ensure high availability, reliability, security, and performance.

Perform SQL Server performance tuning and query optimization and proactively identify performance bottlenecks.

Implement and support high-availability technologies including Always On, clustering, mirroring, and replication.

Develop, manage, and test database backup, recovery, restore, and data refresh processes.

Manage database objects including schemas, tables, views, indexes, stored procedures, triggers, and integrity constraints.

Review database schemas, stored procedures, DDL changes, and database designs.

Create, maintain, configure, and troubleshoot SSIS packages.

Develop and maintain SQL/T-SQL stored procedures and scripts.

Support database security, access controls, and data integrity.

Partner with application developers, business intelligence, analytics, and infrastructure teams.

Recommend and implement database configuration and architecture improvements.

Develop and maintain database standards, procedures, configuration guidelines, and best practices.

Support automation and database administration activities using PowerShell and related scripting tools.

Required Qualifications:

5+ years of Microsoft SQL Server DBA experience, including SQL Server 2012 or newer.

5+ years supporting production database environments.

Strong experience with SQL Server high availability, including Always On, clustering, mirroring, and/or replication.

Strong SQL and T-SQL programming experience.

Experience with Azure cloud database design and implementation.

Strong knowledge of database performance tuning, query optimization, table design, and index design.

Hands-on experience creating, configuring, and troubleshooting SSIS packages.

Experience with PowerShell scripting and database automation.

Experience with database backup, recovery, restores, and automated data refreshes.

Experience with database monitoring and performance management solutions.

Knowledge of infrastructure and hardware concepts including servers, networks, SAN, RAID, and I/O subsystems.

Key Skills:

Microsoft SQL Server | SQL Server DBA | T-SQL | Azure | SSIS | Always On | Clustering | Replication | Mirroring | Performance Tuning | Query Optimization | PowerShell | Backup & Recovery | Database Security | Indexing | Database Monitoring | Production Support