Sr. Data Engineer

---

Job description

AutoNation is one of the largest automotive retailers in the United States, offering innovative products, exceptional services, and comprehensive solutions, empowering our customers to make the best decisions for their needs. With a network of dealerships nationwide strengthened by a recognized brand, we offer a wide variety of new and used vehicles, customer financing, parts, and provide expert maintenance and repair services. Through DRV PNK, we have raised over $40 million for cancer-related causes, demonstrating our commitment to making a positive difference in the lives of our Associates, Customers, and the communities we serve.

So what do you say? Are you ready to be part of something big?

This Data Engineer position is a SQL Server Database Administrator Operations Position, with a stronger emphasis on the development, Performance DBA, and familiarity with both Azure and AWS technologies, MySQL Aurora, Postgres, MongoDB and more are expected.

Job Responsibilities:

• Perform risk identification, assessment, remediation, and performance tuning; conduct user training as required; create all necessary documentation/SOPs, training material and user guides; perform mentoring/cross-training for peers; Maintain skills/capabilities through education/training/hands-on experience.

• Highly experienced in Always on setup and maintenance.

• Experience in managing very large databases.

• Design, install, configure, manage, and maintain Microsoft SQL 2014 to the Latest 2022 servers supporting a variety of systems.

• Leads all aspects of the SQL database infrastructure. Install and configure new MS SQL Servers instances and configure failover or high availability.

• Develop stored procedures, triggers, functions, extended events.jobs and maintenance of the data bases including SQL OS installation and patch management.

• Assists multiple teams with SQL integration.

• Increase system performance including hardware, server configuration changes, or index/query changes.

• Document the company's database environment and provide recommendations for improvement; implement if approved.

• Troubleshoot SQL Server outages as they occur, including after-hours and weekends.

• Configure SQL Server monitoring tools and utilities to minimize false alarms.

• Deploy database change scripts provided by third-party vendors. Regularly provide a list of the top 10 most resource-intensive queries on the server weekly and recommend ways to improve performance.

• Create users and assign permissions based on requirements.

• Linked SQL servers and other databases such as MySQL, Access, and others as appropriate.

• Understand a database backup and restore strategies via restore, SAN snapshots and other technologies; document major changes to SQL servers.

• Configure and troubleshoot failover clustering in high availability operations and recover and restore from backups.

• Provide technical support and offer performance improvement suggestions by way of code rewrites, index analysis and query refactoring.

• Document changes to systems and all required checklists for use within the configuration baseline.

• Experience with SSIS and SSRS technologies.

Technical Expertise:

• Serves as a technical expert in the administration of one or more database management systems, providing technical issue resolution and technical coaching to other staff members.

• Expert level proficiency in SQL Server, MySQL, MongoDB, PostGress, AWS/Azure database services.

• Demonstrates advanced expertise in relevant scripting or programming languages such as PowerShell/python.

• Possesses a sound understanding of current and future infrastructure and applications architectures for AutoNation.

• Maintains an industry awareness of new developments in their area of expertise. Learns and applies new and emerging concepts quickly.

• Knowledge of backup software such as Cohisity/Veritas Netbackup.

• Knowledge of Delphix and HVR is desirable.

• Exhibits proficiency in operating system administration and hardware fundamentals

• Proposes and promotes standards and policies in adherence with data governance practices.

• Demonstrates a broad understanding of the applications, data, and technical architectures.

• Designs and participates in disaster mitigation and recovery plans for solutions and databases supported.

• Applies advanced expertise with capacity planning, fault tolerance, high availability, and disaster recovery.

• Designs and implements enterprise level data, application, and database security layers

• Serves as a technical resource across Technology on data management issues.

• Promotes the reuse of existing data objects and entities across the enterprise to reduce costs and meet business requirements.

• Establishes and drives consistent standards for data management and analysis tools and techniques to advise on the applications

development process and to ensure compliance requirements are met.

• Typically provides direction to a team of staff and/or contractors/consultants in their area of expertise.

• Mentors and develops technical staff in their domain

• Exhibits high degree of technical proficiency in design of database applications and knowledge of operating interrelationships between databases and the organization's other systems, serving as a subject matter expert and technical resource to others

• Possesses a broad understanding of systems, applications, and uses of data, as well as knowledge of existing and emerging data modeling approaches and tools.

• Possesses thorough understanding of current and future infrastructure and database architectures.

• Maintains an industry awareness of new developments in their area of expertise. Learns and applies new and emerging concepts.

• Functions independently with limited work direction.

• Defines and breaks down tasks for team members, providing technical expertise as appropriate to deliver results and resolve issues as needed.

Exciting Benefits and Perks Await You:

• Competitive compensation and 401k matching

• Enjoy a healthy work-life balance with insurance plans (health, dental, vision) and maternity benefits

• Exclusive RX Pet program offering discounts on medications

• Associate purchase and discount programs for new and pre-owned vehicles, services, parts, collision, accessories, and AutoGear

• Access amazing deals and discounts through YouDecide, a website with offers from top providers and retailers

• Join our DRVPNK mission to raise and donate millions of dollars to cancer research and treatment, partnering with cancer charities nationwide

AutoNation is committed to creating a diverse, equitable, and inclusive environment in our workplace and the services we provide. We welcome candidates from all backgrounds who are passionate about making a positive impact. Even if you do not meet every requirement, we encourage you to apply. Join our team and help us foster a culture of belonging while contributing to our revolutionary work in the automotive industry. We value innovation, teamwork, and a commitment to making a positive impact in the world.

<!– job description page –>