Senior Postgres DBA

| Chicago

What you will be doing:

Lumere is looking for a Senior Database Administrator to architect, build, and manage our PostgreSQL database infrastructure. This position will also serve as a coach for our software engineering and analytics teams in effective query and schema design, performance optimization, and all other database related matters.

The successful candidate will have advanced knowledge of relational database design, Postgres features and utilities, strong tuning and optimization skills, exceptional communication skills, and the ability to manage multiple development and production Postgres environments.

Responsibilities include:

  • Proactively monitoring database performance and troubleshooting issues
  • Working cross-functionally with our engineers and analytics professionals to optimize queries, fix performance bottlenecks, improve existing schemas and design new ones
  • Creating and maintaining change control and testing processes, reviewing and approving database modifications
  • Conducting research and making recommendations on data-related products, services, protocols, and standards; planning for future growth of our data asset
  • Reviewing development and deployment processes related to databases and identifying areas of improvement (such as online schema changes)
  • Creating and maintaining documentation, troubleshooting playbooks, testing failover and recovery plans
  • Improving database expertise company-wide

Qualifications:

  • PostgreSQL DBA experience in a 24x7 production environment
  • 6+ years of database management and engineering experience
  • BS in Computer Science, Information Systems or related technical degree; or equivalent combination of education and experience
  • Exceptional SQL development and performance tuning skills
  • Experience architecting a large-scale production database platforms
  • Expertise with Postgres system metrics and optimization strategies
  • Familiarity with system level metrics and practical use of common Linux utilities
  • Mastery of one of the following scripting languages: Python, Perl, Bash
  • Understanding of virtualization and clustered environments
  • Great communication skills and a passion for both teaching and learning
Read Full Job Description

Technology we use

  • Engineering
  • Sales & Marketing
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • D3JSLibraries
    • jQueryLibraries
    • Twitter BootstrapLibraries
    • DjangoFrameworks
    • Vue.jsFrameworks
    • PostgreSQLDatabases
    • RedisDatabases
    • WordpressCMS
    • HubSpotCRM
    • IntercomCRM
    • SalesforceCRM
    • IntercomEmail

Location

33 N LaSalle St. Suite 1500, Chicago, IL 60602

What are Lumere Perks + Benefits

Culture
Volunteer in local community
Culinary Care
Friends outside of work
Eat lunch together
Intracompany committees
Affinity Groups, Sports teams, GrassRoots Environmental Group, Book Clubs, Manager Forums, etc.
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
We provide up to 6 weeks of parental leave for the primary caretaker. Acme Co. also provides 2 weeks of leave for the secondary caretaker.
Flexible Work Schedule
Acme Co. provides employees with a flexible work schedule that includes Summer hours, Flexible start and end times.
Remote Work Program
Family Medical Leave
Return-to-work program post parental leave
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Recreational Clubs
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Acme Co. hosts lunch and learn meetings once per month.
Cross functional training encouraged
Promote from within
Time allotted for learning
Online course subscriptions available

Additional Perks + Benefits

Health and wellness initiatives: discounted gym membership, in-office yoga and meditation, variety of snack and beverage options, monthly catered lunch, and more! • Competitive compensation package (includes equity • Social events: Books and Brews, game nights, recreational sports leagues, team outings, fireside chats, and volunteer programs • Ongoing professional development and mentorship opportunities • Open and collaborative office environment, standing desks, beer and cold brew on tap, and casual dress

More Jobs at Lumere22 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Marketing
Operations
Product
Project Mgmt
Sales
Data + Analytics
new
Chicago
Sales
new
Chicago
Product
new
Chicago
Marketing
new
Chicago
Marketing
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Product
new
Chicago