Litigation and Practice Support - Development Operations Analyst
Sidley Austin LLP
Location: Chicago, Illinois
Type: Full Time
Information Technology (IT)
4 Year Degree
The DevOps Analyst role helps design, develop and maintain useful, reliable and secure processes and assists with the maintenance of the technical infrastructure that hosts such processes for the Litigation and Practice Support systems and its users.
The role works in tandem with other developers and the Litigation Support Operations group focusing on enhancing and creating new and better workflows. The position also works in direct relationship with the System Administrator as well as Project Managers, IT and Outside vendors to maintain, troubleshoot and support existing infrastructure in order to guarantee continuous access to Department information. Specific duties include development of new automated solutions, SQL administration, SQL development, maintaining and creating documentation, working as part of a team to solve issues with both proprietary and licensed systems and interacting with outside support and other internal IT resources.
Create and maintain automated processes using technical methodologies, programmatical languages, support tools and systems for the Litigation Support Department
Develop and maintain custom SQL stored procedures and PowerShell scripts to automate department workflows and reduce manual administration
Assist in the implementation and administration of SQL maintenance plans, SQL clusters, SQL disaster recovery plans
Design, document, and implement new process workflows
Interact with SQL Databases to be able to feed other systems, generate reports, provide application support to SQL-based systems and assist with Business Intelligence initiatives
Monitor capacity, administer and archive data storage, as required, using scripting, copy utilities and comparison software on storage volumes for both SQL and flat file storage
Provide escalated application support as necessary for department software, coordinate and interact with both internal IT teams and Vendor support teams to support such 3rd party systems and applications
Maintain proper documentation regarding new and existing Department processes
Availability to respond to afterhours requests, alerts and emergencies as needed and periodically help with the installation and upgrade of department systems after hours
Ability to quickly learn backend and user facing systems
To perform this job successfully, an individual must be able to perform the Duties and Responsibilities (Duties) above satisfactorily and meet the requirements below. The requirements listed below are representative of the minimum knowledge, skill, and/or ability required. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions of the job. If you need such an accommodation, please email firstname.lastname@example.org (current employees should contact Human Resources).
Education and/or Experience:
Bachelor’s degree in Computer Science, Information Technology or equivalent experience
SQL skills and technical knowledge regarding relational databases
Proficient in one or more coding languages as well as knowledge of development best practices
Experience documenting and/or automating IT processes and workflows
Knowledge of and ability to troubleshoot problems with Windows Servers, Workstations, Databases, Networks, Firewalls, and Applications
Experience with Workflow-design tools such as Visio
Experience with SQL Database Administration
Data analysis and reporting skills in SQL, Excel, Access, etc.
Other Skills and Abilities:
The following will also be required of the successful candidate:
Strong organizational skills
Strong attention to detail
Strong interpersonal communication skills
Strong analytical and problem-solving skills
Able to work harmoniously and effectively with others
Able to preserve confidentiality and exercise discretion
Able to work under pressure
Able to manage multiple projects with competing deadlines and priorities
Sidley Austin LLP is an Equal Opportunity/Affirmative Action employer.