Talent.com
Lead Database Administrator

Lead Database Administrator

defi AUTO LLCPierre, SD, 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

Job Description

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 :

Reasonable accommodations may be made to enable individuals with disabilities to perform these 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.

  • 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.

    serp_jobs.job_alerts.create_a_job

    Database Administrator • Pierre, SD, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Technical Writer

    Technical Writer

    TradeJobsWorkForce57544 Kennebec, SD, US
    serp_jobs.job_card.full_time
    Research, write, edit and proofread complex technical data.Create, maintain and update manuals, procedures, specifications and other documents. Create, maintain and update installation instructions,...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    UAT Test Lead (Consulting)

    UAT Test Lead (Consulting)

    Edwards Lifesciences BelgiumPierre, SD, United States
    serp_jobs.job_card.full_time
    SolomonEdwardsGroup, LLC (SolomonEdwards) is a full-service professional services firm offering financial, operational, and technology consulting and operations support. We work with some of the wor...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Senior Integration Architect

    Senior Integration Architect

    OraclePierre, SD, US
    serp_jobs.job_card.full_time
    This Integration Architect (IA) role within the Oracle Health Consulting organization will support the Population Health project team delivering our federal engagements. Focused predominantly on our...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Computer Programmer

    Computer Programmer

    TradeJobsWorkForce57544 Kennebec, SD, US
    serp_jobs.job_card.full_time
    Computer Programmer Job Duties : Code and test programming for software and mobile apps.Develop and deploy ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Principal Software Engineer, OCI

    Principal Software Engineer, OCI

    OraclePierre, SD, US
    serp_jobs.job_card.full_time
    We're seeking experienced and driven developers, experienced in Linux internals, virtualization and container technologies, to join a new Service Platform team within Oracle Cloud Infrastructure (O...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    NA Sales Representative, Data Platform - FSI

    NA Sales Representative, Data Platform - FSI

    OraclePierre, SD, US
    serp_jobs.job_card.full_time
    Oracle is leading the digital revolution.We are empowering nearly half a million businesses across the globe to turn untapped potential into real business value. You will connect the biggest enterpr...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Senior Software Engineer, Backend (Developer - Foundations)

    Senior Software Engineer, Backend (Developer - Foundations)

    CoinbasePierre, SD, US
    serp_jobs.job_card.full_time
    Ready to be pushed beyond what you think you're capable of?.At Coinbase, our mission is to increase economic freedom in the world. It's a massive, ambitious opportunity that demands the best of us, ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_hour
    Oracle is hiring : Senior Principal User Experience Designer in Pierre

    Oracle is hiring : Senior Principal User Experience Designer in Pierre

    MediabistroPierre, SD, United States
    serp_jobs.job_card.full_time
    Oracle Applications Labs (OAL) powers the technology that runs Oracle-from CX and HCM to ERP and Datacenter-driving the design, development, and enhancement of nearly all of Oracle's most critical ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Intern - MarkOps Reporting Analyst - Summer 2026

    Intern - MarkOps Reporting Analyst - Summer 2026

    LumenPierre, SD, US
    serp_jobs.job_card.full_time
    We are igniting business growth by connecting people, data and applications - quickly, securely, and effortlessly.Together, we are building a culture and company from the people up - committed to t...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Sr. Solutions Architect - SDDC

    Sr. Solutions Architect - SDDC

    SHIPierre, SD, US
    serp_jobs.job_card.full_time
    Since 1989, SHI International Corp.We've grown every year since, and today we're proud to be a $15 billion global provider of IT solutions and services. Over 17,000 organizations worldwide rely on S...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_hour
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Lead Quality Engineer - Cypress Automation

    Lead Quality Engineer - Cypress Automation

    CognizantPierre, SD, US
    serp_jobs.job_card.full_time
    Lead Quality Engineer - Cypress Automation.You will be a valued member of the Quality Engineering team and work collaboratively with cross-functional stakeholders, including developers, DevOps engi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    Data Governance & Integration Developer / Specialist

    Data Governance & Integration Developer / Specialist

    satagroupSouth Dakota, South Dakota, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Data Governance & Integration Developer / Specialist.Sioux Falls, South Dakota (Remote / Hybrid possible).W2, Fulltime or 1099 - $60 on C2C. We are looking for a Specialist who work closely with IT team...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Lumen is hiring : Senior Lead User Experience Engineer in Pierre

    Lumen is hiring : Senior Lead User Experience Engineer in Pierre

    MediabistroPierre, SD, United States
    serp_jobs.job_card.full_time
    We are igniting business growth by connecting people, data and applications – quickly, securely, and effortlessly.Together, we are building a culture and company from the people up – committed to t...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Remote Side Hustle Developer

    Remote Side Hustle Developer

    Finance BuzzPierre, South Dakota, US
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    This position is for individuals who want to develop a side income stream while still working full time.You will test different small-scale remote opportunities, learn what works, and grow what pro...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Senior Strategy Advancement Professional - Conversational Experience Platform (CXP)

    Senior Strategy Advancement Professional - Conversational Experience Platform (CXP)

    HumanaPierre, SD, US
    serp_jobs.job_card.full_time
    Become a part of our caring community and help us put health first.We are seeking an accomplished and experienced Senior Strategy Advancement Professional to join the Conversational Experience Plat...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Sr Mgr, Business Systems

    Sr Mgr, Business Systems

    Public Consulting GroupPierre, SD, US
    serp_jobs.job_card.full_time
    Public Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve li...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Java Architect

    Java Architect

    TradeJobsWorkForce57544 Kennebec, SD, US
    serp_jobs.job_card.full_time
    Java Architect Job Duties : Achieves e-commerce information architecture operational obj...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Principal Software Engineer- OCI AI Services

    Principal Software Engineer- OCI AI Services

    OraclePierre, SD, US
    serp_jobs.job_card.full_time
    At Oracle Cloud Infrastructure (OCI), we are building the future of cloud computing-designed for enterprises, engineered for performance, and optimized for AI at scale. We are a fast-paced, mission-...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours