Database Specialist at Associated Wholesale Grocers
Kansas City, KS
About the Job
Database Specialist
Kansas City, KS, United States
Sr. Solution Engineer (Database Specialist)
Location: 5000 Kansas Avenue Kansas City, KS 66106
Department: Information Technology
This is a hybrid position.
Position Summary
The Sr. Solution Engineer will be able to support and administer a diverse set of enterprise-wide application databases. This includes, but is not limited to, the design, implementation, administration (monitoring and optimizing DB performance, DB capacity planning for various requirements, setting proactive alerts to avoid potential DB issues, upgrade/patching databases, etc.), and maintenance of all company databases on Prem and in the Cloud. The position requires the support of business initiatives through researching, reviewing database designs, evaluating new database software, and presenting findings to project teams, IT leadership, and business leadership. An ideal candidate will have experience performing root cause analysis of database problems, identifying solutions and resolutions, as well as scripting experience for automation.
Position Responsibilities:
Deliver solutions (30%)
- Implements and monitors Database systems health and identify issues proactively
- Collaboration with Data Architects to design databases and implement physical database design.
- Responsible for identifying, standardizing, and implementing database security measures, including potential security breaches, authorized individual access through enterprise-grade access policy, and documenting security access methods
- Ensures RDMS software and server runtimes are fully optimized.
- Performs database software installations, patching, upgrades, and routine maintenance.
- Identifies and implements Database capacity planning for the requirements in terms of DB/Systems resource requirements
- Documenting security access methods
- Create documentation for new procedures
- Update procedures, change controls, on-call log, and problem or incident status and resolution
- Set up automated proactive alerts for database performance to avoid potential issues
Support & Availability Service (25%)
- Provides 24x7 operational support for production database environments through an on-call system.
- Responsible for source control of database DDLs, DMLs, etc.
- Performs database performance monitoring, optimization, and tuning.
- Responsible for Database stability and system availability by SLAs
- Schedule and Maintain database backups and recovery solutions/practices
- Follow the change management process
- Understand, support, and monitor enterprise-level database jobs for data extraction, transformation, and load.
- Monitor and report any unauthorized Database access/setup/cleanup
Team Development – Learning & Continuous Improvement (20%)
- Collaborates with peers, peer teams, and management when complex system issues arise.
- Makes technical decisions following established policies and procedures to ensure database availability.
- Continual learning in Cloud solutions and future trends.
Strategy – Align Roadmap & Strategy (25%)
- Responsible for identifying, standardizing, and implementing database security measures, including potential security breaches, authorized individual access through enterprise-grade access policy
- Continually evaluate, recommend, and evolve the strategy for database management.
Minimum Position Requirements:
- Bachelor's Degree or equivalent work experience.
- 7+ years administering enterprise database systems in DB2, SQL Server, On-prem and Cloud.
- Experience with databases in the cloud.
- Experience with Azure and Data Factory preferred, including cost management and monitoring
- Experience with Databricks is a plus
- Bicep scripting experience a plus
- Must be a self-learner and come up to speed quickly
- Deeper implementation experience in database security standards, guidelines, and best practices
- Knowledge of IT Security best practices
- Problem-solving and critical thinking
- AIX command line experience
- Ability to explain complex ideas in simple terms
- Analyze, solve, and correct database-related issues in real-time
- Diagnose and troubleshoot database errors/alerts promptly
- Create automation of repeated database tasks
- Experience with upgrades, backup/recovery, patching, and support of production and lower-level databases.
- Ability to optimize and improve database performance.
- UNIX Shell scripting experience (Korn and Bourne Shell).
- ODBC connected query tools experience (SQL*Plus, TOAD, SQL Developer, AQT).
- SQL development skills to assist programmers with query performance tuning.
- Experience creating tables, views, stored procedures, SQL, dynamic SQL, indexes, and data constraints.
- Experience with data models, database design, and development.
- Ability to interpret data and analyze results.
- SAN-attached devices and (NFS) mounted file systems experience.
- Three years of Experience with Data Warehousing and optimization, including modern technologies/methodologies
- ITIL is a plus.
Associated Wholesale Grocers, Inc. (AWG) is the nation’s largest cooperative food wholesaler to independently owned supermarkets, serving 1,100 member companies and more than 3,900 locations throughout 33 states from 9 wholesale divisions. Consolidated sales for AWG in 2023 were $12.4 billion. In addition to its cooperative wholesale operations, the company also operates subsidiary companies that provide certain real estate and supermarket development services, and pharmaceutical products. For more information, visit AWGinc.com.
Benefits:
- Medical, Dental, & Vision Insurance
- Health Savings Account
- Dependent Care Flexible Spending Account
- Paid Vacation, Holiday, and Sick Time
- 401(k) with 4% match along with 3 other contributions
- Tuition Reimbursement
- Basic & Supplemental Life and AD&D
- Employee Assistance Program
- Short-Term and Long-Term Disability
- Wellness Program
- Yearly Holiday Bonus
- Use control and scroll to zoom the mapUse two fingers to move the map
5000 Kansas Avenue, Kansas City, KS, 66106, US
Copy to Clipboard
Job Identification 1138
Job Category Non Union
Posting Date 09/03/2024, 12:26 PM
Job Schedule Full time
Locations 5000 Kansas Avenue, Kansas City, KS, 66106, US
PI9e261a4b011e-37395-35466184