Talent.com
Lead Database Administrator
Lead Database Administratordefi AUTO LLC • Buffalo, NY, US
No longer accepting applications
Lead Database Administrator

Lead Database Administrator

defi AUTO LLC • Buffalo, NY, US
23 hours ago
Job type
  • Full-time
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

    Create a job alert for this search

    Database Administrator • Buffalo, NY, US

    Related jobs
    Principal Data Architect

    Principal Data Architect

    VirtualVocations • Buffalo, New York, United States
    Full-time
    A company is looking for a Principal Data Architect- Databricks.Key Responsibilities Design and implement complex technical solutions as the Technical Architect for large-scale projects Define t...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator - Senior - st catharines

    Database Administrator - Senior - st catharines

    VGen Technologies LLC • st catharines, on, ca
    Full-time
    Database Administrator - Senior.Resource will work remotely, though must be available for onsite meetings when required.The Database Administration team is in the process of working on several larg...Show more
    Last updated: 5 days ago • Promoted
    Senior Database Administrator

    Senior Database Administrator

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 30+ days ago • Promoted
    Senior Director of Database Management

    Senior Director of Database Management

    VirtualVocations • Buffalo, New York, United States
    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-...Show more
    Last updated: 26 days ago • Promoted
    Microsoft SQL Server Administrator

    Microsoft SQL Server Administrator

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 1 day ago • Promoted
    Database Administrator for PostgreSQL

    Database Administrator for PostgreSQL

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 22 hours ago • Promoted • New!
    Oracle Certified Data Architect

    Oracle Certified Data Architect

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 22 hours ago • Promoted • New!
    Application Administrator

    Application Administrator

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator - Senior - VGen Technologies LLC

    Database Administrator - Senior - VGen Technologies LLC

    VGen Technologies LLC • niagara falls, on, ca
    Full-time
    Database Administrator - Senior.Resource will work remotely, though must be available for onsite meetings when required.The Database Administration team is in the process of working on several larg...Show more
    Last updated: 5 days ago • Promoted
    Big Data Lead

    Big Data Lead

    VirtualVocations • Buffalo, New York, United States
    Full-time
    A company is looking for a Big Data Lead.Key Responsibilities Oversee and manage data processes using Azure, Databricks, ADF, and Pyspark / Python Understand design and source to target mapping (S...Show more
    Last updated: 30+ days ago • Promoted
    OnBase Administrator III

    OnBase Administrator III

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 4 days ago • Promoted
    Senior Data Architect

    Senior Data Architect

    VirtualVocations • Buffalo, New York, United States
    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 ...Show more
    Last updated: 30+ days ago • Promoted
    SQL Database Administrator

    SQL Database Administrator

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 30+ days ago • Promoted
    iBase Administrator

    iBase Administrator

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 4 days ago • Promoted
    Data Warehouse Architect

    Data Warehouse Architect

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator

    Database Administrator

    TradeJobsWorkForce • 14212 Buffalo, NY, US
    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...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator - Senior

    Database Administrator - Senior

    VGen Technologies LLC • niagara falls, on, ca
    Full-time
    Database Administrator - Senior.Resource will work remotely, though must be available for onsite meetings when required.The Database Administration team is in the process of working on several larg...Show more
    Last updated: 5 days ago • Promoted
    Oracle Database Administrator

    Oracle Database Administrator

    VirtualVocations • Buffalo, New York, United States
    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...Show more
    Last updated: 30+ days ago • Promoted
    Junior Database Administrator

    Junior Database Administrator

    VirtualVocations • Buffalo, New York, United States
    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 ...Show more
    Last updated: 30+ days ago • Promoted
    Database-as-a-Service Engineer

    Database-as-a-Service Engineer

    VirtualVocations • Buffalo, New York, United States
    Full-time
    A company is looking for a Database-as-a-Service (DBaaS) Engineer responsible for building and maintaining Microsoft SQL Server clusters and infrastructure. Key Responsibilities Design, build, and...Show more
    Last updated: 22 hours ago • Promoted • New!