Talent.com
Lead Database Administrator
Lead Database Administratordefi AUTO LLC • Madison, WI, US
serp_jobs.error_messages.no_longer_accepting
Lead Database Administrator

Lead Database Administrator

defi AUTO LLC • Madison, WI, US
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

About defi SOLUTIONS

It's an exciting time to join defi! defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lenders reduce time-to-market, streamline operations, and customize lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn.

Position Purpose

The Lead Database Administrator is responsible for managing all operational aspects of production and non-production database environments across multiple data centers supporting defi SOLUTIONS. This role oversees daily database performance, backups, tuning, patching, and overall maintenance of all database systems.

You will collaborate with operational and engineering teams to define requirements, architect solutions, and deliver reliable database services. Additionally, you'll work closely with Client Services, Relationship Management, and various development and technical teams to ensure the operational needs of both clients and internal users are consistently met.

This is a multifaceted role requiring strong communication, leadership, and technical expertise to maintain high availability, performance, and security across all database platforms. Participation with On-Call is a critical aspect of this role, ensuring 24 / 7 support and rapid response to production issues or outages.

Essential functions

  • Setup, configure and manage SQL Server Always On Availability Groups on virtual machines.
  • Primary responsibilities include installation, configuration, security management, patching, upgrades, backups, restores, environment refreshes, performance tuning, routine maintenance, disaster recovery planning and alerting / monitoring.
  • Support ongoing database maintenance tasks, many of which must be completed within defined maintenance windows to ensure system availability and compliance.
  • Support both Azure and AWS SQL Enviornments
  • Interact with clients, analysts, and other team members to resolve issues.
  • Assist less experienced team members and assist in problem resolution as necessary.
  • Critical On-Call support to participate in incident and problem management processes and provide support as needed to ensure system reliability and timely issue resolution.
  • Stay Current on emerging technologies
  • Collaborate with other members of the Operations Team to design and implement solutions
  • Open and Escalate cases with Microsoft when required
  • Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Required education and experience

  • Bachelor's degree or equivalent work experience
  • 10+ years' experience in an IT operations environment performing database administration.
  • 3+ years of experience with Azure portal and all topics in Azure related to database maintenance including SQLMI and AzureSQL with failover groups as well as Azure CLI
  • 3+ years of experience with AWS portal including CLI, S3, EC2, EBS and infrastructure knowledge
  • 3+ years of experience with SQL Server Always On Availability Groups
  • PowerShell Scripting experience
  • Deep knowledge of SQL internal functionality including but not limited to
  • Query Processing and Optimization

  • Reading and Analyzing Execution plans, table statistics, data distribution and execution times
  • Indexing Mechanisms
  • Types, Maintenance and impact

  • Transaction Management
  • Isolation levels, Locking mechanisms, deadlocks, etc.

  • Storage Architecture
  • Data Pages, filegroups, row / page compression, etc.

  • Expert in large database design (logical, physical, conceptual) for OLTP and data warehouse environments using the Microsoft platform.
  • Backup and Recovery

  • Backup types, Recovery Models, PITR, Disaster Recovery Planning, etc.
  • Experience with maintaining high availability SQL environments and Disaster Recovery Strategies.

    Security and Access Control

  • Authentication, Encryption, auditing, access requirements, etc.
  • Monitoring and Performance Tuning

  • Wait Statistics, Dynamic Management Views, Query Store, etc.
  • Wait Statistics, Dynamic Management Views, Query Store, etc.

  • Experience with Datadog, Elastic or New Relic
  • Maintenance and Housekeeping

  • Database Consistency checks, statistics updates, index maintenance, log file management.
  • Experience using SQL Server Agent to develop and schedule administration jobs, alerts and groups.
  • Effective analytical, communication, interpersonal and problem-solving skills.
  • No management experience is required.
  • Preferred education and experience

  • Knowledge in Snowflake Administration
  • Knowledge and experience working on Azure Cloud, Azure SQL and SQL Managed Instance is a plus
  • Knowledge in Azure resources such as Storage Accounts, Blob Storage, Keyvault, Azure Active Directory
  • Additional eligibility requirements

  • An achiever, self-starter, and eager to learn
  • You'll have a proven track record of results as we'll expect you to act decisively, think big, and manage your time and your team's time to meet deadlines in a fast-paced, high-volume environment.
  • Most importantly, you'll want to contribute to a diverse, supportive, and talented team.
  • Travel required

    Travel is potential to be 10% of time

    Affirmative Action / EEO statement

    defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.

    J-18808-Ljbffr

    serp_jobs.job_alerts.create_a_job

    Database Administrator • Madison, WI, US

    Job_description.internal_linking.related_jobs
    Database Developer

    Database Developer

    VirtualVocations • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Developer to design, implement, and maintain data processing systems.Key Responsibilities Gather requirements from stakeholders for data migration projects De...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    CDL-A Drivers : Historic Pay Increase! Earn Up To $0.66 Per Mile!

    CDL-A Drivers : Historic Pay Increase! Earn Up To $0.66 Per Mile!

    Millis Transfer Inc • Evansville, WI, USA
    serp_jobs.job_card.full_time
    STOP WHAT YOU’RE DOING — THIS IS BIG.Millis Just Launched a Historic Pay Raise for ALL Drivers!.Just more money in your pocket. Millis is raising the bar — and your paycheck.Orientation Now Offered ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Senior SQL Database Architect

    Senior SQL Database Architect

    VirtualVocations • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Database Architect.Key Responsibilities Design and implement database structures aligned with business requirements Collaborate with development teams to commun...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Senior Database Developer

    Senior Database Developer

    VirtualVocations • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Database Developer.Key Responsibilities : Design, develop, and maintain complex database solutions using Microsoft SQL Server Optimize queries, indexes, and perf...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    OnBase Administrator / Developer -III (Remote)

    OnBase Administrator / Developer -III (Remote)

    Serigor Inc. • Madison, WI, US
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    OnBase Administrator / Developer -III (Remote) Location : Madison, WI Duration : 12 Months Overview : This is an electronic document management system Administrator / Developer position.This position plan...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days
    Senior Director of Database Management

    Senior Director of Database Management

    VirtualVocations • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Director, Product Management, Database.Key Responsibilities Lead the vision, strategy, and execution for the database product roadmap and capabilities Collabora...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Senior SQL Database Developer

    Senior SQL Database Developer

    VirtualVocations • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    A company is looking for a Remote Sr.Key Responsibilities Design logical and physical data models and prepare statistical information for internal and external use Ensure database optimization, ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    ADABAS / DB2 Database Specialist

    ADABAS / DB2 Database Specialist

    VirtualVocations • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    A company is looking for an ADABAS / DB2 Database Specialist to provide technical support for Software AG's ADABAS product suite in a remote environment. Key Responsibilities Plan, install, configur...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Database Administrator - Operations Specialist

    Database Administrator - Operations Specialist

    Rural Mutual Insurance • Madison, WI, US
    serp_jobs.job_card.full_time
    We are seeking a dynamic and versatile professional to join our team in a unique hybrid role that combines Oracle Database Administration with modern infrastructure and DevOps engineering.This role...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Oracle EBS Database Administrator

    Oracle EBS Database Administrator

    VirtualVocations • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle EBS Application Database Administrator.Key Responsibilities Manage Oracle EBS Applications with a focus on HR / payroll modules, including upgrades and patching ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Oracle Database Administrator 1.19

    Oracle Database Administrator 1.19

    Focused HR Solutions • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Candidates will be allowed to work a hybrid on-site / remote schedule.The hybrid schedule is 2 days per week on-site work in Madison, WI. Candidate must relocate, if not local, and be located in Madis...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30
    Sr Safety Administrator (Underground)

    Sr Safety Administrator (Underground)

    TDS Telecom • Monroe, WI, US
    serp_jobs.job_card.full_time
    At TDS Telecom, connecting people is at the heart of everything we do.We are forward thinkers who leverage cutting-edge fiber internet technology to strengthen communities.We are dedicated to excel...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Sr Safety Administrator (Aerial)

    Sr Safety Administrator (Aerial)

    TDS Telecom • Monroe, WI, US
    serp_jobs.job_card.full_time
    At TDS Telecom, connecting people is at the heart of everything we do.We are forward thinkers who leverage cutting-edge fiber internet technology to strengthen communities.We are dedicated to excel...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Travel Nurse RN - House Supervisor - $1,896 per week in Monroe, WI

    Travel Nurse RN - House Supervisor - $1,896 per week in Monroe, WI

    TravelNurseSource • Monroe, WI, US
    serp_jobs.job_card.full_time
    TravelNurseSource is working with GetMed Staffing to find a qualified House Supervisor RN in Monroe, Wisconsin, 53566!.GetMed Staffing is searching for a strong RN Supervisor to assist our traveler...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Quality Lead

    Quality Lead

    CLASEN QUALITY CHOCOLATE • Milton, WI, US
    serp_jobs.job_card.full_time
    Clasen Quality Chocolate (CQC).We have recently been awarded the.Top Workplaces Award by the WI State Journal.Large Employer and the Benefits Award. CQC has been growing double digits annually becau...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Lead Database Administrator

    Lead Database Administrator

    defi AUTO LLC • Madison, WI, US
    serp_jobs.job_card.full_time
    It’s an exciting time to join defi!.SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive a...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    ADABAS Database Specialist

    ADABAS Database Specialist

    VirtualVocations • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    A company is looking for an ADABAS Database Specialist to join their team on a fully remote basis.Key Responsibilities Plan, install, configure, and implement SAG ADABAS software products and rel...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    ADABAS DB2 Database Specialist

    ADABAS DB2 Database Specialist

    VirtualVocations • Madison, Wisconsin, United States
    serp_jobs.job_card.full_time
    A company is looking for an ADABAS / DB2 Database Specialist to provide expert-level technical support in a remote setting. Key Responsibilities Plan, install, configure, customize, and implement SA...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Database Specialist

    Database Specialist

    TradeJobsWorkForce • 53502 Albany, WI, US
    serp_jobs.job_card.full_time
    Database Specialist Job Duties : Plans database upgrades by maintaining , evaluating, and improving a...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Analyst, Transportation

    Senior Analyst, Transportation

    Duluth Trading Company • Mount Horeb, WI, US
    serp_jobs.job_card.full_time
    We are seeking a dynamic and analytical professional to assume the role of Sr.Analyst, Transportation to support data and analysis to optimize Duluth Trading's small parcel shipping network.This ro...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted