Position: Sr. SQL DBA
Location: Fort Lauderdale, FL
Duration: 6 Months Contract to hire
Hybrid Position
Jod Description:
Here is the JD for a role we have with AutoNation. This role is hybrid in Fort Lauderdale, so the candidate must be local or be willing to relocate.
This is a contract to hire role and AutoNation can only hire USC or GC holders for this position.
Overview
• 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.
• Expert level proficiency in SQL Server, AlwaysOnAvailability, 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.
• Experience in identifying issues , performance tuning and analysis in Aurora mySQL using performance_schema, explain plans, cloudwatch and performance insights.
Location: New York, NY
Posted: Aug. 20, 2024, 8:29 a.m.
Apply Now Company Website