It Database Administrator - Analyst Ii

IT Database Administrator 

Location: 5000 Kansas Avenue Kansas City, KS 66106

Department: Information Technology

Position Summary

The Database Administrator will be able to support and administer a diverse set of enterprise-wide application databases and data warehouse environments. 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 sandbox, non-production, and production databases. 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 making recommendations for resolution.

This is a hybrid position.

Position Responsibilities:

Database Administration (50%)

• Implements and monitors Database systems health and identifies issues proactively.
• Performs database performance monitoring, optimization, and tuning.
• 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. 
• Responsible for Database stability and system availability by SLAs
• Schedule and Maintain database backups and recovery solutions/practices.
• Follow the change management process.
• Provides 24x7 operational support for production database environments through an on-call system.
• Responsible for source control of database DDLs, DMLs, etc. 

Documentation (10%)

• Documenting security access methods
• Create documentation for new procedures.
• Update procedures, change controls, on-call log, and problem or incident status and resolution.

Communication/Team Dynamics (15%)

• Collaborates with peers, peer teams, and management when complex system issues arise.
• Makes technical decisions following established policies and procedures to ensure database availability.

Testing, Evaluation, and Training (20%)

• Understand, support, and monitor enterprise-level database jobs for data extraction, transformation, and load.
• Monitor and report any unauthorized Database access/setup/cleanup.
• Responsible for identifying, standardizing, and implementing database security measures, including potential security breaches, authorized individual access through enterprise-grade access policy.

Strategy and vision (5%)

• Set up automated proactive alerts for database performance to avoid potential issues.

Minimum Position Requirements:

• Bachelor's Degree or equivalent work experience.
• 7+ years administering enterprise database systems in MSSQL.
• Experience with MSSQL migrations to cloud and database management in the cloud. Azure preferable
• 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/or 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 over 1,100 member companies and over 3,400 locations throughout 31 states from 9 wholesale Divisions. The consolidated run-rate sales for AWG are $12.3billion. In addition to its cooperative wholesale operations, the company also operates subsidiary companies that provide certain real estate and supermarket development services, print and digital marketing services, health and beauty care, general merchandise, pharmaceutical products, specialty foods, and natural and organic products. 

 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