JOB SUMMARY:

The production DBA will be the individual most closely aligned to the daily care and maintenance of all database systems in the organization.  The focus of this position is on Administrative tasks and performance tuning of SQL systems.

The production DBA works closely with others in QAT and support as well as the development DBAs and Data Architect. Oversight of this position is by the Manager of Data and Analytics.

The Database Administrator role is a full-time and salary opportunity. This position will perform in a hybrid working environment with time spent both remote, as well as on-site at one of K-VA-T Food Stores, Inc.’s Corporate Support Centers located in Abingdon, VA or Knoxville, TN.

ESSENTIAL JOB FUNCTIONS :

• 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.
• Installing and testing new database servers and replacements of existing systems.
• Document all tuning and maintenance activity.
• Basic understanding of SQL PTO
• Maintain current industry knowledge of relevant concepts, practices and procedures.
• Specify users and user access levels for each segment of database.
• Investigating system performance problems and working with various groups in IT to resolve issues including networking, server and SAN administration, and applications development
• Performance monitoring and surveillance and tuning of database structures per client requirements.
• Make suggestions for altering program code for better efficiency
• Read Query plans for production code
• Basic understanding of SQL programming constructs and ability to write SQL code for entry level projects
• Researching, evaluating, and recommending tools that may be used to optimize database use and application development
• Advanced understanding of SQL PTO
• Design High Availability solutions for database systems
• VMware monitoring and Server Monitoring for I/O bottlenecks
• Participating in disaster recovery planning, implementation and testing
• Being a technical resource for SQL related design, performance, security and configuration issues
• Mentor junior staff
• Interact with end user to validate business requirements against technical implementation plan

JOB QUALIFICATIONS:

Required:

• Strong knowledge of the organization, its functions, responsibilities and procedures.
• Proven leadership skills.
• Demonstrated ability to identify potential issues and develop proactive solutions.
• Must have interpersonal skills, including the ability to establish and maintain effective working relationships with team members and subordinates.
• Must be able to create a team environment.
• Must possess a 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, as well as delegate work to others.

Preferred:

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

About Food City: Food City is a privately held, family-owned company with a driving mission to "run the best store in town." Dedicated to giving back to the communities we serve, we encourage our associates to get involved with their local civic organizations. We consider our associates to be our greatest asset. Over 13% of the company is currently owned by our associates through our employee stock ownership plan, promoting tremendous pride in the services and products we provide. Whether your passion is baking, accounting, or trucking, Food City has a promising career opportunity for you. We offer flexible schedules to ensure our associates have ample time to spend with family and friends. If you're looking for a great career or the opportunity to try something different, consider becoming part of the Food City family.