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.
Design, install, configure, manage, and maintain Microsoft SQL 2016 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.
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.
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.
Experience in identifying issues , performance tuning and analysis in Aurora mySQL using performance_schema, explain plans, cloudwatch and performance insights.