Manage database infrastructure and development across Azure SQL and on-premises environments for the company
Requirements
- 3+ years of SQL Server administration and T-SQL development experience
- Strong understanding of database performance tuning, indexing, and query optimization
- Experience with Azure SQL Database administration
- Proficiency with backup/recovery strategies and disaster recovery planning
- Knowledge of database security principles and implementation
- Solid T-SQL programming skills including stored procedures, triggers, and dynamic SQL
- Azure SQL VM administration experience
Responsibilities
- Administer and maintain Azure SQL databases and SQL Server instances (Azure VM)
- Monitor database health, performance, and security using SQL Monitor and native Azure tools
- Manage database maintenance jobs including index fragmentation, statistics updates, and backup management
- Design and implement indexing strategies with compression and appropriate fill factors
- Write and optimize T-SQL stored procedures, functions, views, and dynamic SQL
- Perform data migrations, mass updates, and data cleanup projects
- Enforce database standards: naming conventions, surrogate primary keys, audit triggers, schema design
Other
- Ability to work with business stakeholders to understand data requirements
- 3+ years of experience
- Collaborate with Data Engineering team on ETL impacts from schema changes
- Participate in on-call rotation if needed
- 3PL, logistics, or supply chain industry background
