SQL Server DBA

SQL Server DBA

Location: Dallas, TX

Duration: Long Term Contract

solid business acumen, this is NOT just a backend DBA. -> Very important

• 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:

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)

They need someone who can:

• 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
• 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)