SQL Server Database Administrator

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 Dev Ops 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.

• 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

• Automate SQL deployments using Azure Dev Ops Pipelines, YAML CI/CD, Git‑based workflows, and database release automation
• Develop code‑based automation solutions leveraging:
  • Power Shell (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

• Monitor and tune databases using Azure SQL Insights, Query Store, Automatic Tuning, and Intelligent Query Processing
• Build and query Log Analytics work spaces 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

• 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

• 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 Dev Ops, 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.