Talent.com
Lead Database Administrator
Lead Database Administratordefi AUTO LLC • Buffalo, NY, US
Lead Database Administrator

Lead Database Administrator

defi AUTO LLC • Buffalo, NY, 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 • Buffalo, NY, US

    Job_description.internal_linking.related_jobs
    Team Member

    Team Member

    Tractor Supply Company • Springville, NY, US
    serp_jobs.job_card.full_time +1
    The Team Member is responsible for interacting with customers and team members, supporting selling initiatives and performing assigned tasks, while delivering a Legendary Customer Experience.Do you...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Travel MedSurg RN in Buffalo, New York

    Travel MedSurg RN in Buffalo, New York

    Gifted Healthcare • Angola, NY, US
    serp_jobs.job_card.full_time
    MedSurg RNs provide bedside care for a variety of patients and execute individualized patient assessments to create an individualized plan of care. MedSurg RNs prepare equipment and assist physician...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    Information Systems Technician

    Information Systems Technician

    Navy • Williamsville, NY, United States
    serp_jobs.job_card.full_time
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Project Coordinator

    Project Coordinator

    Schlesinger Group • Wilson, NY, US
    serp_jobs.job_card.full_time
    Sago is a global leader in market research and data solutions, committed to connecting human answers to business questions. The world is transforming, and Sago is continuously reaching new heights, ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Customs and Border Protection Officer - Experienced (GS9)

    Customs and Border Protection Officer - Experienced (GS9)

    U.S. Customs and Border Protection • Silver Creek, NY, US
    serp_jobs.job_card.full_time
    Customs and Border Protection (CBP) offers those interested in a career in law enforcement an exceptional opportunity to work with an elite team of highly trained professionals whose camaraderie, p...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    BSA-AML Analyst space

    BSA-AML Analyst space

    United IT • Buffalo, NY, US
    serp_jobs.job_card.full_time
    Location : 5 days onsite in Buffalo, Ny.Type : Fte Visa H1b, Gcead, Gc, Usc Job Description : 3+ Yrs Exp Bsa Coming From Banking Domain.serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Database Administrator

    Database Administrator

    TradeJobsWorkForce • 14228 Buffalo, NY, US
    serp_jobs.job_card.full_time
    Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining th...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    General Cardiologist – Lockport, New York

    General Cardiologist – Lockport, New York

    Catholic Health System • Lockport, US
    serp_jobs.job_card.full_time
    Trinity Medical Cardiology, a large, non-profit, well-established physician practice with several locations in the Buffalo / Niagara region, is seeking highly skilled board certified / eligible noninva...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Cell Operator

    Cell Operator

    API Delevan • East Aurora, NY, US
    serp_jobs.job_card.full_time +1
    DELEVAN is an electronics manufacturer of Inductors, Radio Frequency coils, chokes, transformers, and resolvers with a strong brand for over 75 years, and the only manufacturer in the world with Mi...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Customs and Border Protection Officer

    Customs and Border Protection Officer

    U.S. Customs and Border Protection • Angola on the Lake, NY, US
    serp_jobs.job_card.full_time
    Customs and Border Protection (CBP) offers those interested in a career in law enforcement an exceptional opportunity to work with an elite team of highly trained professionals whose camaraderie, p...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Dir of Clinical Systems / Informatics / Meditech / Athena

    Dir of Clinical Systems / Informatics / Meditech / Athena

    Provisions Group • Amherst, NY, United States
    serp_jobs.job_card.temporary
    We are seeking an experienced healthcare IT leader to serve as Interim Director of Clinical Systems & Informatics, with oversight of Meditech Client / Server, Athena One, and Clinical Informatics ini...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Direct Support Professional Derby / Angola area

    Direct Support Professional Derby / Angola area

    SUBURBAN ADULT SERVICES INC. • Derby, NY, US
    serp_jobs.job_card.full_time
    As a direct support professional, the DSP is responsible for delivering quality services while maintaining a safe and therapeutic environment that supports the emotional and physical well-being of ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    Reserve Entomologist

    Reserve Entomologist

    United States Army • Wilson, NY, US
    serp_jobs.job_card.full_time
    THE ARMY HEALTH CARE ADVANTAGE As a member of the Army health care team, you’ll receive benefits that you won’t be able to get in a civilian career. Challenging Work Feel inspired with great case di...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted
    Contract Administrator

    Contract Administrator

    Moog • East Aurora, NY, US
    serp_jobs.job_card.full_time
    Moog is a performance culture that empowers people to achieve great things.Our people enjoy solving interesting technical challenges in a culture characterized by mutual respect and empowerment.For...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Active Urologist

    Active Urologist

    United States Army • North Collins, NY, US
    serp_jobs.job_card.full_time
    THE ARMY HEALTH CARE ADVANTAGE As a member of the Army health care team, you’ll receive benefits that you won’t be able to get in a civilian career. Challenging Work Feel inspired with great case di...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    Database Specialist

    Database Specialist

    TradeJobsWorkForce • 14217 Kenmore, NY, 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
    Database Development

    Database Development

    TradeJobsWorkForce • 14208 Buffalo, NY, US
    serp_jobs.job_card.full_time
    Database Development Job Duties : Database Developers are responsible for data gathering before development of ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Team Leader

    Team Leader

    Tractor Supply Company • Hamburg, NY, US
    serp_jobs.job_card.full_time +1
    The Team Leader is responsible for assisting the Store Manager and Assistant Store Manager with the execution of operational, sales, and merchandising objectives by delivering a Legendary Customer ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Data Engineer

    Data Engineer

    SynapOne • Amherst, NY, United States
    serp_jobs.job_card.full_time
    Job Title : Data Engineering Contractor.Join our dynamic team of talented engineers with a proven track record in constructing data. We are on a mission to fuel Unite Us' ongoing expansion and.This p...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Entry-Level Border Patrol Agent – $30,000 Sign-On Bonus

    Entry-Level Border Patrol Agent – $30,000 Sign-On Bonus

    United States Customs and Border Protection • Irving, NY, US
    serp_jobs.job_card.full_time
    IMPORTANT NOTICE : Duty assignments available at time of offer may include the Southwest Border including prioritized locations. Border Patrol determines duty assignments at time of offer based on op...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new