Postgres DBA

Blue Ribbon Global Technologies; Pittsburgh (Allegheny County); Teletrabalho; USD 90 000 - 140 000; Tempo integral

Resumo da oferta

Blue Ribbon Global Technologies seeks an experienced Postgres DBA to optimize and manage AWS Aurora deployments across production environments. You will be hands-on, tuning queries, planning backups, and ensuring peak performance.

You'll collaborate with product and engineering teams to translate complex data needs into scalable solutions, helping clients achieve real-time insights. Remote start with eventual onsite work at our Pittsburgh office.

Qualificações

• 5–7 years of experience with Postgres.
• Advanced knowledge of Postgres configuration, management and optimization.
• Experience analyzing query performance and tuning.
• Experience with AWS Amazon Aurora is highly desired.
• Strong analytical ability and attention to detail.

Responsabilidades

• Maintains AWS Amazon Aurora PostgreSQL performance by tuning parameters and applying updates.
• Perform configuration, upgrade, monitoring and other database administration tasks.
• Develop techniques for large-scale optimization including indexing and data preprocessing.
• Establish best practices to manage all Postgres environments consistently.
• Collaborate with users and SMEs to design optimal data architectures and communicate results clearly.
• Define database structure, security, backup, and recovery specifications.
• Maintain quality service by enforcing standards.

Conhecimentos

PostgreSQL

Query optimization

AWS Aurora

SQL

Analytical skills

Formação académica

Bachelor's degree in Computer Science, Mathematics or related technical field

Ferramentas

AWS Aurora PostgreSQL

Descrição da oferta de emprego

PREFILL DO NOT WORK

We are seeking an exceptional and experienced Postgres DBA who shares our passion and obsession with quality. You'll be a core member of our product and engineering team dedicated to helping our clients replace time-consuming, manual processes to reach informed real-time decisions about government markets, competitors, and agency relationships.

We need a skilled and dedicated DBA to join our team to be our Postgres expert. You must be a hands-on DBA focusing on managing our Postgres Environments with strong skills in optimizing and tuning the platform and queries to achieve peak performance.

In order to do this job well, you must be a curious and eager problem solver with a hunger for delivering high-quality data solutions. You have a passion for great work and nothing less than your best will do. You share our intolerance of mediocrity. You re uber-smart, challenged by figuring things out and producing simple solutions to complex problems.

This is a team member position, initially remote, but will eventually require working onsite in our Pittsburgh, PA office.

Job Description

Scope of Responsibilities

• Maintains AWS Amazon Aurora Postgres database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements;
• Perform configuration, upgrade, monitoring and other database administration tasks.
• Apply various techniques to produce solutions to large-scale optimization problems, including data pre-processing, indexing, blocking, field and record comparison and classification
• Build best practices to manage all Postgres environments in a consistent manner
• Work directly with users as well as SMEs to establish, create and populate optimal data architectures and structures, as well as articulate techniques and results using non-technical language
• Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
• Maintains quality service by establishing and enforcing organization standards.

Required Skills

• 5-7 years experience working with Postgres
• Advanced knowledge of Postgres platform configuration, management and optimization.
• Demonstrated experience analyzing query performance, troubleshooting and performance tuning.
• Experience working with AWS Amazon Aurora highly desired
• Advanced PostgreSQL programming skills to create stored procedures, advanced views, etc.desired
• Requires strong analytical ability and attention to detail
• Bachelor's degree in Computer Science, Mathematics or related technical field
• Ability to work independently with little supervision
• A burning desire to tackle hard problems and create sustainable solutions

Desired Skills

• Experience in or exposure to the nuances of a startup or other entrepreneurial environment
• Working knowledge with large (multiple terabytes) amounts of data

Required Skills : SQL

Basic Qualification :

Additional Skills : Database Developer

Background Check : No

Drug Screen : No