Role Overview

Manage database infrastructure and development across Azure SQL and on-premises environments. Balance traditional DBA responsibilities (performance, security, availability) with SQL development work supporting business requirements and operational needs.

Key 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
• Manage database security using Entra ID, SQL authentication, MFA, and Azure firewall rules
• Support application developers with query optimization and database design consultation
• Archive historical data from transactional systems to maintain optimal performance
• Troubleshoot production database issues and participate in on-call rotation if needed
• Collaborate with Data Engineering team on ETL impacts from schema changes
• Participate in code reviews and maintain version control using Git and Redgate Source Control
• Assist with data engineering projects as capacity allows

Required Skills

• 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
• Ability to work with business stakeholders to understand data requirements
• Experience with database monitoring and alerting tools

Preferred Skills

• Azure SQL VM administration experience
• Redgate toolset (SQL Monitor, SQL Prompt, Source Control)
• Data modeling and dimensional design experience
• Familiarity with ETL/SSIS concepts and how schema changes impact data pipelines
• Experience with CI/CD for database deployments
• VisualCron or similar job scheduling tools
• Python or PowerShell for automation tasks
• Tableau Server administration
• 3PL, logistics, or supply chain industry background