SQL Server Database Administrator

Job Details

Description

LERETA is seeking an experienced Azure SQL Server Database Engineer/Administrator to join our technology team. This role requires strong expertise in SQL Server administration and development within Microsoft Azure environments, combined with modern automation and DevOps practices. Our technology teams play a critical role in delivering secure, reliable, and highly available data platforms that support mission-critical services for our clients. LERETA is seeking an experienced Azure SQL Server Database Engineer/Administrator to join our technology team.

Azure SQL Administration & Engineering

• Design, deploy, and manage SQL Server environments across Azure SQL Database, Azure SQL Managed Instance, Elastic Pools, and SQL Server on Azure VMs
• Support and configure Elastic Jobs, Azure SQL orchestration, and distributed job execution
• Manage Azure SQL server-level configuration: firewall rules, private endpoints, VNet integration, auditing, threat detection, and RBAC
• Implement and administer Azure Failover Groups, geo-replication, and DR/HA strategies
• Configure and support database encryption, compliance, auditing, and operational governance controls
  
  

DevOps, CI/CD & Automation

• Automate SQL deployments using Azure DevOps Pipelines, YAML CI/CD, Git-based workflows, and database release automation
• Develop code-based automation solutions leveraging:
• PowerShell (Az modules, dba tools, custom scripts)
• Azure CLI
• Azure Functions
• Logic Apps / Power Automate (Flows)
• Azure Automation Accounts & Runbooks
• Automate activities such as:

• Schema deployment & change management
• Index/statistics maintenance
• DR test validation & reporting
• Database provisioning
• Configuration enforcement
• Alert-driven recommendation
  

Performance & Monitoring

• Monitor and tune databases using Azure SQL Insights, Query Store, Automatic Tuning, and Intelligent Query Processing
• Build and query Log Analytics workspaces using Kusto Query Language (KQL) for custom dashboards, advanced diagnostics, and alerting
• Identify and resolve:

• Blocking and concurrency issues
• Parameter sniffing
• Long-running queries
• Plan regressions
• CPU, memory, and I/O bottlenecks
• Apply best practices for indexing, partitioning, data distribution, and query optimization
• Review execution plans to ensure efficient query performance across Azure SQL platforms
  

T-SQL Development

• Develop, maintain, and optimize complex T-SQL stored procedures, functions, views, triggers, and queries
• Partner with development and product teams on schema design, indexing strategy, and data modeling
• Write efficient, reusable SQL code that supports high-volume transactional and reporting workloads
  
  

Operational Responsibilities

• Perform installation, configuration, patching, and upgrades across Azure SQL platforms
• Manage backup and restore processes including:
• Automated PITR
• Long-Term Retention policies
• Geo-restore scenarios
• Managed Instance backup automation
• Implement security protections including auditing, TDE, Always Encrypted, firewall restrictions, and identity access controls
• Collaborate with DevOps, cloud engineering, and application stakeholders to support operational continuity and scalability
  

This position will perform other duties as assigned based on the needs of the department.

Salary range: $95,444 - $120,000

Position requires availability to support East Coast Operations hours.