Database Specialist
Company: Associated Wholesale Grocers
Location: Kansas City
Posted on: October 2, 2024
Job Description:
Database Specialist
Kansas City, KS, United States
Sr. Solution Engineer (Database Specialist)Location: 5000 Kansas
Avenue Kansas City, KS 66106Department: Information TechnologyThis
is a hybrid position.Position SummaryThe 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 issuesSupport & 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/cleanupTeam 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
- - MapTiler - OpenStreetMap contributors - Oracle
CorporationTermsLegal NoticesUse control and scroll to zoom the
mapUse two fingers to move the map5000 Kansas Avenue, Kansas City,
KS, 66106, USCopy 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
PIc58ebd988637-37248-35466184
Keywords: Associated Wholesale Grocers, Lenexa , Database Specialist, Hospitality & Tourism , Kansas City, Kansas
Didn't find what you're looking for? Search again!
Loading more jobs...