Staff Database Administrator

Job description

Are you ready to join a growing team that puts a premium on productivity and has an award-winning culture centered around transforming talented employees into effective business leaders? Then BHG Financial is the place for you. In 2001, we started with an idea, an opportunity, and $25,000. Back then, our focus was strictly 
on serving those in the medical industry. With healthcare in our heritage, we soon expanded 
to serve high-earning professionals in many 
other industries, providing all with leading-edge financial solutions, including our extensive network of community banks. Today, BHG Financial has firmly established 
its legacy as a leader in the financial services space. Founded on the philosophy of a better way to borrow, we are dedicated to helping accomplished professionals, small businesses, and institutions build upon their success through innovative financial solutions, a hassle-free process, and personalized concierge service. Our relentless commitment to the success of our customers is part of what has made BHG Financial thrive. We take a 360-degree view of our customers to tailor the best solutions for their financial aspirations. Today's professionals have multiple sources of income, not just their paycheck. Therefore, it is essential to factor those in when making responsible lending decisions. Our continued focus on data, analytics, and proprietary modeling has enabled faster funding for our customers. From business to personal loans to relationships with community banks, the country’s top professionals and business owners rely on us for our exceptional financial solutions and concierge service to continue their success and legacy. **Who You Are** We are seeking a Senior SQL Server Database Administrator with extensive experience managing, optimizing, and securing mission-critical SQL Server environments. Proven expertise in advanced T-SQL development, performance tuning, high availability, and disaster recovery. Great communication skills working independently and collaborating with development and infrastructure teams. Proven experience finding database and system issues before they happen. A strong independent thinker who will bring their expertise in database administration. ### What You'll Do - Design, implement, and administer Microsoft SQL Server environments (on-premises and/or cloud) - Experience with On Prem SQL, Azure SQL and Managed Instance. - Strong experience work with large Terabyte databases. - Develop, optimize, and maintain complex T-SQL code including stored procedures, functions, views, triggers, and indexes - Perform advanced query tuning and execution plan analysis to improve performance - Monitor database health, capacity, and performance using native and third-party tools - Implement and manage High Availability and Disaster Recovery (HA/DR) solutions (Always On) - Expert level setup and administration of SQL clusters and always on Availability Groups. - Manage and implement Change Data Capture - Manage backup, restore, and recovery strategies; perform regular DR testing - Ensure database security through role-based access, encryption, auditing, and compliance controls - Troubleshoot and resolve production issues, root-cause analysis, and performance bottlenecks - Automate administrative tasks using T-SQL, SQL Agent jobs, and PowerShell - Collaborate with developers to enforce database design and coding best practices - Support application releases, schema changes, and data migrations with minimal downtime - Experience working with sensitive data and removing data from lower environments. - Strong experience working with Auditing solutions – SQL Audit, Extended Events or custom monitoring accounts and user access. - Other duties as assigned. ### What You'll Need - 10+ years of hands-on SQL Server DBA experience - Senior-level T-SQL skills (query optimization, indexing strategies, complex joins) - Deep understanding of SQL Server internals (locking, blocking, tempdb, memory, I/O) - Strong experience with performance tuning and monitoring. - Experience with SQL Server versions 2016 and above - Solid knowledge of backup/restore, HA/DR, and capacity planning - Experience supporting large, high-transaction databases - Strong troubleshooting and analytical skills - Excellent communication and documentation abilities - Travel requirement: All roles require travel during the first 6 months of employment to attend the BHG Oars in Experience. After the initial 6 months, ongoing travel is expected at approximately ~5% annually for periodic team on-sites, team meetings, and cross-functional collaboration. **Preferred Qualifications** - Experience with Azure SQL Database, Managed Instance, or SQL Server on Azure VM - PowerShell scripting for SQL Server automation - Exposure to DevOps / CI-CD pipelines for database deployments - Experience with data migration and upgrade projects