Database Administrator

Phyton Talent Advisors

Charlotte, NC, United States

1 day ago

Apply on www.disabledperson.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.disabledperson.com

Tech stack

Microsoft Windows Data Analysis Microsoft Azure Cluster Analysis Databases System Configuration Data Integrity Data Recovery Database Design Database Security RAID Microsoft SQL Server

+18 more

Operational Databases Performance Tuning Windows PowerShell Query Optimization Standard Sql SQL Stored Procedures SQL Databases SQL Server Integration Services Subsystems Transact-SQL Scripting Cloud Platform System System Availability Database Optimization Indexer Database Backup Database Monitoring Network Server

Job description

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., * 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.

Requirements

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.