Join our talent network

Contract - SQL Administrator

This job posting is no longer active

Job ID: 5516

Updated: Mar 10, 2021

Location: Chicago, IL, United States

Category: Information Technology


About Kirkland & Ellis

Kirkland & Ellis LLP is a preeminent, full-service law firm with offices around the world and a staff as diverse as the practice areas we support. Our clients range from Fortune 100 companies to medium and small corporations, financial institutions, and private equity firms.  Known for our commitment to excellence, Kirkland strives to provide superior service to our clients as well as our fellow employees. From Information Technology to Human Resources, Paralegal Services to Business Development, Kirkland offers non-attorney professionals challenging careers in a variety of functional areas. Whether starting or growing your career, Kirkland can offer a performance-driven culture filled with bright and innovative teams of co-workers.

Essential Job Functions

  • Administer PostgreSQL databases through all phases of their development lifecycle.
  • Perform routine database maintenance tasks including vacuuming, statistics updates, reindexing, and log file maintenance.
  • Setup monitoring using the statistics collector or third-party tools to ensure optimal query performance.
  • Configure backup and recovery plans for each PostgreSQL instance to meet or exceed service level agreements.
  • Install and configure PostgreSQL instances on multiple operating systems with consistency and in accordance with industry best practices.
  • Plan and implement high availability, load balancing, and replication.

Qualifications & Requirements

  • Minimum 5 years of experience with PostgreSQL 9.6 or greater.
  • Experience installing and administering PostgreSQL on multiple Linux distributions (e.g. Red Hat, Ubuntu, CentOS)
  • In depth knowledge of PostgreSQL internals.
  • Solid understanding of database design principals.
  • Familiarity using using execution plans to optimize query performance.
  • Good SQL language skills including the use of routines and PL/pgSQL.
  • Good performance tuning skills for both the instance and queries.
  • Ability to proactively identify, troubleshoot and resolve production database or instance issues.
  • Knowledge of disaster recovery principles and practices, including configuring backups and testing restores.
  • Hands-on experience with the setup and configuration of high availability environments.
  • Ability to set and meet deadlines.
  • Ability to work in high-pressure situations.
  • Excellent attention to detail.
  • Strong written and verbal communication skills, including technical writing and documentation.

How to Apply

Thank you for your interest in Kirkland & Ellis LLP.  To complete an application and submit your resume, please click "Apply Now."

Equal Employment Opportunity

All employment decisions, including the recruiting, hiring, placement, training availability, promotion, compensation, evaluation, disciplinary actions, and termination of employment (if necessary) are made without regard to the employee’s race, color, creed, religion, sex, pregnancy or childbirth, personal appearance, family responsibilities, sexual orientation or preference, gender identity, political affiliation, source of income, place of residence, national or ethnic origin, ancestry, age, marital status, military veteran status, unfavorable discharge from military service, physical or mental disability, or on any other basis prohibited by applicable law.

Closing Statement

The job postings and recruiting mailbox are for candidates only. If you are a recruiter, search firm or employment agency, and do not have a signed contract with Kirkland & Ellis LLP ("K&E") and have not been asked specifically to submit candidates, you will not be compensated in any way for your referral of a candidate even if K&E hires the candidate. Direct contact with K&E employees in an attempt to present candidates is inappropriate and will be a factor in determining any future professional relationship with the Firm.