1

Postgresql Associate Jobs in Illinois (NOW HIRING)

A prestigious company is in need of a PostgreSQL Database Administrator. This DBA must have 7+ ... experience as an associate DBA * Well versed in all phases of Systems Analysis and Design

Senior PostgreSQL DBA

Chicago, IL

$51.25 - $70.50/hr

... associate DBA [Required] Well versed in all phases of Systems Analysis and Design [Required ... with PostgreSQL (preferred EnterpriseDB (EDB) version) [Required] 3+ year' Terraform, Ansible ...

Senior Database Administrator

Deerfield, IL · On-site

$110.40K - $173.47K/yr

Associate Job Type: Full Time Nutrien is a leading provider of crop inputs and services, and our ... Perform PostgreSQL major/minor version upgrades including pre-checks, extension upgrades, post ...

Senior Database Administrator

Deerfield, IL · On-site

$110.40K - $173.47K/yr

Associate Job Type: Full Time Nutrien is a leading provider of crop inputs and services, and our ... Perform PostgreSQL major/minor version upgrades including pre-checks, extension upgrades, post ...

Java FSD

Chicago, IL · On-site

$52.50 - $68/hr

... Tampa position- associate must attend in-person client interview in Tampa) Strong Java Fsd ... Solid understanding of SQL and relational databases (e.g., PostgreSQL, Oracle, MySQL). Familiarity ...

Lead Data Engineer, Associate Director

Chicago, IL · On-site

$118K - $141.80K/yr

Fitch Group is currently seeking a Associate Director/Lead Data Engineer based out of our Chicago ... Design and implement data solutions using PostgreSQL for relational data and MongoDB for NoSQL ...

Lead Data Engineer, Associate Director

Chicago, IL · On-site

$118K - $141.80K/yr

Fitch Group is currently seeking a Associate Director/Lead Data Engineer based out of our Chicago ... Design and implement data solutions using PostgreSQL for relational data and MongoDB for NoSQL ...

Our associates support the brands with a wide range of services, including Finance, Legal ... PostgreSQL), NoSQL(Azure Cosmos DB or Cassandra) and event driven architecture solutions such as ...

next page

Showing results 1-20

Postgresql Associate information

What are the key skills and qualifications needed to thrive as a PostgreSQL Associate, and why are they important?

To thrive as a PostgreSQL Associate, you need a solid understanding of database concepts, SQL querying, and experience with PostgreSQL database management. Familiarity with tools like pgAdmin, command-line utilities, and certifications such as the EDB PostgreSQL Associate certification are often required. Strong problem-solving abilities, attention to detail, and effective communication are essential soft skills for this role. These competencies ensure efficient database administration, data integrity, and effective collaboration with development and IT teams.

What are some common challenges faced by a PostgreSQL Associate, and how can they be addressed?

PostgreSQL Associates often encounter challenges such as optimizing query performance, managing large datasets, and ensuring database security. These issues can be addressed by regularly monitoring system logs, using indexing and partitioning strategies, and staying up-to-date with the latest security patches. Collaborating closely with developers and system administrators is also essential to troubleshoot performance bottlenecks and maintain a reliable database environment. Continuous learning and participation in the PostgreSQL community can further help associates stay informed about best practices.

What is a PostgreSQL Associate?

A PostgreSQL Associate is a professional who has foundational knowledge and skills in managing, maintaining, and administering PostgreSQL databases. Their responsibilities often include performing basic database operations, supporting users, ensuring data integrity, and helping optimize queries. They work under the guidance of more senior database administrators or developers and are typically involved in monitoring performance, performing backups, and troubleshooting simple issues. This role is ideal for those starting a career in database management and looking to gain hands-on experience with PostgreSQL.

What is the difference between Postgresql Associate vs Database Administrator?

AspectPostgresql AssociateDatabase Administrator
Required CredentialsTypically a bachelor's degree in computer science or related field; certifications like PostgreSQL Certified Associate are commonAdvanced certifications such as Oracle Certified Professional or PostgreSQL Certified Professional; extensive experience often required
Work EnvironmentSupport roles in IT teams, assisting with database setup, maintenance, and troubleshootingOversees entire database systems, manages performance, security, and backups in enterprise settings
Employer & Industry UsageUsed in tech companies, startups, and organizations utilizing PostgreSQL databasesFound in large corporations, financial institutions, and data-driven enterprises

The Postgresql Associate role focuses on supporting and maintaining PostgreSQL databases, often under supervision, while a Database Administrator has broader responsibilities, including system optimization and security management. Both roles require technical knowledge, but the DBA position typically demands more experience and advanced certifications.

What are the most commonly searched types of Postgresql jobs in Illinois? The most popular types of Postgresql jobs in Illinois are:
What cities in Illinois are hiring for Postgresql Associate jobs? Cities in Illinois with the most Postgresql Associate job openings:
PostgreSQL DBA

Other

Posted 29 days ago


Job description

***Hybrid, 3 days onsite, 2 days remote***

***We are unable to sponsor as this is a permanent full-time role***

A prestigious company is in need of a PostgreSQL Database Administrator. This DBA must have 7+ years of experience working with PostgreSQL, along with 3+ years of experience with Ansible, Terraform, Jenkins, CI/CD, etc.

Responsibilities:

  • Assists with the design, implementation, and maintaining databases
  • Manage database performance and disk usage
  • Provides support in database access methods
  • Provides consultation support in database analysis, modeling, coding, and production problem resolution.
  • Develops maintenance, backup and recovery procedures and documentation
  • Participates in Disaster Recovery drills
  • Provides Primary On-Call Support for production problems
  • Understands and supports corporate data standards
  • Recommends and assists with new DBMS and operational standards.

Qualifications:

  • Bachelor s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business
  • 7+ years experience with PostgreSQL (preferred EnterpriseDB (EDB) version)
  • 3+ year Terraform, Ansible, Jenkins & CI/CD skills
  • 3+ years experience with CTE(CipherTrust Transparent Encryption), Barman (EDB Backup and Recovery Manager) and AWS
  • 5+ years experience with DB2 LUW; preferably on Red Hat Linux
  • 1+ years experience with SQL Server
  • 1+ years experience with MySQL/MariaDB
  • 1+ years experience with DB2 in a z/OS environment
  • 3+ years experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years experience as an associate DBA
  • Well versed in all phases of Systems Analysis and Design
  • Experienced in two or more programming languages and two or more scripting languages
  • Practiced at Entity/Relationship or Object modeling and translation to physical database designs
  • Proficient in DML, DDL, and database utilities for at least two DBMS technologies
  • Proficient in all access methods of a DBMS as well as the underlying operating system access methods