About the role
- Manage database infrastructure and development across Azure SQL and on-premises environments
- Balance traditional DBA responsibilities with SQL development work supporting business requirements and operational needs
- 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
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
- Ability to work with business stakeholders to understand data requirements
- Experience with database monitoring and alerting tools
- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQL Server administrationT-SQL developmentdatabase performance tuningindexingquery optimizationbackup/recovery strategiesdisaster recovery planningdatabase security principlesstored proceduresdata migrations
Soft skills
collaborationcommunicationproblem-solvingstakeholder engagement