What are the responsibilities and job description for the SQL Server DBA position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, MethodHub, is seeking the following. Apply via Dice today!
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:
SQL Server DBA
Location: Dallas, TX
Duration: Long Term Contract
solid business acumen, this is NOT just a backend DBA. -> Very important
- 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 (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)
- 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 )
- 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
- 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)
SQL DBA - Remote TX
Connection -
Dallas, TX
SQL DBA / Systems Analyst
CGS Federal (Contact Government Services) -
Dallas, TX
Oracle DBA Admin with SQL_REMOTE_ON W2
Jobs via Dice -
Richardson, TX