Engineer, Enterprise Data Systems

Weil, Gotshal & Manges LLP•New York, NY

4d•$125,000 - $145,000

About The Position

The Engineer, Enterprise Data Systems works directly with IS management and staff to support the administration, maintenance, and enhancement of the Firm’s Microsoft SQL Server database and related applications. This role assists with maintaining application availability by minimizing database and application downtime, and participating in the ongoing development, testing, integration, maintenance, and support of all Firm systems that rely on SQL Server.

Requirements

3+ years of experience administering Microsoft SQL Server in an enterprise environment.
Familiarity with Windows server operating systems, and an understanding of server hardware as it relates to SQL Server, especially in the areas of CPU, RAM, and I/O subsystems, as well as an understanding of basic networking concepts.
Extensive experience writing advanced SQL queries and stored procedures and troubleshooting their performance.
Thorough understanding of relational database design principles such as key selection, relationships, normalization, etc.
Strong working knowledge of SQL Server business intelligence tools (SSIS, SSAS, SSRS, PowerBI, etc.).
Able to work well under minimal supervision.
Able to manage and prioritize multiple projects simultaneously.
Self-motivated with good time management and project management skills.
Excellent verbal and written communication skills, with an ability to communicate effectively with people of varying technical expertise.
Experience providing technical support for a large, geographically dispersed organization.
Highly analytical and excellent problem solver.
Fast learner who adapts quickly.

Nice To Haves

Creating Datasource/DataFlow and PowerBI Dashboards and migrating SSRS reports to PowerBI would be a plus.
Experience working with SQL Server in the Azure platform will be a plus.
Experience with scripting / programing languages such as PowerShell, .Net and C# will be a plus.
Experience managing and administering iManage Work document management system will be a plus.
Experience working with Intapp Integrate / Integration Builder, Intapp Time, and Intapp Walls will be a plus.
Microsoft SQL Server or other RDBMS certifications a plus.
Azure Certifications a plus
PowerPlatform certification a plus.
iManage Work (ICSE) certifications a plus.

Responsibilities

Assist in maintaining all SQL instances and databases to support system availability.
Troubleshoot and resolve any issues as they arise, providing support to the application owners.
Assist with configuration and installation of Microsoft SQL Server (including database mirroring, and AlwaysOn Availability Group setup).
Support SQL Server infrastructure administration by assisting with performance tuning, system monitoring, and issue resolution.
Maintain the Firm's Document Management System and its underlying databases, including periodic upgrades and enhancements.
Support the Firm’s financial application as well as any related tasks.
Develop and maintain data integrations and consistency across Firm systems.
Assist in the analysis and delivery of data stored in Firm systems through SQL Server business intelligence tools.
Perform installations, upgrades, and customizations for new and existing SQL systems.
Follow group procedures and policies related to the SQL Server environment, including installations, configurations, backups, disaster recovery, and other such operations.
Any other responsibilities or special projects as assigned by management.