Sr. Engineer, Enterprise Data Systems

Weil, Gotshal & Manges LLP provided pay range

This range is provided by Weil, Gotshal & Manges LLP. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

$/yr - $/yr

The Sr. Engineer, Enterprise Data Systems will work directly with IS management and staff to create, manage, and maintain all Microsoft SQL Server database systems throughout the Firm, and support the corresponding applications as needed. This role is responsible for maximizing application availability by minimizing database and application downtime. They will assist and advise on the ongoing development, testing, integration, maintenance, and support of all Firm systems that rely on SQL Server.

• Monitor and maintain all SQL instances and databases in order to maximize system availability. Promptly diagnose and resolve any issues as they arise. Provide support to the application owners, as needed.
• Configuration and installation of Microsoft SQL Server, including log shipping, database mirroring, SQL Replication, and Always On Availability Group setup.
• Proactively manage and monitor SQL Server infrastructure and assist teams to tune performance and remediate any issues utilizing the database infrastructure.
• Support the firm’s document management system and support any related tasks.
• Design, implement, and maintain data integrations between Firm systems. Maintain and enforce data consistency across those systems.
• Design, implement, and maintain solutions to assist in the delivery and analysis of data stored in Firm systems through the use of SQL Server business intelligence tools.
• Advise IS staff, managers, external vendors, and consultants, r on the architecture and configuration of new and existing SQL systems and their related applications. Responsible for installations, upgrades, and systems customizations.
• Establish, maintain, and follow group procedures and policies related to the SQL Server environment, including installations, configurations, backups, disaster recovery, and other such operations.
• Manage projects independently, adhering to and helping to establish timelines and budget limits.
• Act as a team leader and coach, and advise more junior staff members.
• Any additional responsibilities as required by management.

• 5+ years of experience administering Microsoft SQL Server in an enterprise environment.
• Familiarity with Windows server operating systems, and an understanding of basic networking concepts as well as server hardware as it relates to SQL Server, especially in the areas of CPU, RAM, and I/O subsystems.
• 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, Power
  
  BI / Fabric, etc.).
• Strong understanding of Cloud platform solutions.
• Strong experience with SQL Server installations, configuration of SSIS, SSAS, SSRS, Always On, SQL Mirroring, SQL Replication, and log shipping.
• Strong ability to troubleshoot performance issues on SQL Server environment.
• Experience with Azure SQL environments (PaaS, IaaS and SaaS).
• Ability to work well under minimal supervision.
• Ability 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 Power Shell, Python, .NET, and C# will be a plus.
• Experience managing and administering iManage Work document management system will be a plus.
• Experience working with iManage applications, Intapp Integrate / Integration Builder, Boomi / Intapp Integration Services, Intapp Time, and Intapp Walls will be a plus.
• Experience working with Linux and Docker containers will be a plus.
• Experience working with Mongo
  
  DB and other No
  
  SQL databases will be a plus.

• Bachelor’s degree in Computer Science, Information Systems, or a related discipline.
• Microsoft SQL Server or other RDBMS certifications a plus.
• AZURE CLOUD CERTIFICATIONS A PLUS.

Estimated salary range is $150,000 - $165,000. Compensation decisions within the range are dependent on the facts and circumstances of each case including but not limited to the individual's skills, experience, and qualifications.

Weil, Gotshal & Manges LLP offers a competitive compensation package comprised of base pay and discretionary year-end bonus for eligible employees. Benefits include, but are not limited to medical, dental, vision, disability coverage, life…