Lereta Llc
Location:
No Location Required, 901 Corporate Center Dr, Pomona, CA 91768, USA
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.
Responsibilities
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:
Index/statistics maintenance
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
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.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr
No Location Required, 901 Corporate Center Dr, Pomona, CA 91768, USA
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.
Responsibilities
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:
Index/statistics maintenance
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
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.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr