Postgresql Database Administrator
Centric Software
About Centric Software
Centric Software® is a global leader, providing an innovative and AI-enabled product-concept-to-commercialization platform for retailers, brands and manufacturers of all sizes. We equip retail, fashion, luxury, footwear, outdoor, home and consumer goods brands with pioneering best-of-breed solutionsto plan, design, develop, source, comply, buy, make, price, allocate, sell and replenish products. Our technology powers brands to streamline processes, drive efficiency and operate with confidence in an ever-changing market.About Centric Software
Centric Software® is a global leader, providing an innovative and AI-enabled product-concept-to-commercialization platform for retailers, brands and manufacturers of all sizes. We equip retail, fashion, luxury, footwear, outdoor, home and consumer goods brands with pioneering best-of-breed solutionsto plan, design, develop, source, comply, buy, make, price, allocate, sell and replenish products. Our technology powers brands to streamline processes, drive efficiency and operate with confidence in an ever-changing market.
Our story is one of rapid growth, bold ideas and extraordinary opportunities. We’re here to challenge the status quo—and we’re looking for brilliant people who want to do the same. No matter where you are in the world, this is your chance to be part of something exceptional.
Position Summary
We are seeking a PostgreSQL expert to join our R&D Customer Support team as a Production DBA. This role is focused on bringing deep Postgres expertise in-house to analyze, troubleshoot, and improve production database environments, perform root cause analysis on issues ranging from long-running queries to hosting environment problems and heavy traffic scenarios, and ensure our customers’ PostgreSQL deployments remain healthy, performant, and reliable. While the primary focus is production operations, the DBA will also work across development environments as needed to trace issues to their source and collaborate with engineering on fixes.
Position Details
Job title:
PostgreSQL Database Administrator (Production DBA)
Team:
R&D – Customer Support
Location:
Remote (US/Canada)
Employment Type:
Full-time
Compensation:
$136K USD
Key Responsibilities
Serve as the PostgreSQL expert and primary Production DBA within the R&D Customer Support team, driving the stability, performance, and reliability of customer-facing database environments.Perform root cause analysis (RCA) on production incidents spanning query performance, database configuration, infrastructure-level bottlenecks, and traffic/load conditions.Diagnose and resolve complex PostgreSQL performance, availability, and data-integrity issues, including query tuning, index strategy, vacuum/auto vacuum behavior, and lock contention.Troubleshoot and analyze production PostgreSQL systems across diverse hosting environments, ensuring performance, availability, and data integrity.Review execution plans, analyze slow queries, and recommend configuration, schema, or indexing changes to optimize production workloads.Support customers running PostgreSQL across on-premises, cloud (AWS RDS/Aurora, Azure, GCP), and self-managed deployments.Work across development and production environments to trace issues to their source and collaborate with engineering on fixes and product improvements.Advise on high-availability and disaster-recovery architectures including streaming replication, logical replication, failover, backup/restore (pg_basebackup, pgBackRest, WAL-G), and point-in-time recovery.Create and maintain internal knowledge-based articles, runbooks, and best-practice documentation for the support team.Mentor support engineers and developers on Postgres internals, SQL tuning, and operational best practices.Participate in on-call rotation for critical customer escalations as needed.
Required Qualifications
Minimum 5 years of hands-on experience as a PostgreSQL DBA, with deep knowledge of Postgres internals (MVCC, WAL, query planner, locking, buffer management) and operational best practices.Proven track record managing PostgreSQL in production environments, including incident response, root cause analysis, and performance optimization under heavy traffic.Strong SQL skills, including query optimization and execution-plan analysis (EXPLAIN / EXPLAIN ANALYZE).Experience with PostgreSQL performance tuning: indexing strategies, autovacuum, connection pooling (PgBouncer), and configuration tuning (postgresql.Conf).Experience with high availability and replication: streaming replication, logical replication, Patroni, or equivalent.Experience with backup and recovery tooling such as pgBackRest, WAL-G, pg_basebackup, or Barman.Proficiency with Linux/Unix operating systems and shell scripting (Bash or similar).Strong written and verbal communication skills, with the ability to explain complex database concepts to both technical and non-technical audiences.Located in North America with the ability to work core hours that overlap with the team.
Preferred Qualifications
Experience supporting PostgreSQL on AWS RDS, Aurora Postgres, Azure Database for PostgreSQL, or Google Cloud SQL.Scripting or automation experience in Python, PowerShell, or similar.Familiarity with monitoring/observability tooling (Datadog, New Relic, Prometheus, pganalyze, Sentry).Experience working in a customer-facing or customer-support-adjacent role.Exposure to additional database platforms (Oracle, SQL Server, MySQL, MongoDB) and migration experience to/from Postgres.Experience with infrastructure-as-code (Terraform, CloudFormation) and containerized workloads (Kubernetes).
What Success Looks Like
In the first 90 days, the successful candidate will have ramped up on our product and support workflows, taken ownership of escalated Postgres cases, and begun contributing to internal documentation and knowledge sharing. Within six months, they will be the go-to Postgres resource for the team, materially reducing time-to-resolution on database-related customer issues and partnering with engineering on product improvements informed by field data.
Centric Software provides equal employment opportunities to all qualified applicants without regard to race, sex, sexual orientation, gender identity, national origin, color, age, religion, protected veteran or disability status or genetic information.
#J-18808-Ljbffr
Centric Software® is a global leader, providing an innovative and AI-enabled product-concept-to-commercialization platform for retailers, brands and manufacturers of all sizes. We equip retail, fashion, luxury, footwear, outdoor, home and consumer goods brands with pioneering best-of-breed solutionsto plan, design, develop, source, comply, buy, make, price, allocate, sell and replenish products. Our technology powers brands to streamline processes, drive efficiency and operate with confidence in an ever-changing market.About Centric Software
Centric Software® is a global leader, providing an innovative and AI-enabled product-concept-to-commercialization platform for retailers, brands and manufacturers of all sizes. We equip retail, fashion, luxury, footwear, outdoor, home and consumer goods brands with pioneering best-of-breed solutionsto plan, design, develop, source, comply, buy, make, price, allocate, sell and replenish products. Our technology powers brands to streamline processes, drive efficiency and operate with confidence in an ever-changing market.
Our story is one of rapid growth, bold ideas and extraordinary opportunities. We’re here to challenge the status quo—and we’re looking for brilliant people who want to do the same. No matter where you are in the world, this is your chance to be part of something exceptional.
Position Summary
We are seeking a PostgreSQL expert to join our R&D Customer Support team as a Production DBA. This role is focused on bringing deep Postgres expertise in-house to analyze, troubleshoot, and improve production database environments, perform root cause analysis on issues ranging from long-running queries to hosting environment problems and heavy traffic scenarios, and ensure our customers’ PostgreSQL deployments remain healthy, performant, and reliable. While the primary focus is production operations, the DBA will also work across development environments as needed to trace issues to their source and collaborate with engineering on fixes.
Position Details
Job title:
PostgreSQL Database Administrator (Production DBA)
Team:
R&D – Customer Support
Location:
Remote (US/Canada)
Employment Type:
Full-time
Compensation:
$136K USD
Key Responsibilities
Serve as the PostgreSQL expert and primary Production DBA within the R&D Customer Support team, driving the stability, performance, and reliability of customer-facing database environments.Perform root cause analysis (RCA) on production incidents spanning query performance, database configuration, infrastructure-level bottlenecks, and traffic/load conditions.Diagnose and resolve complex PostgreSQL performance, availability, and data-integrity issues, including query tuning, index strategy, vacuum/auto vacuum behavior, and lock contention.Troubleshoot and analyze production PostgreSQL systems across diverse hosting environments, ensuring performance, availability, and data integrity.Review execution plans, analyze slow queries, and recommend configuration, schema, or indexing changes to optimize production workloads.Support customers running PostgreSQL across on-premises, cloud (AWS RDS/Aurora, Azure, GCP), and self-managed deployments.Work across development and production environments to trace issues to their source and collaborate with engineering on fixes and product improvements.Advise on high-availability and disaster-recovery architectures including streaming replication, logical replication, failover, backup/restore (pg_basebackup, pgBackRest, WAL-G), and point-in-time recovery.Create and maintain internal knowledge-based articles, runbooks, and best-practice documentation for the support team.Mentor support engineers and developers on Postgres internals, SQL tuning, and operational best practices.Participate in on-call rotation for critical customer escalations as needed.
Required Qualifications
Minimum 5 years of hands-on experience as a PostgreSQL DBA, with deep knowledge of Postgres internals (MVCC, WAL, query planner, locking, buffer management) and operational best practices.Proven track record managing PostgreSQL in production environments, including incident response, root cause analysis, and performance optimization under heavy traffic.Strong SQL skills, including query optimization and execution-plan analysis (EXPLAIN / EXPLAIN ANALYZE).Experience with PostgreSQL performance tuning: indexing strategies, autovacuum, connection pooling (PgBouncer), and configuration tuning (postgresql.Conf).Experience with high availability and replication: streaming replication, logical replication, Patroni, or equivalent.Experience with backup and recovery tooling such as pgBackRest, WAL-G, pg_basebackup, or Barman.Proficiency with Linux/Unix operating systems and shell scripting (Bash or similar).Strong written and verbal communication skills, with the ability to explain complex database concepts to both technical and non-technical audiences.Located in North America with the ability to work core hours that overlap with the team.
Preferred Qualifications
Experience supporting PostgreSQL on AWS RDS, Aurora Postgres, Azure Database for PostgreSQL, or Google Cloud SQL.Scripting or automation experience in Python, PowerShell, or similar.Familiarity with monitoring/observability tooling (Datadog, New Relic, Prometheus, pganalyze, Sentry).Experience working in a customer-facing or customer-support-adjacent role.Exposure to additional database platforms (Oracle, SQL Server, MySQL, MongoDB) and migration experience to/from Postgres.Experience with infrastructure-as-code (Terraform, CloudFormation) and containerized workloads (Kubernetes).
What Success Looks Like
In the first 90 days, the successful candidate will have ramped up on our product and support workflows, taken ownership of escalated Postgres cases, and begun contributing to internal documentation and knowledge sharing. Within six months, they will be the go-to Postgres resource for the team, materially reducing time-to-resolution on database-related customer issues and partnering with engineering on product improvements informed by field data.
Centric Software provides equal employment opportunities to all qualified applicants without regard to race, sex, sexual orientation, gender identity, national origin, color, age, religion, protected veteran or disability status or genetic information.
#J-18808-Ljbffr
Vacancy posted 2 hours ago
Similar jobs that could be interesting for youBased on the Postgresql Database Administrator in Winnipeg, MB vacancy
- Are you a PostgreSQL DBA who enjoys solving complex performance problems, improving database reliability, and working with systems that support... ...a PostgreSQL Database Administrator to join our Global... ...of PostgreSQL architecture, administration, and troubleshooting.Experience...PostgreSQLFull timeWork at office
- Production PostgreSQL expertise meets remote work across the US and Canada, focused on performance, availability... ...deployments. Analyze incidents and improve database operations.Centric Software seeks a PostgreSQL Database Administrator for its R&D Customer Support team. The...PostgreSQLRemote work
- PostgreSQL clustering expertise defines this Database Administrator position, focused on enterprise environments, failover handling, and node recovery. Cloud migration... ...clustering, cloud migration, and recovery expertise to enterprise database administration. #J-18808-LjbffrPostgreSQL
- Required Skills & Qualifications Proven experience as a PostgreSQL Database Administrator in enterprise environments.Strong knowledge of PostgreSQL architecture, including:Hands-on experience with RepMgr clustering, failover handling, and node recovery.Working knowledge...PostgreSQL
- Become a PostgreSQL Database Expert with Centric Software, focusing on performance and reliability in a remote setting. Bring your expertise to enhance our customer support strategies. As a Production DBA, you will join the R&D team to analyze and resolve complex database...PostgreSQLRemote work
- ...présentement à la recherche d'un(e) administrateur(trice) de bases de données PostgreSQL pour intervenir dans un contexte d'administration, d'optimisation, d'exploitation et d'évolution... ...de donnéesUne expérience avec Azure Database for PostgreSQL ou des pipelines CI/CD...PostgreSQLHourly payContract workApprenticeshipRemote workFlexible hours
- ...English Version will follow) Administrateur(trice) de bases de données (... ...une solide expérience avec PostgreSQL à notre équipe CloudOps en... ...données Installer, configurer, administrer et maintenir des bases de... ...Visitez notre site Web : Database Administrator (Intermediate)...PostgreSQLDaily paidWork at officeWorldwide
- ...37.5 hrs Job OverviewWe are looking for a Database Administrator Specialist with expertise in Oracle GoldenGate and... ...experience in Oracle GoldenGate or Azure Cloud database administration. 2+ years of experience with PostgreSQL. Strong skills in database setup,...PostgreSQLPermanent employmentContract workWork at office
- ...seeking a skilled and detail-oriented Database Administrator (DBA) to join our IT team. As a... ...professional experience in database administration, with a proven track record of managing... ...database management systems such as MySQL, PostgreSQL, Oracle, or Microsoft SQL Server....PostgreSQLFull timeFlexible hours
$70 - $78 per hour
...Complying with CIBC standards for change control and overall database security policies Analysing recurring incidents and identifying... ...in Azure Cloud database (Focus on MSSQL) ~ Experience with PostgreSQL – 2+ years ~ Setup/Installation and configuration of DB products...PostgreSQL- ...ServiceNow in Canada is seeking a Senior SWAT software engineer to own production database troubleshooting, platform performance, and multi-tenant scale. You will work on PostgreSQL/MariaDB fleets, implement observability, and drive automation to prevent incidents in a fast...PostgreSQL
$45 - $75 per hour
...client is looking to contract a Senior Database Administrator to join their team to work on several... ...and perform ongoing system administration tasks: release new versions; database... ...experience with open-source databases such as PostgreSQL, MySQL, MariaDB, CosmosDB, etc....PostgreSQLHourly payLong term contractContract workRemote work- Responsibilities Creates physical database designs and operates and administers the database... ...and practices Experience in Database Administration, Maintenance OptimizationAdditional... ...) such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2 Experience managing...PostgreSQL
- Senior Database Administrator (Oracle Application DBA / Cloud) We are seeking an experienced Senior... ..., including Amazon RDS (Oracle/PostgreSQL) and Amazon Aurora. PostgreSQL: Hands... ...Experience with Oracle Exadata administration and performance tuning features (Smart...PostgreSQLInternshipManual labor
- ...Assistance ProgramRole overview The Senior Database Administrator is responsible for the operational... ...professional experience in database administration, database engineering, or database... ...as Microsoft SQL Server, Oracle, PostgreSQL, or equivalent, with the ability to work...PostgreSQLFlexible hours
- Database Administrator - Senior:On behalf of our Government Sector client, Procom is searching for a Database Administrator - Senior for a 6-month... ...management systems such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2• Oversee cloud-hosted and hybrid databases...PostgreSQLContract workWork at office
- ...fiabilité optimale de nos systèmes, nous recherchons un(e) Administrateur(trice) de base de données PostgreSQL. Dans ce rôle, tu agiras comme le pilier technique... ...~10 ans et plus d'expérience professionnelle en administration de bases de données, avec expertise approfondie de...PostgreSQLDaily paidPermanent employmentFull timeWork at officeRemote workMonday to fridayDay shift
- .... Position SummaryWe are seeking a Senior Database Administrator (DBA) with deep, hands-on expertise across PostgreSQL, MongoDB, and Databricks to own the health, performance... .... The primary focus of this role is administration and platform engineering: configuring,...PostgreSQL
- Position Title - RQ11860 - Senior Database Administrator Location: Toronto, ON Mode: Contract... ...as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2, along with hands... ...standards.Develop and automate database administration activities using SQL, PL/SQL, T-SQL,...PostgreSQLContract work
- Job DescriptionOn behalf of our public sector client, Affinity is seeking a Database Administrator to be engaged for a one-year term, with a possible one-year extension, to provide day-to-day operational support for the organization’s SQL Server database environments and business...Long term contract
- ...for providing highly specialized senior level technical expertise, oversight and support in the project implementation and administration of FSRA database systems to ensure all business operations are fully supported in the areas of design, setup, configuration, performance,...Long term contract
- Join to apply for the Database Administrator role at AlcumusJoin to apply for the Database Administrator role at AlcumusGet AI‑powered advice on this job evidence of–…As a crucial part of the Veriforce Data Function that is responsible for management of Ver...Remote work
- Job SummaryWe are seeking a Database Administrator to design, secure, maintain, and optimize enterprise databases used to store and manage critical... .... The role will support database planning, development, administration, security, backup, and maintenance across enterprise...
- Azure SQL database administration leads this contract role, emphasizing production incident resolution, query tuning, and secure database operations... ...SQL Server. The work includes Oracle, SQL Server, and PostgreSQL administration, plus cloud migration activities. The assignment...PostgreSQLContract work
- ...learn and discover your way forward. Within our team, you will play a key role in the stability, performance, and evolution of our database environments. You will be responsible for the maintenance, operation, and ongoing support of production databases hosted within our...Long term contractPermanent employmentFixed term contractInternshipRemote workWork visaFlexible hours
$90k - $120k per year
...Sustainability Index and the FTSE4Good Emerging Index. Required skill set Install, configure, and maintain Oracle, MySQL, and Greenplum database environments. Perform database upgrades, patching, and performance tuning to ensure optimal efficiency. Manage backup and...$80 - $95 per hour
...to 8.63, applying cumulative PUM images, and migrating Oracle Database 19c to 26ai on Oracle Cloud Infrastructure (OCI), in partnership... ...with resume screening, candidate matching, and recruitment administration. All hiring decisions are ultimately made by our recruitment and...Hourly payContract workRemote work- Devenez Administrateur(trice) de bases de données intermédiaire en PostgreSQL chez Explorance, une entreprise fiable à Montréal. Ce poste exige des compétences en gestion... ...jouerez un rôle clé dans l'implémentation, l'administration et le dépannage des bases de données. Nous...PostgreSQL
$96k - $113k per year
...Reposting to the Supervisor, Business Intelligence, the Senior Administrator, Database, will provide hands-on leadership and technical expertise... ...and safety programs and policies Provide senior-level administration and troubleshooting for business-critical SQL Server environments...Permanent employment- ...Responsibilities: Perform Core SQL DBA tasks. Configure and maintain database servers and processes Handle Database upgrades and... ...experience as a SQL Server DBA. Experience with SQL Server Administration experience required Experience with Performance Tuning and...Remote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Postgresql Database Administrator. Be the first to apply!

