What are the responsibilities and job description for the Database Administrator II position at Love's Travel Stops?
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 :
Education :
HS diploma or equivalent required
Bachelor’s degree in Business Administration with MIS or technology related degree, such as C.S., required
Experience :
Minimum of 3 years of database administration and operational support in large scale SQL Server or equivalent database environment preferred
SKILLS AND PHYSICAL DEMANDS :
Skills :
Strong understanding of the SDLC.
Strong SQL Server database operations background with Windows Server experience (DMVs, Profiler, Perfmon, DBCC etc.)
Strong proficiency in query optimization including Logical query processing, Resource (Disk / IO / Processor) utilization analysis, Retrieval and dissection of query execution plans
Prior experience with high availability (Clustering Vs. Mirroring Vs. Log Shipping Vs. Replications Vs AlwaysON) and disaster recovery (backup and recovery strategies)
Prior experience with SQL security and SQL auditing
Database Performance Tuning
MySQL, PostgreSQL, or NoSQL Databases
Data modeling experience is a plus
Certifications related to Microsoft SQL Server is a plus
Typical physical demands :
Requires prolonged sitting, some bending and stooping
Occasional lifting up to 25 pounds
Manual dexterity sufficient to operate a computer keyboard and calculator
Requires normal range of hearing and vision
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 :
Gemini Motor Transport, one of the industry’s safest trucking fleets
Speedco, the light mechanical and trucking service specialists
Musket, a rapidly growing, Houston-based commodities supplier and trader
Trillium, a Houston-based alternative fuels expert
EOE-Protected Veterans / Disability
