Position: SQL Server DBA – Retail Systems
Location: Dallas, TX – Hybrid
Job-Type: Contract
Job description:
Client is looking for a senior SQL DBA – Not necessarily required to do development work but needs a very solid experienced DBA who can focus on doing heavy admin, tuning, and cleanup work on the SQL DB that sits behind their Retail System (Yellow Dog).
They will have to have excellent communication skills and business acumen – and will be expected to consult and collaborate effectively and intelligently communicate and interpret requirements across multiple stakeholders (including individual contributors and executive leaders) across various BUs (Retail & Hotel Ops, Finance etc.) and ensure the DB is conditioned to support multiple business and reporting needs. They need help providing day to day support to the SQLDB and will also be expected to identify where there are data gaps, make recommendations for improvements. and improve documentation of their architecture and data flow and advise Gustaaf and various stakeholders on how to better stabilize and scale the system.
* Hotel retail outlets (gift shops, spas, golf shops, food retail, boutiques).
* Distributed retail systems across 50+ properties.
* Multi-property POS ecosystem integrating with:
PMS) Property Management Systems like (for example: Opera, StayNTouch, Light-speed)
Retail POS systems (Yellow Dog – hospitality / retail tool which integrates with property and POS systems and is used to manages inventory across many outlets and runs on Microsoft SQL Server back-end-and needs ongoing maintenance because it stores large volumes of transacted, item-level, multi-location retail data)
Fundamental Requirements:
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:
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
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)
|
|
Sugandh Raj Trivedi Tanisha Systems Inc Email: Sugandh@tanishasystems.com | Address:99 Wood Ave South Suite # 308,Iselin, NJ 08830 |
