Datasage Technologies

Overview

We are seeking a highly skilled and energetic Senior SQL Database Administrator to join our dynamic team. In this pivotal role, you will lead the design, implementation, and management of our enterprise databases, ensuring optimal performance, security, and high availability. Your expertise will drive the success of our data infrastructure, enabling seamless access to critical information and supporting strategic decision-making across the organization. If you thrive in a fast-paced environment and are passionate about database excellence, this is your opportunity to make a significant impact.

Fundamental Requirements:

• 5+ years of experience
• 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:

Because the CIO emphasized “solid business acumen,” this is NOT just a backend DBA.

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

Pay: Up to $55.00 per hour

Expected hours: 40.0 per week

Work Location: In person