Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Highly skilled and knowledgeable Administrative Staff assist our attorneys in successfully meeting and exceeding client needs and are vital to the overall success of the Firm. The Sr. Engineer, Enterprise Data Systems works directly with IS management and staff to create, manage, and maintain all Microsoft SQL Server database systems across the Firm and support related applications as needed. This role is responsible for maximizing application availability by minimizing database and application downtime, and for supporting the development, testing, integration, maintenance, and ongoing optimization of Firm systems that rely on SQL Server.

Responsibilities

Monitor and maintain all SQL instances and databases to maximize system availability.
Promptly diagnose and resolve any issues as they arise, providing support to application owners as needed.
Configure and install Microsoft SQL Server, including log shipping, database mirroring, and AlwaysOn Availability Group setup.
Proactively manage and monitor SQL Server infrastructure, assisting teams to tune performance and remediate any issues utilizing the Database infrastructure.
Manage and maintain the Firm's Document Management System (iManage DMS), and the underlying databases, including periodic updates and enhancements.
Design, implement, and maintain data integrations between firm systems while enforcing data consistency.
Develop and update Power BI or SSRS reports based on user requirements and troubleshoot data refreshes.
Independently manage projects, adhering to established timelines and budget limits.
Manage ticketing queue, route, and resolve user requests in a timely manner.
Participate in weekend and after-hours on-call support.
Provide technical guidance to IS staff and managers, and outside vendors and consultants on the architecture and configuration of new and existing SQL systems and their corresponding applications.
Perform installations, upgrades, and customizations as needed.
Establish, maintain, and follow group procedures and policies related to the SQL Server environment, including installations, configurations, backups, disaster recovery, and ongoing operations.
Any additional responsibilities as required by management.

Requirements

5+ 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.
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, Power BI 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.
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 / Boomi, and Intapp Walls will be a plus.

Skills

Microsoft SQL Server
Windows Server Operating Systems
Server Hardware
Networking Concepts
SQL Queries
Stored Procedures
Relational Database Design
SQL Server Business Intelligence Tools (SSIS, SSAS, SSRS, Power BI)
PowerShell
.Net
C#
iManage Work
Intapp Integrate
Integration Builder
Boomi
Intapp Walls

Experience Level

5+ years of experience administering Microsoft SQL Server in an enterprise environment.

Education Level

Bachelor's degree in Computer Science, Information Systems, or a related discipline preferred.
Microsoft SQL Server or other RDBMS certifications a plus.
iManage Work ICSE certifications a plus.
Boomi Certifications a plus

Salary/Compensations

$150,000 - $165,000
This position is bonus eligible.

Benefits

medical
dental
vision
disability coverage
life insurance
flexible spending plan
401K plan
generous paid time off
holidays

About the Company

Weil seeks the best and brightest talent to join our Administrative Staff team.
Our employees are the future of Weil so we invest in their training and development.
Our environment embraces and encourages positive-minded professionals who seek to be challenged and acquire knowledge and skills in an atmosphere built on teamwork.

Equal Opportunity

All decisions affecting employment at Weil, Gotshal & Manges LLP are made on the basis of qualification, performance and other pertinent work-related factors, and without discrimination against any person on the basis of race, color, sex, age, religion, national origin, disability, marital status, sexual orientation, gender identity or expression, pregnancy, veteran’s status, genetic information or any other legally protected status.