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.