LERETA, LLC · 1 day ago
SQL Server Database Administrator
CA
Full-time
Onsite
Mid, Senior Level
$95K/yr - $120K/yrLERETA, LLC is seeking an experienced Azure SQL Server Database Engineer/Administrator to join their technology team. This role requires strong expertise in SQL Server administration and development within Microsoft Azure environments, focusing on delivering secure and reliable data platforms for clients.
Financial Services
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
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
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
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 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
Qualification
Required
Strong expertise in SQL Server administration and development within Microsoft Azure environments
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 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
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
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 DevOps, cloud engineering, and application stakeholders to support operational continuity and scalability
Availability to support East Coast Operations hours
Company
LERETA, LLC
Since 1986, LERETA has provided a full suite of national real estate tax services for residential and commercial loans, including automated online research and certification, tax bill processing, a suite of delinquent tax services, and customized tax outsourcing service programs.
Founded in 1986
501-1000 employees
H1B Sponsorship
LERETA, LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2023 (1)
2022 (1)
Funding
Current Stage
Late StageTotal Funding
unknown2021-07-06Private Equity
2021-07-06Acquired
2009-01-01Private Equity
Leadership Team
Jim Micali
Chief Operating Officer
Michael S. Black
Chief Information Security Officer
Recent News
2025-01-23
2025-01-22
HousingWire
2024-05-17
Company data provided by crunchbase