Job description
Overview:
Job Responsibilities:
Position Summary:
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, 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.
- 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.
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.
offroadmanagementgroup.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, offroadmanagementgroup.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, offroadmanagementgroup.com is the ideal place to find your next job.