Job Directory Senior Postgres DBA

Senior Postgres DBA
Chicago, IL

Companies like
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.

About

Job Description

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

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.