Job Description
Under the direct supervision of the Manager of Enterprise Data Systems, the engineer 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. The engineer will work to maximize application availability by minimizing database and application downtime. They will assist with and advise in the ongoing development, testing, integration, maintenance, and support of all Firm systems that rely on SQL Server.
Primary Responsibilities and/or Essential Functions:
- Monitor and maintain all SQL instances and databases in order to maximize system availability. Quickly diagnose and resolve any issues as they arise. Provide support as required by application owners.
- Configuration and installation of Microsoft SQL Server (including database mirroring, and AlwaysOn Availability Group setup).
- Proactively manage and monitor SQL Server infrastructure and assist teams to tune performance and remediate any issues utilizing the database infrastructure.
- Manage and maintain the Firm's Document Management System, and the underlying databases. Quickly diagnose and resolve any issues as they arise. Implement periodic upgrades and enhancements.
- Support the firm's financial application as well as 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 analysis and delivery of data stored in Firm systems through the use of SQL Server business intelligence tools.
- Provide advice and guidance to other IS staff and managers, and outside vendors and consultants regarding the architecture and configuration of new and existing SQL systems and their corresponding applications. Perform installations, upgrades, and customizations for those systems.
- 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.
- Any other responsibilities or special projects as assigned by management.
Knowledge, Skills & Abilities:
- 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.). Creating Datasource/DataFlow and PowerBI Dashboards and migrating SSRS reports to PowerBI would be a plus.
- 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 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 Elite 3E financial application suite 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.
Education/Certifications:
- Bachelor's degree in Computer Science, Information Systems, or a related discipline.
- Microsoft SQL Server or other RDBMS certifications a plus.
- Azure Certifications a plus.
- PowerPlatform certification a plus.
- iManage Work (ICSE, RAVN) certifications a plus.
Estimated salary range is $120,000 - $130,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 insurance, flexible spending plan and a 401K plan. Weil also offers generous paid time off and holidays. 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.