What are the responsibilities and job description for the SQL Server DBA position at MethodHub?
Job Details
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)
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.