Database Specialist

1 week ago

detroit, United States Associated Wholesale Grocers Full time

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

  • Database Specialist

    1 week ago

    Detroit, United States Associated Wholesale Grocers Full time

    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,...

  • Database Specialist

    1 week ago

    detroit, United States Associated Wholesale Grocers Full time

    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,...

  • Database Specialist

    1 week ago

    Detroit, United States Associated Wholesale Grocers Full time

    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,...

  • Database Systems Specialist

    6 days ago

    Detroit, Michigan, United States HexaQuEST Global, Inc. Full time

    Job SummaryWe are seeking a highly skilled Database Administrator Support professional to join our team at HexaQuEST Global, Inc. As a key member of our IT department, you will be responsible for providing expert-level support for our database systems, ensuring their optimal performance, security, and integrity.Key ResponsibilitiesDesign, implement, and...

  • Inventory Control Specialist

    1 week ago

    Detroit, Michigan, United States Flex-N-Gate Full time

    Job SummaryWe are seeking a highly skilled Inventory Control Specialist to join our team at Flex-N-Gate. As an Inventory Control Specialist, you will be responsible for accurately reporting manufactured product and ensuring the achievement of company goals and objectives.Key ResponsibilitiesInventory Management: Work with ERP systems to troubleshoot...

  • Financial Data Specialist

    2 weeks ago

    Detroit, Michigan, United States Brinks Full time

    About the RoleWe are seeking a highly skilled Financial Data Specialist to join our team at Brink's. As a key member of our operations team, you will be responsible for performing extensive data entry of account profile information into our database.Key ResponsibilitiesPerform data entry of account profile information into our database with high accuracy and...

  • Financial Data Specialist

    2 weeks ago

    Detroit, Michigan, United States Brinks Full time

    About the RoleWe are seeking a highly skilled Financial Data Specialist to join our team at Brink's. As a key member of our operations team, you will be responsible for performing extensive data entry of account profile information into our database.Key ResponsibilitiesPerform data entry of account profile information into our database with high accuracy and...

  • IT Support Specialist

    4 weeks ago

    Detroit, Michigan, United States NR Consulting Full time

    Position: IT Support Specialist Company: NR Consulting Type: Contract with potential for extension Duration: Long-term Overview of Role What is the purpose of this position? This role is designed to assist end users in optimizing their productivity and efficiency with computer-related tools and processes. The individual will act as a technical...

  • Financial Data Specialist

    2 weeks ago

    Detroit, Michigan, United States Brinks Full time

    About the RoleWe are seeking a highly skilled Financial Data Specialist to join our team at Brink's. As a key member of our operations team, you will be responsible for performing extensive data entry of account profile information into our database.Key ResponsibilitiesPerform data entry of account profile information into our database with high accuracy and...

  • Inventory Control Specialist

    4 weeks ago

    Detroit, Michigan, United States Flex-N-Gate Full time

    OverviewFlex-N-Gate stands as a prominent manufacturer and supplier of automotive components, recently recognized among the top suppliers in North America. As a dynamic and essential organization, Flex-N-Gate offers excellent opportunities for dedicated and skilled professionals.Position ScopeThe Inventory Control Specialist plays a crucial role in the...

  • Housing Preservation Specialist

    1 week ago

    Detroit, Michigan, United States CHN Housing Partners Full time

    Job Title: Intake Specialist, Single Family PreservationCHN Housing Partners is a nonprofit affordable housing developer, housing service provider, residential mortgage lender, and housing intermediary that works with its partners to solve major housing challenges for low-income people and under-served communities.About the RoleThe Single-Family Preservation...

  • IT Audit Specialist

    2 weeks ago

    Detroit, Michigan, United States Strategic Staffing Solutions Full time

    Job SummaryStrategic Staffing Solutions is seeking a highly skilled IT Audit Specialist to join our team. As an IT Audit Specialist, you will be responsible for planning, developing, and conducting independent information technology audits to ensure the accuracy and reliability of our clients' financial statements.Key ResponsibilitiesPlan and execute...

  • IT Operations Support Specialist

    2 months ago

    Detroit, United States Alixpartners Llc Full time

    At AlixPartners, we solve the most complex and critical challenges by moving quickly from analysis to action when it really matters; creating value that has a lasting impact on companies, their people, and the communities they serve.By understanding, respecting, and honoring the needs of our employees, clients, and communities, AlixPartners actively promotes...

  • Medical Management Specialist

    2 weeks ago

    Detroit, Michigan, United States Strategic Staffing Solutions Full time

    Job Title: Medical Management Intake SpecialistStrategic Staffing Solutions is seeking a highly skilled Medical Management Intake Specialist to join our team.Job Summary:We are looking for a detail-oriented and organized individual to manage medical intake processes, ensuring seamless communication between healthcare providers and insurance companies.Key...

  • Senior Risk Management Security Specialist

    6 days ago

    Detroit, Michigan, United States w3r Consulting Full time

    Senior Risk Management Security Specialist **Job Summary** We are seeking a highly skilled Senior Risk Management Security Specialist to join our team at w3r Consulting. As a key member of our security team, you will be responsible for identifying, assessing, and mitigating risks to our organization's information assets. **Key Responsibilities** *...

  • Administrative Support Specialist I

    4 weeks ago

    Detroit, Michigan, United States Wayne State University Full time

    Administrative Support Specialist I - Physician Assistant Studies Wayne State University is seeking a qualified Administrative Support Specialist I - Physician Assistant Studies to join its dedicated team. Wayne State is a distinguished public research institution committed to providing a high-quality education to a diverse student body. Our values of...

  • Calibration Specialist

    4 weeks ago

    Detroit, Michigan, United States Strategic Staffing Solutions Full time

    STRATEGIC STAFFING SOLUTIONS (S3) IS HIRING Position: Calibration Specialist Location: Detroit, MI (ON-SITE) Engagement Type: W2 Contract Overview We are seeking a dedicated Calibration Specialist responsible for the repair and calibration of measuring and testing instruments. This role is essential in maintaining precise records of calibration...

  • Payroll Specialist

    2 days ago

    Detroit, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are searching for a meticulous Payroll Specialist to join our team in Detroit, Michigan. This role primarily involves managing all payroll activities to ensure the accurate and timely payment of employee wages. The Payroll Specialist will be expected to gather and verify relevant information, calculate wages, and resolve any...

  • Intake Specialist, Single Family Preservation

    3 days ago

    Detroit, Michigan, United States CHN Housing Partners Full time

    Job Title: Intake Specialist, Single Family PreservationCHN Housing Partners is seeking a highly motivated and detail-oriented Intake Specialist to join our Single Family Preservation team. As an Intake Specialist, you will play a critical role in supporting the delivery of our home repair and rehab programs.Job Summary:The Intake Specialist will be...

  • Digital Marketing Specialist

    2 days ago

    Detroit, Michigan, United States OpTech Full time

    About the RoleWe are seeking a highly skilled Digital Marketing Specialist to join our team at OpTech. As a key member of our marketing department, you will be responsible for developing and implementing email marketing campaigns that drive business growth and engagement.Key ResponsibilitiesDevelop and execute email marketing strategies that align with our...