Data Operations Engineer

At
Wilson Elser , we are redefining what it means to work at a national law firm. With more than 1,400 attorneys across 46 offices nationwide, we are recognized among the top 100 law firms by The American Lawyer and ranked #30 in the National Law Journal’s survey of the nation’s largest law firms.

Our continued success is built on a culture of collaboration, innovation, client service, and mutual respect. We are committed to fostering an environment where employees are empowered to grow their careers, contribute meaningfully, and thrive professionally.

Data Operations Engineer to manage, optimize, and support enterprise data platforms across on-premises and cloud environments. The ideal candidate will have strong expertise in Microsoft SQL Server (On-Premises), Azure SQL, and Azure Databricks, with a focus on ensuring data platform availability, performance, security, and operational excellence.

This role is responsible for maintaining critical database infrastructure, supporting data engineering workloads, automating operational processes, monitoring platform health, and collaborating with data engineers, developers, and infrastructure teams to deliver reliable, secure and scalable data services.

• Administer and maintain Microsoft SQL Server on-premises environments.
• Manage Azure SQL Database and Azure SQL Managed Instance environments.
• Monitor database health, performance, storage utilization, and capacity planning.
• Perform database installation, configuration, patching, upgrades, and migrations.
• Configure and manage high availability and disaster recovery solutions, including SQL Server Always On Availability Groups, failover clustering, backup, and recovery.
• Develop and maintain backup, restore, and disaster recovery procedures.
• Manage and monitor Azure SQL resources and Azure Databricks work spaces
• Monitor SQL cloud resource utilization and Databricks job scheduling.
• Coordinate data security access management with Info Sec and Infrastructure teams.

• Analyze and resolve database performance bottlenecks.
• Optimize SQL queries, indexes, execution plans, and database configurations.
• Monitor resource consumption and recommend performance improvements.
• Implement proactive monitoring and alerting for production systems.

• Automate operational tasks using Power Shell, T-SQL, Azure CLI, or Python.
• Support CI/CD pipelines for database deployments using Azure Dev Ops or Git Hub Actions.
• Automate database maintenance, monitoring, and reporting processes.
• Monitor database environments using Azure Monitor, Log Analytics, SQL monitoring tools, and Databricks monitoring capabilities.
• Respond to production incidents, troubleshoot issues, and perform root cause analysis.
• Maintain operational runbooks and standard operating procedures.
• Participate in on-call support rotations when required.

• Implement database security best practices.
• Manage user access, encryption, auditing, and compliance controls.
• Perform vulnerability assessments and security remediation.

• Bachelor’s Degree in Computer Science, Information Technology or Engineering.
• 4+ years of experience administering Azure SQL and MS SQL Server environments.
• Strong knowledge of T-SQL programming and query optimization.
• Experience with SQL Server backup and recovery strategies.
• Knowledge of High Availability and Disaster Recovery (HA/DR) solutions.
• Experience with Azure Monitor, Log Analytics, and performance monitoring tools.
• Familiarity with Power Shell, Azure CLI, or Python scripting.
• Experience with Azure Dev Ops, Git Hub, or CI/CD pipelines.
• Strong troubleshooting and analytical skills.
• Excellent communication and documentation skills.
• Ensure compliance with organizational governance and regulatory requirements.

Wilson Elser offers a competitive salary and benefits package designed to support our attorneys both professionally and personally.

A variety of factors are considered in making compensation decisions, including but not limited to experience, education, licensure and/or certifications, geographic location, market demands, other…