What are the responsibilities and job description for the Senior SQL Database Administrator position at Altimetrik?
Senior SQL Server DBA – Retail Systems
Role Summary
Altimetrik is seeking a Senior SQL Server Database Administrator to own and support a Microsoft SQL Server environment backing a large-scale Retail Inventory System (Yellow Dog). This is a hands-on DBA role focused on administration, performance tuning, data quality, and scalability. Application development is not required.
The role requires strong business communication skills, with the ability to work cross-functionally across Retail Operations, Finance, and IT to ensure reliable, accurate, and performant data systems.
Key Responsibilities
- Administer and support SQL Server (2016–2022) environments
- Perform query tuning, indexing, and performance optimization
- Troubleshoot and resolve database performance and stability issues
- Execute database maintenance (DBCC, index rebuilds, cleanup)
- Manage backups, restores, and HA/DR readiness
- Support SQL Agent jobs and ETL schedules
- Validate and troubleshoot integrations between POS, retail systems, and ERP
- Identify and resolve data quality issues impacting inventory and financial reporting
- Document database architecture and data flows
- Partner with business and technical stakeholders to translate issues into business impact
Required Qualifications
- Strong SQL Server DBA experience (2016–2022)
- Advanced query tuning and indexing expertise
- Experience supporting large, high-volume transactional databases
- Backup/restore and HA/DR experience
- SQL Server security and RBAC knowledge
- Experience supporting distributed systems and data integrations
- Ability to communicate effectively with non-technical stakeholders
Tools & Technologies
- SQL Server Management Studio (SSMS)
- SQL Profiler and Extended Events
- SQL monitoring tools (e.g., RedGate, SolarWinds)
- ETL tools (SSIS or similar)
- Windows Server fundamentals