Data Management, Professional 4

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 2025 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