System: Microsoft SQL
Location: Remote
Employment Type: Full-Time
Experience Level: 2–5+ Years
Position Overview
We are looking for a Senior Microsoft SQL Server DBA / WMS Systems Administrator to support our Manhattan SCALE Enterprise Warehouse Management System (WMS). This role is responsible for maintaining high-performance SQL Server databases, ensuring system availability, reliability, and scalability for our warehouse operations.
The ideal candidate has strong experience with SQL Server administration, database optimization, high availability architecture, backup/recovery, and reporting services, and enjoys working in high-transaction logistics environments.
This role is critical to keeping warehouse operations running efficiently with minimal downtime.
Key Responsibilities SQL Server Administration
- Administer and maintain Microsoft SQL Server environments supporting Manhattan SCALE WMS.
- Monitor system health and ensure database uptime and stability.
- Manage database configuration, upgrades, patching, and performance monitoring.
Performance Optimization
- Analyze and optimize slow queries, stored procedures, and indexing strategies.
- Monitor execution plans and implement improvements to increase database efficiency and throughput.
- Perform index maintenance, statistics updates, and database tuning.
High Availability & Disaster Recovery
- Design and maintain high availability and disaster recovery solutions including:
- Replication
- Failover configurations
- Always On Availability Groups (preferred)
- Develop and maintain disaster recovery plans and procedures.
- Conduct regular backup verification and recovery testing.
Backup & Restore Management
- Configure and monitor automated backup strategies including:
- Full backups
- Differential backups
- Transaction log backups
- Perform database restores and recovery operations when required.
Reporting & Business Intelligence
- Develop and maintain SQL Server Reporting Services (SSRS) reports.
- Support BI reporting and operational dashboards used by warehouse and leadership teams.
- Optimize reporting queries for large operational datasets.
Job Scheduling & Automation
- Manage SQL Server Agent jobs and scheduling processes.
- Automate routine tasks using T-SQL scripting and maintenance plans.
System Monitoring & Troubleshooting
- Proactively monitor database performance, disk usage, and system metrics.
- Troubleshoot issues affecting Manhattan SCALE WMS performance.
- Work closely with IT, application teams, and warehouse operations to resolve issues quickly.
Required Qualifications
- 2+ years of experience as a Microsoft SQL Server DBA
- Strong experience with SQL Server database administration
- Hands-on experience with:
- Database backup and recovery
- Performance tuning
- SQL Server Agent jobs
- T-SQL scripting
- SSRS reporting
- Experience supporting enterprise applications or operational systems
Preferred Qualifications
- Experience supporting Manhattan SCALE WMS
- Experience with SQL Server High Availability solutions
- Experience with Always On Availability Groups
- Experience with ETL processes or data integration
- Experience in logistics, warehouse, or supply chain environments
Technical Skills
- Microsoft SQL Server
- T-SQL
- Database Performance Tuning
- SQL Replication / HA Architecture
- SSRS Reporting
- Backup & Disaster Recovery
- SQL Server Agent & Job Scheduling
- Database Monitoring Tools
Why This Role Is Important
This position plays a critical role in ensuring warehouse operations run smoothly without system interruptions. The DBA will support a high-volume transactional environment where database performance directly impacts shipping, receiving, and inventory accuracy.
Job Types: Full-time, Permanent
Pay: $18,000.00 - $30,000.00 per month
Work Location: Remote
