Database Administrator

Food City - Knoxville, TN

Full-time - Mid Level

Hybrid - Knoxville, TN

1,001-5,000 employees

Food and Beverage Retailers

About the position

The production Database Administrator (DBA) will be primarily responsible for the daily care and maintenance of all database systems within the organization. This role focuses on administrative tasks and performance tuning of SQL systems, ensuring optimal functionality and reliability. The production DBA will collaborate closely with Quality Assurance Testing (QAT) teams, support staff, development DBAs, and the Data Architect to maintain and enhance database performance. Oversight for this position will be provided by the Manager of Data and Analytics. This is a full-time, salaried position that operates in a hybrid working environment, requiring time spent both remotely and on-site at one of K-VA-T Food Stores, Inc.'s Corporate Support Centers located in Abingdon, VA or Knoxville, TN. Key responsibilities include providing day-to-day support for Microsoft SQL Server implementations, performing maintenance checks on database servers, managing database backups and restores, and monitoring log and file growth. The DBA will also be tasked with testing programs or databases, correcting errors, and making necessary modifications. Additional duties involve installing and testing new database servers, documenting all tuning and maintenance activities, and maintaining current industry knowledge of relevant concepts and practices. The DBA will specify user access levels, investigate system performance problems, and work with various IT groups to resolve issues. Performance monitoring and tuning of database structures will be conducted per client requirements, and the DBA will make suggestions for altering program code for better efficiency. Furthermore, the role includes mentoring junior staff and interacting with end users to validate business requirements against technical implementation plans.

Responsibilities

• Provide day-to-day support of Microsoft SQL Server implementations.
• Perform maintenance checks on database servers (capacity, backup, job and procedure execution).
• Manage database backups and restores (both recovery and production to test).
• Monitor and manage log and file growth.
• Test programs or databases, correct errors, and make necessary modifications.
• Install and test new database servers and replacements of existing systems.
• Document all tuning and maintenance activity.
• Maintain current industry knowledge of relevant concepts, practices, and procedures.
• Specify users and user access levels for each segment of the database.
• Investigate system performance problems and work with various IT groups to resolve issues.
• Monitor and tune database structures per client requirements.
• Make suggestions for altering program code for better efficiency.
• Read query plans for production code.
• Research, evaluate, and recommend tools to optimize database use and application development.
• Design High Availability solutions for database systems.
• Participate in disaster recovery planning, implementation, and testing.
• Act as a technical resource for SQL-related design, performance, security, and configuration issues.
• Mentor junior staff.
• Interact with end users to validate business requirements against technical implementation plans.

Requirements

• Strong knowledge of the organization, its functions, responsibilities, and procedures.
• Proven leadership skills.
• Demonstrated ability to identify potential issues and develop proactive solutions.
• Interpersonal skills to establish and maintain effective working relationships with team members and subordinates.
• Ability to create a team environment.
• Superior work ethic with a desire to succeed.
• High school graduate, supplemented by a college degree and/or management experience.
• Ability to maintain a high level of confidentiality.
• Ability to follow instructions and delegate work to others.

Nice-to-haves

• Planning and coordination skills.
• Basic knowledge of database performance, tuning, and optimization (PTO).
• Intermediate knowledge of SQL backup and restore methodologies.
• Complex problem-solving skills.
• SQL programming skills.
• Windows System Administration knowledge.
• High Availability and Disaster Recovery options knowledge.
• Indexes, index management, and statistics knowledge.
• Disk configuration and SQL setup parameters knowledge.
• Intermediate SQL programming knowledge.
• Familiarity with Microsoft Azure services including Azure SQL, Data Lake, Data Factory, Logic Apps.
• Implementing operational automation using scripts.

Benefits

• Employee stock ownership plan
• Flexible schedule
• Paid time off