Legal Staff Information Technology in Chicago, IL

Law Firm

Chicago, IL

Legal Staff Information Technology in Chicago, IL

Legal Staff

No

Job Title:
Senior Enterprise Database Administrator

Job Responsibilities:
- Assess and develop long-term strategic goals for production databases in collaboration with data owners.
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure the protection and integrity of data assets.
- Work with the Infrastructure teams to ensure databases and critical data are properly backed up and protected in accordance with the needs of the application’s primary stakeholder and the law firm's disaster recovery and data retention policies.
- Provide day-to-day support for the law firm’s SQL systems and applications, including monitoring database health to ensure a stable environment and diagnosing and resolving database access and performance issues.
- Gather requirements and translate them into data distribution and utilization needs; design databases meeting specifications addressing content management, content indexing, reporting, and workflow requirements.
- Plan and coordinate data migrations between systems.
- Develop, implement, and maintain change control and testing processes for modifications to databases.
- Design, implement, and maintain cloud-based database systems when required.
- Ensure all proposed changes to the live application or infrastructure environments are suitably tested with roll-back capability and change controls exercised accordingly.
- Implement, configure, and manage SQL High-Availability Clusters.
- Support Applications implementation projects from initiation to completion.
- Install a middle-tier application layer when required.
- Provide third-line applications support and database administration support; troubleshoot and resolve escalated issues.
- Provide timely responses and resolutions towards database backup, restore, mirroring, and synchronization requests.
- Contribute to patching, change control maintenance activities, and participate in on-call rotation.
- Perform other duties as assigned to fully meet the requirements of the position.

Education and Experience Information:
- Bachelor’s degree in business, computer science, information systems, or related certifications.
- Law firm or professional services experience preferred.
- Proven experience as a technical Subject Matter Expert (SME) in a 24 x 7 global support environment.
- Expertise in SQL Clustering/High-Availability Implementations.
- In-depth understanding of High Availability and Disaster Recovery concepts concerning database systems.
- Strong understanding of cloud database technologies, specifically Microsoft Azure.
- Proficient in the client/server application stack.
- Working knowledge of Transact-SQL, Stored Procedures, SQL Mail, SSRS, and triggers.
- Familiarity with Windows Server, IIS, DNS, DHCP, and Active Directory.
- Experience supporting standard legal systems preferred (iManage DMS, Elite, Interaction).
- SQL administration experience in versions 2012 onward, with confidence in converting databases to newer versions.
- Ability to document processes and procedures, including technical diagrams related to organizational data flow.
- Recognizes the importance of documentation and well-defined procedures.
- Capable of interacting positively and with tact across all levels and being a good team player.
- Demonstrates excellent client/customer-facing skills.
- Strong problem-solving and analytical skills; ability to clearly explain and present problems and issues to others and contribute to their resolution.
- Capable of making decisions and remaining calm under pressure, particularly when dealing with difficult situations.
- Methodical approach to work, with a strong focus on accuracy and quality.
- Ability to work under pressure to meet tight project deadlines and adapt to differing demands, prioritizing tasks as appropriate.
- Demonstrates confidence and resilience to overcome obstacles to deliver what is required.
- Excellent written and verbal communication skills.

Salary Information:
The law firm offers a competitive salary and benefits package, including medical, dental, vision, 401k, profit sharing, short-term/long-term disability, life insurance, tuition reimbursement, paid time off, paid holidays, and discretionary bonuses.

The law firm is an Equal Opportunity Employer - Disability/Vet. Pursuant to local ordinances, the law firm will consider for employment qualified applicants with arrest and conviction records.

If you need any assistance seeking a job opportunity at the law firm or require reasonable accommodation with the application process, please contact the law firm's Talent Acquisition Specialist.