Please find the JD : 

 Core SQL Server / DBA Skills:

• SQL Server 2016–2022 administration
• Query tuning, indexing, and performance optimization
• Database maintenance (DBCC checks, index rebuilds, shrink/cleanup strategies)
• Backup/restore + HA/DR
• SQL Security & Role-Based Access Control
• Understanding of SQL Agent jobs and ETL schedules
• Familiarity with integrations:
  • API feeds
  • Scheduled batch imports
  • File-based ingest
  • Sync issues between systems
• Experience with large transactional databases (retail /hospitality requires heavy item-level transactions
• Ability to understand and correlate Hospitality + Retail + Multi-Property Ops Context: 
  • Retail outlets operate 7 days a week → uptime critical
  • Hotel PMS + POS integration complexity
  • Distributed systems across 50+ hotels (WAN latency, local servers, replication)
  • Seasonality spikes (holidays, events) impacting performance
  • Inventory shrink + financial reconciliation processes

 Desired Skills/ Experience:  

• Retail System-Specific Technical Skills are desired (i.e.. - Understanding of things like):
  • Inventory adjustments
  • Retail/Field-level vs centralized inventory
  • Purchase orders
  • Receiving processes
  • Price books
  • SKU structures
  • Ability to interpret POS (Point-of-Sale) data structures
• Experience with inventory systems or retail ERP
  • Yellow Dog is a plus (not required if strong SQL + inventory background)

Tools/Technologies:

• SQL Server Management Studio (SSMS)
• SQL Profiler, Extended Events
• SQL monitoring (RedGate or SolarWinds)
• Power BI or Tableau (for data quality dashboards)
• Windows Server & Active Directory basics
• ETL tools (SSIS likely)
• Git or version control (light usage for scripts)
• Yellow Dog APIs / integration layer (desired but not required)

 Business / Soft Skills Needed:

 Because the CIO emphasized “solid business acumen,” this is NOT just a backend DBA.

 They need someone who can:

• Talk to Retail / Restaurant/ Hotel operations managers
• Explain data errors to non-technical teams
  • Understand why bad inventory data = lost revenue
• Document and recommend operational improvements
• Work cross-functionally with:
  • Finance
  • Retail GM/Directors
  • Store managers
  • Omni corporate IT
• Translate root causes into business impact
  • Example: “SKU duplication is causing margin calculation errors “)

Daily Activities

• Monitor SQL Server database health:
  • Review slow queries, blocking, deadlocks
  • Manage backups, restores, and failover preparedness:
  • Validate data feeds from POS →
  • Yellow Dog → downstream systems
  • Fix data hygiene issues:
    • orphaned records
    • mismatched SKUs
    • duplicate items
    • incorrect unit conversion
    • Analyze data anomalies impacting retail operations
• Work with retail operations and finance to understand data gaps
• Document DB architecture and data flow
• Provide guidance on how to stabilize and scale the system

Project Work:

• Index tuning & rebuilding
• Migrating SQL instances or consolidating servers
• Hardening SQL Server security
• Improving disaster recovery and backup strategy
• Building monitoring dashboards
• Working with Yellow Dog vendor support
• Supporting new store openings or rollouts
• Helping prepare for PCI or SOX compliance (retail touches payments → high compliance needs)