What are the responsibilities and job description for the Database Administrator II position at Loves Travel Stops & Country Store?
Req ID : 452364
BASIC PURPOSE : This individual will be part of the database administration team. DBA team is responsible for performance tuning, backups, integration, ETL, database configuration, database installation, database monitoring, troubleshooting database issues / timeouts, database modeling, SSIS packages, willingness to grow and learn new database technologies utilizing legacy onprem technologies and cloud technologies.
MAJOR RESPONSIBILITIES :
- Works with other team members collaboratively in understanding and resolving database issues including database performance problems
- Installation of SQL Server, including Active-Active / Active-Passive clustering, Always-ON configuration, Pre / post Configuration (OLAP vs. OLTP vs. Data Warehouse vs. Reporting), Physical files & filegroups configurations
- Working knowledge of MySQL, PostgreSQL, or NoSQL Databases is a plus
- Complete project tasks as assigned on time
- Follow established processes for change control / SDLC
- Participate in on-call rotation as needed to support operations of critical databases.
- Ability to understand and troubleshoot complex business logic in stored procedures, identify problems and implement solutions
- Works with other senior DBA members of the team and the server group to provide operational support and triage
- Ability to work in high-pressure break / fix situations
- Proactively monitors the databases (performance, backups, security, database file sizes etc.)
- Identify poorly performing queries, stored procedures, views etc., as well as take steps to improve performance this includes index design and maintenance
- Aptitude to learn new technologies and desire to sustain modernization in an ever-changing technology space
- Conduct peer code reviews
EDUCATION AND EXPERIENCE :
HS diploma or equivalent required
Minimum of 3 years of database administration and operational support in large scale SQL Server or equivalent database environment preferred
SKILLS AND PHYSICAL DEMANDS :
Strong understanding of the SDLC.
Requires prolonged sitting, some bending and stooping
Job Function(s) : Information Technology
Love’s Travel Stops & Country Stores is the industry-leading travel stop network in the United States. For more than 55 years, we’ve provided customers with highway hospitality and “Clean Places, Friendly Faces.” We’re passionate about serving drivers with clean, modern facilities stocked with fuel, food and supplies. We offer meals from popular restaurant chains, trucking supplies, showers and everything needed to get back on the road quickly. The Love’s Family of Companies includes :
