Talent.com
Lead Database Administrator
Lead Database Administratordefi AUTO LLC • Oklahoma City, OK, US
serp_jobs.error_messages.no_longer_accepting
Lead Database Administrator

Lead Database Administrator

defi AUTO LLC • Oklahoma City, OK, US
job_description.job_card.1_day_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 • Oklahoma City, OK, US

    Job_description.internal_linking.related_jobs
    Junior Database Administrator

    Junior Database Administrator

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for a Junior Database Administrator / Oracle-Azure.Key Responsibilities Provide basic escalation support for AmeriCorps applications utilizing Oracle databases Perform low to ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Microsoft SQL Server Administrator

    Microsoft SQL Server Administrator

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for a Microsoft SQL Server Database Administrator.Key Responsibilities Implement and administer database and data warehouse architecture Analyze data architectures and backe...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Data Warehouse Architect

    Data Warehouse Architect

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Warehouse Architect & AI Analytics Lead.Key Responsibilities Lead the design and implementation of extensions to a Data Vault 2. Architect and pilot predictive anal...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Oracle Database Administrator

    Oracle Database Administrator

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Oracle Database Administrator.Key Responsibilities Administer, monitor, and maintain Oracle databases (11g / 12c / 19c) Plan and execute end-to-end migration of Ora...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Sales Representative - 4 Day Work Week

    Sales Representative - 4 Day Work Week

    Platinum Supplemental Insurance • Yukon, Oklahoma
    serp_jobs.job_card.full_time
    Ready to jump-start your career and take charge of your earning potential?.At Platinum Supplemental Insurance, we’re looking for motivated individuals ready to learn, grow, and thrive in a fast-pac...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Insurance Sales Representative - 4 Day Work Week

    Insurance Sales Representative - 4 Day Work Week

    Platinum Supplemental Insurance • Yukon, Oklahoma
    serp_jobs.job_card.full_time
    Ready to jump-start your career and take charge of your earning potential?.At Platinum Supplemental Insurance, we’re looking for motivated individuals ready to learn, grow, and thrive in a fast-pac...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Application Administrator

    Application Administrator

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for an Application Administrator to join their Data Team.Key Responsibilities Support, develop, and maintain database systems for the Agency Review existing functionality an...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Database Administrator

    Senior Database Administrator

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Database Administrator (DBA) to lead the design, optimization, and sustainment of secure enterprise databases. Key Responsibilities Design, configure, and maintai...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Database Administrator for PostgreSQL

    Database Administrator for PostgreSQL

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Administrator for PostgreSQL.Key Responsibilities Administer, configure, and maintain PostgreSQL databases ensuring high availability and security Monitor and...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted
    Senior Director of Database Management

    Senior Director of Database Management

    VirtualVocations • Oklahoma City, Oklahoma, 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 capabilities, ensuring leadership in price-...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    iBase Administrator

    iBase Administrator

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for an iBase Administrator.Key Responsibilities Serve as the main point of contact for iBase across all branches Validate and enter data into the iBase and Service Portal M...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Entry Level Insurance Sales - Vehicle Required

    Entry Level Insurance Sales - Vehicle Required

    Platinum Supplemental Insurance • Yukon, Oklahoma
    serp_jobs.job_card.full_time
    Ready to jump-start your career and take charge of your earning potential?.At Platinum Supplemental Insurance, we’re looking for motivated individuals ready to learn, grow, and thrive in a fast-pac...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Outside Insurance Sales - 4 Day Work Week

    Outside Insurance Sales - 4 Day Work Week

    Platinum Supplemental Insurance • Yukon, Oklahoma
    serp_jobs.job_card.full_time
    Ready to jump-start your career and take charge of your earning potential?.At Platinum Supplemental Insurance, we’re looking for motivated individuals ready to learn, grow, and thrive in a fast-pac...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    SQL Database Administrator

    SQL Database Administrator

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for a SQL Database Administrator to join their IT Infrastructure team.Key Responsibilities Support a large-scale SQL Server environment with over 1000 databases and 60 SQL Se...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    OnBase Administrator III

    OnBase Administrator III

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for an OnBase Administrator / Developer III.Key Responsibilities Plan, design, develop, test, implement, and modify Electronic Content Management (ECM) solutions Provide advan...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Oracle Certified Data Architect

    Oracle Certified Data Architect

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Architect to support a long-term government contract.Key Responsibilities Lead a team of data analysts and database administrators Design and construct database a...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted
    Lead Database Administrator

    Lead Database Administrator

    defi AUTO LLC • Oklahoma City, OK, 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
    Entry Level Insurance Sales - 4 Day Work Week

    Entry Level Insurance Sales - 4 Day Work Week

    Platinum Supplemental Insurance • Yukon, Oklahoma
    serp_jobs.job_card.full_time
    Ready to jump-start your career and take charge of your earning potential?.At Platinum Supplemental Insurance, we’re looking for motivated individuals ready to learn, grow, and thrive in a fast-pac...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Entry Level Insurance Sales Representative - 4 Day Work Week

    Entry Level Insurance Sales Representative - 4 Day Work Week

    Platinum Supplemental Insurance • Yukon, Oklahoma
    serp_jobs.job_card.full_time
    Ready to jump-start your career and take charge of your earning potential?.At Platinum Supplemental Insurance, we’re looking for motivated individuals ready to learn, grow, and thrive in a fast-pac...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Data Architect

    Senior Data Architect

    VirtualVocations • Oklahoma City, Oklahoma, United States
    serp_jobs.job_card.part_time
    A company is looking for a Senior Data Architect (Part time) to lead the design, optimization, and governance of enterprise data models and integrations. Key Responsibilities : Design and maintain ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted