Lorven Technologies, Inc.
SQL Server DBA – Contract – Dallas, TX
Lorven Technologies, Inc., Dallas, Texas, United States, 75215
Role: SQL Server DBA
Location: Dallas, TX
Duration: 12 months Contract
Job Description
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)
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)
#J-18808-Ljbffr
Job Description
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)
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)
#J-18808-Ljbffr