Database Technical Lead at Ensono

| Chicago | Remote
Sorry, this job was removed at 7:08 a.m. (CST) on Thursday, October 14, 2021
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Reports to the Sr Manager -POD, with a matrix reporting to the US Database manager. You'll be part of Database Technical Leads & Global Implementation team, supporting the migration activities of mission critical infrastructure of Ensono's clients, delivering a responsive and exceptional support service for client events and requests. Using a best-in-class client service management platform you will effectively be working on client projects, providing solution deliveries to clients on complex environments and infrastructure, and supporting at times our day to day business as usual support activities from our clients. The job entails:
  • Primary role will be to support our existing & new clients.
  • Working with clients on issues, requests related to Projects.
  • Working proactively and reviewing high level project requirements and deliverables.
  • Lead & guide the team during major incidents & Outages
You will achieve common goals with our teams to create a positive learning environment where knowledge sharing will help all associates be able to support the environment in the migrated DC. The position will be challenging with opportunities to work on a broad range of Postgres software and products.
Key Responsibilities
  • Responsibility for client project initiatives and support for Postgres platforms.
  • Design and enhance, upgrade, or build new client PostgreSQL environments
  • Work closely with clients daily on projects, troubleshooting, or consultations.
  • Perform software installations, upgrades, and patches to PostgreSQL instances and servers
  • Define and maintain Postgres standards and governance
  • Strategy, Architecture, Security & Compliance, Engineering & Operation.
  • Mentor, documenting all the process & eliminate single point of failure.
Knowledge
Required
  • 8+ year's professional experience as a PostgreSQL (Enterprise DB ASE) database administrator, minimum 3 years as expert with strong working knowledge of Operational/Systems DBA to setup and support PostgreSQL
  • In depth knowledge of the PostgreSQL architecture
  • Experienced in installing, configuring, and upgrading PostgreSQL databases and clusters.
  • Experience in configuring and supporting Enterprise Manager.
  • Setting up users tools for administration.
  • Experience in deploying PostgreSQL in Linux on Power environment and good understanding of operating system concepts of Linux (RHEL).
  • Good knowledge of capacity planning and architecture design for database server deployment.
  • Working knowledge of architecting, configuring, setting up Enterprise Fail over manager for HA solution.
  • Experience in setting up PostgreSQL Replication.
  • Working Knowledge of connection poolers (pgPool and pgBouncer)
  • Perform routine maintenance on several database environments including application of updates, patches, and hotfixes
  • Installation/configuration and implementation of PEM, BART, xDB/EFM, Performance Dashboard.
  • Creating databases, migrating database objects from non-production to production environment.
  • Designing and building data models, schemas, views, and tables to support application requirements
  • Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools such as Guardium.
  • Extensive experience designing and executing backup and recovery concepts and procedures
  • Measure database performance and troubleshoot complex database issues, I/O bottlenecks, SQL Tuning/
  • Experience in using Splunk, Nimsoft for Availability and performance.
  • Good understanding of licensing options and optimization.
  • Experience in scripting languages (shell or python or Perl) for automating DBA administrative tasks.
  • Experience with automation tools such as Control-M.
  • Experience in working with PostgreSQL on AWS or Azure environments.
  • Experience in implementing Postgres STIG implementation, testing, and other vulnerability remediation.
  • In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.
Desired• Product automation knowledge: Ansible, Terraform, PowerShell, etc.
  • Proficient with AWS Redshift is a plus.
  • Experience/Knowledge with Neo4J, DynamoDB & Sybase ASE/IQ is a plus.
  • Experience building solutions to migrate Oracle databases to Postgres.
  • Certification in AWS or GCP or Azure is a plus.
Skills
  • Ability to work independently, analyze the requirement, and provide solutions.
  • A 'client centric' approach
  • Excellent demonstrable English written and verbal communication skills
  • Able to communicate in groups with confidence and conviction
  • Ability to multi-task and work well under pressure
  • Excellent team working skills are essential
  • Ability to document processes and procedures in a clear, concise, and logical manner
  • Self-starter with the capability to work independently and produce positive results that will keep migration timelines on schedule
Experience
  • At least 8 years' experience in an IT PostgreSQL support environment
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • RLanguages
    • SqlLanguages
    • AzureLanguages
    • AWSLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • AWSFrameworks

Location

Our HQ is 22 miles from the Loop; near Belmont station, BNSF line. Plenty of places to eat & shop! 2nd office is in downtown Chicago on Madison Ave.

An Insider's view of Ensono

What’s the vibe like in the office?

I find the culture to be very open and collaborative. One can be on a call with a customer and ask your technical resource across from you a specific question or run into our CEO in the hallway while grabbing a cup of coffee. We allow feedback to be given and changes to be heard. Leadership constantly finds ways to make it an exciting workplace

Bailey Cahill

Senior Manager - Partner & Alliances

What does your typical day look like?

A typical day in our Full Stack DevOps world is collaborative, affords room for creative problem-solving, offers unique opportunities and challenges. Our work involves using cloud technologies to solve application’s needs, research datalake technologies and architect to process large amounts of performance data. We also lay 6 man variation of ping

Jake Frazier-Flores

Software Engineer

What are Ensono Perks + Benefits

Ensono Benefits Overview

Benefits include - generous maternity and paternity leave, generous paid days off and company paid holidays. Sabbatical, adoption, compassion and bereavement leave days, adoption assistance and flexible spending account. Healthcare and 401K eligibility on 1st day of work. Paid volunteer days.

Wellness programs - designed to help us be our best! Fitness week, Virgin Pulse® platform, wellness plans for credits and discounts on medical plan contributions.

Fun ergonomic workplace - free snacks, onsite gym & trainer, yoga classes, Beer O'Clock days.

Culture
Volunteer in local community
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Unconscious bias training
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Sabbatical
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Beer O' Cart every month!
Casual Dress
Game Room
Stocked Kitchen
Parking
Recreational Clubs
Relocation Assistance
Fitness Subsidies
Onsite gym available!
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Promote from within

Additional Perks + Benefits

15 options for coffee and chocolate drinks (its a coffee machine with an IP address after all!) Also, Starbucks machine with chai latte counts, right? And then after the free snacks and all the hot chocolate - get some steps in while checking your emails in our fitness center. We have associate discounts on various products and services locally and nationally.

More Jobs at Ensono52 open jobs
All Jobs
Data + Analytics
Dev + Engineer
HR + Recruiting
Marketing
Operations
Product
Project Mgmt
Sales
Content
Product
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Content
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Ensono's full profileSee more Ensono jobs