The Database Administrator (DBA) manages the Firm’s Microsoft SQL Server databases in both development and mission-critical production environments. The DBA is responsible for the overall health of the Firm’s databases, and duties include design, installation, provisioning hosts, backup/recovery, deployment, performance tuning, and maintenance. The DBA translates technical requirements into database solutions (logical and physical database design principles) and works closely with software developers to implement robust, scalable applications. In production environments, the DBA manages, monitors, analyzes performance (usage), database metrics (efficiency), and data security (access), while ensuring high levels of data availability.
- Responsible for day-to-day support, such as validating backups, restoring backups, reviewing disk utilization, capacity planning, monitoring database health, troubleshooting performance issues.
- Develop preventative maintenance procedures to ensure databases are performing optimally with the primary objective of minimizing down time.
- Build an asset/configuration management system to track database usage and dependencies.
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
- Assist developers with complex query tuning and schema refinement.
- Perform scheduled maintenance and support release deployment activities.
- Apply Critical Patch updates and Patch Set Upgrades.
- Recommend long-range and annual technology plans and provide input into budgeting requests.
- Develop and execute project management plans to achieve desired time lines as systems and programs are selected, purchased, installed, and/or further developed.
- Assist with the design, testing, and implementation of disaster recovery and business continuity plans, procedures, audits, and enhancements.
- Promote unparalleled customer service to lawyers and clients.
- Communicate complex system information and ideas effectively and efficiently to lawyers, managers, and staff.
- ETL, Data Engineering and Reporting Solutions (Power BI, SSRS, SSIS, Tableau, etc.).
- Work with Cloud data platform such as Snowflake.
- Perform other duties as assigned.
- Bachelor's degree required, or equivalent combination of education and applicable experience.
- 4-5 years progressive work experience as Microsoft SQLServer database administrator.
- 3+ years managing all DB maintenance plan activities including backups, indexing, integrity, and consistent checks.
- 3+ years with developing stored procedures and PowerShell scripts.
- 3+ years monitoring and resolving database blocking, deadlocks, replication, and log shipping issues.
- Experience supporting legal specific applications like iManage, 3E, vi, Intapp preferred, but not required.
- Strong written, verbal, and interpersonal skills required.
- Strong analytical ability and problem solving skills required.
- You must be fully vaccinated against COVID-19 by your hire date to be eligible for starting in the role. Proof of vaccination will be required. Firm will provide reasonable accommodation(s) based on medical or religious grounds for qualified candidates.
- Position requires access to equipment, software, or technology that is subject to U.S. export controls. To be granted access pursuant to US Export Control laws, candidate must be either (a) a United States citizen or national; (b) a person lawfully admitted for permanent residence of the United States (i.e., “Green Card” holder); or (c) an INS-approved refugee or asylum holder who has applied for naturalization within six months of the date the individual first became eligible; and if not yet naturalized, is still actively pursuing naturalization if 2 years have passed since the date of application to be granted access pursuant to US Export Control laws. Candidates will be required to submit appropriate documentation to determine whether access can be granted before proceeding further through the application process.