Job description

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.

Requirements