Database Administrator at Seven Up Bottling Company

Created by the Howdy Corporation in St. Louis, MO, 7UP was an optimistic venture from the very start. After great success with the Howdy Orange drink, company founder C.L. Grigg decided to try his luck with lemons and limes. C.L. Grigg spent more than two years testing over 11 different formulas, all in search of a drink that was refreshing enough to prove irresistible to the people of Missouri and the world at large. In 1929, C.L. Grigg’s bubbliest drink was born. The public quickly developed a taste for Grigg’s caramel colored lemon-lime soda. Bib-Label Lithiated Lemon-Lime Soda sold, and sold well. As the drink grew more and more popular, the original name was traded in for something short and sweet. Bib-Label Lithiated Lemon-Lime Soda became known as 7UP. Early advertising featured a winged 7UP logo with copy that read "a glorified drink in bottles only. Seven natural flavors blended into a savory, flavory drink with a real wallop." The drink was so successful by 1936 that Grigg changed the name of The Howdy Corporation to The Seven-Up Company. By the late 1940s, 7UP had become the third best-selling soft drink in the world. In the decades to follow, 7UP developed iconic branding, setting it apart from industry front-runners. In 1967, 7UP brought the phrase UNCOLA into the national vernacular. The UNCOLA campaign set 7UP apart from its competition and became part of a counter cultural that symbolized being true to yourself and challenging the status quo. Always at the frontier of taste and pop culture, 7UP was also among the first sodas to introduce sugar-free and caffeine free options. Through the years, advertising for 7UP featured everything from a cartoon mascot named Spot, to the "It’s an Up thing" and "Make 7UP yours" taglines.

Description
Database Administrator:

• The Database Administrator’s role is to design, install, monitor, maintain, and performance-tune production databases while ensuring high levels of data availability.
• This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Responsibilities
Strategy & Planning:

• Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Acquisition & Deployment:

• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

Operational Management:

• Create models and relational entity diagrams for new database development and/or changes to existing ones.
• Install and configure relevant network components to ensure database access as well as database consistency and integrity.
• Respond to and resolve database access and performance issues.
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Monitor, optimize, and allocate physical data storage for database systems.
• Plan and coordinate data migrations between systems.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Create, or support the creation of, required reports in response to business user needs.
• Perform database transaction and security audits.
• Establish appropriate end-user database access control levels.
• Develop routines for end users to facilitate best practices in database use.
• Manage and/or guide junior members of the team.
• Understand the needs and requirements of the applications using the databases and provide support for these applications.
• Coordinate multiple applications accessing the same database.
• Write and debug lines of SQL code for application development.

Position Requirements
Formal Education & Certification:

• A minimum of a Higher National Diploma (HND) or University Degree in the field of Computer Science or Engineering with a minimum of 6 years of relevant work experience as a DBA.
• Certifications in Database Management and/or Administration from Microsoft or Oracle are required.

Knowledge & Experience:

• Strong understanding of database structures, theories, principles, and practices.
• Working technical experience with designing, building, installing, configuring, and supporting database servers, including Microsoft SQL Servers 2008 to 2022, MySQL, Postgres, and SAP HANA Database.
• Hands-on database tuning and troubleshooting experience.
• Experience with data processing flowcharting techniques.
• Project management experience.
• SQL Scripting experience.
• Programming skills are nice to have.
• Good understanding of the organization’s goals and objectives.
• Knowledge of applicable data privacy practices and laws.

Personal Attributes:

• Leadership ability.
• Business Savvy.
• Political Sensitivity.
• Strong technical documentation skills.
• Good interpersonal skills.
• Ability to conduct research into database issues, standards, and products as required.
• Ability to present ideas in user-friendly language.
• Highly self-motivated and directed.
• Keen attention to detail.
• Proven analytical and problem-solving abilities.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment.

Method of Application