SQL Server DBA Dallas, TX

Role: SQL Server DBA

Location:

Dallas, TX
Duration: 12 months Contract

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

• SQL Server Management Studio (SSMS)
• SQL Profiler, Extended Events
• SQL monitoring (Red Gate or Solar Winds)
• 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)

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