Database Developer Tech Lead

Holman•Remote - AZ, AZ

5d•$105,050 - $149,700•Remote

About The Position

Holman is a family-owned, global automotive services organization anchored by our deeply rooted core values and principles that have enabled us to continue Driving What’s Right throughout the last century. Our teams deliver the Holman Experience by treating our customers and each other as we would like to be treated, and creating positive, rewarding relationships all around. The automotive markets Holman serves include fleet management and leasing; vehicle fabrication and upfitting; component manufacturing and productivity solutions; powertrain distribution and logistics services; commercial and personal insurance and risk management; and retail automotive sales as one of the largest privately owned dealership groups in the United States.

Requirements

Bachelor’s degree in a related field or equivalent work experience
Proficient in various desktop tools including MS Office Programs (i.e. Outlook, Excel, Word, PowerPoint, Project, Visio, SharePoint etc.)
Azure AZ900, DP900, DP-300 training required
Minimum 5 years tenure as a Database Administrator
Experienced with relational architecture and Data Warehouse
Minimum 3 years' experience with installing, configuring, and supporting Oracle and/or SQL server database environments
Experience with Azure SQL database environments.
Understanding of Azure ecosystem and database services like Azure Blob Storage, Azure Data Lake, Azure Key Vault, etc.
Must be well versed with database procedures to include: installation, configuration, backup and recovery, performance tuning, and SQL statement tuning
Experience using ETL tools to document and move data as needed
Experienced with Linux operating system and shell scripting
Experienced with Windows Server operating systems

Nice To Haves

Additional education, certifications, or other distinctions are a plus
Azure certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Solutions Architect Expert are highly preferred
Experienced with scripting languages and automation tools a plus (AI tools, Infrastructure as Code (IaC), Azure DevOps, PowerShell, and ARM templates)

Responsibilities

Provide technical guidance and mentorship to the database development team.
Design, develop, and optimize database systems to meet business requirements.
Recommends improvements to the database architecture and design to enhance scalability, availability, and security.
Collaborates with the DevOps team to automate database deployments and integrate with CI/CD pipelines
Create and maintain comprehensive documentation for database systems and processes.
Stay updated with the latest database technologies and best practices, and implement improvements as needed.
Focus on providing database development support which includes; Monitor and optimize database performance, ensuring high availability and reliability.
Work closely with software developers, business analysts, and other stakeholders to integrate database solutions with applications
Perform code reviews to support Database development
Perform database deployments
Optimize database queries and stored procedures for maximum efficiency and performance
Develops complex SQL queries, stored procedures, functions, triggers, and views to support business logic and application functionality
Performs data modeling, including designing schemas, tables, indexes, and relationships, for both transactional and analytical use cases
Provides support for troubleshooting and resolving database-related issues reported by application teams
Works closely with application developers to integrate database systems with applications and ensure efficient data flow
Configures and manages Azure Databases, including automated backups, replication, and high-availability options
Implements and manages database security, including encryption, access controls, and auditing, to meet industry standards and regulatory requirements.
Ensures disaster recovery strategies are in place, including point-in-time restore and geo-replication for Azure SQL Database
Stays current with Azure database services and industry trends, incorporating new features and best practices as appropriate
Provides off-hours support when required
Provides on-site disaster recovery assistance when required
Perform all other duties and special projects as assigned

Benefits

Health Insurance
Vision Insurance
Dental Insurance
Life and Disability Insurance
Flexible Spending and Health Savings Accounts
Employee Assistance Program
401(k) plan with Company Match
Paid Time Off (PTO)
Paid Holidays, Bereavement, and Jury Duty
Paid Pregnancy/Parental leave
Paid Military Leave
Tuition Reimbursement
Paid sick leave benefit that meets the mandated requirements (for part-time and temporary employees in geographic areas with statutory paid sick leave)