PostgreSQL DBA
Astra North Infoteck Inc.
PostgreSQL DBA PostgreSQL Administration Performance Tuning & High Availability
Toronto ON
Work Model: Hybrid (4 days a week in office)
Required Skills
PostgreSQL Database Administration
PostgreSQL Architecture
Performance Tuning & Query Optimization
High Availability & Clustering
Backup & Recovery
Role Description
Database Administration
Install configure and maintain PostgreSQL databases in production and non-production environments.
Perform database refresh activities between environments.
Execute database patching and upgrade activities.
Architecture & Performance
Manage PostgreSQL architecture including memory management indexing and query optimization.
Analyze query execution plans and perform performance tuning.
High Availability & Clustering
Implement and manage repmgr clustering for high availability and failover.
Troubleshoot and resolve cluster node failures.
Migration & Cloud Integration
Design and execute database migration strategies from on-premises to cloud environments.
Experience with Google Cloud Platform (GCP) or Microsoft Azure is an asset.
Backup & Recovery
Implement database backup recovery and disaster recovery procedures.
Configure logical and physical backup strategies using native PostgreSQL tools and third-party solutions.
Replication
Configure and manage logical and streaming replication across environments.
Required Qualifications
Proven experience as a PostgreSQL Database Administrator in enterprise environments.
Strong knowledge of PostgreSQL architecture including WAL MVCC and Vacuum processes.
Hands-on experience with repmgr clustering failover handling and node recovery.
Expertise in performance tuning query optimization and troubleshooting.
Experience with migration strategies from on-premises to cloud platforms.
Familiarity with Oracle DBA RMAN GoldenGate and Exadata.
Proficiency in backup recovery and disaster recovery planning.
Working knowledge of logical and streaming replication.
Excellent problem-solving and communication skills.
Preferred Qualifications
Experience with Ansible and Terraform.
Knowledge of pgAdmin Prometheus or Grafana.
Scripting experience with Shell Python or similar languages.
Required Skills:
Top 3 Required Skills: 1. IBM Financial transaction 2. Payment flow 3. Support Modernization Detailed Job Description: Design develop and maintain applications built on IBM Financial Transaction Manager (FTM) to support core payments processing. Contribute to the development of payment flows supporting transaction processing. Build and support integrations between FTM and upstream/downstream systems using enterprise integration patterns. Participate in the design development testing deployment and production support. Troubleshoot and resolve application and integration issues in a complex regulated environment. Collaborate with architecture QA and operations teams to ensure platform stability scalability and performance. Support modernization initiatives and enhancements to existing payment hub capabilities. Produce clear technical documentation and participate in code reviews and knowledge sharing.
- ...PostgreSQL Database Administrator – PostgreSQL, Clustering & Cloud Migration Required Skills & Qualifications PostgreSQL Administration... ...• Disaster recovery planning • Familiarity with Oracle DBA technologies, including: • RMAN • GoldenGate • Exadata...PostgreSQLPermanent employment
- ...TEHORA est présentement à la recherche d’ un(e) ingénieur(e) de bases de données ayant une expérience approfondie avec PostgreSQL, PostGIS et les modèles orientés séries temporelles. La personne retenue aura pour mission de concevoir, optimiser et sécuriser la couche de données...PostgreSQLHourly payFull timeContract workApprenticeshipRemote workFlexible hours
- ...TEHORA est présentement à la recherche d’un(e) administrateur(trice) de bases de données (DBA) senior Sans être exhaustifs, voici les services et livrables que devra fournir la personne retenue : Administrer les bases de données; Assurer la performance et la sécurité...SuggestedHourly payFull timeContract workApprenticeshipRemote workFlexible hours
- ...Job Summary We are looking for an experienced Senior PostgreSQL System Administrator with 5–7 years of hands-on experience managing large... ...access control, auditing, and encryption Automate routine DBA tasks using Shell scripting, Ansible , or similar tools Collaborate...PostgreSQLContract work
- ...TEHORA est présentement à la recherche d’un(e) administrateur(trice) de bases de données (DBA) intermédiaire Sans être exhaustifs, voici les services et livrables que devra fournir la personne retenue : Participer à l’administration des bases; Diagnostiquer les incidents...SuggestedHourly payFull timeContract workApprenticeshipRemote workFlexible hours
- ...Job Description: Full Stack Developer (TypeScript PostgreSQL AWS) Toronto ON - Hybrid (4 Days WFO) 12 months Design develop and maintain scalable full-stack applications using TypeScript. Build and consume RESTful APIs and microservices for enterprise-grade...PostgreSQLFull time
- ...Role: AWS Cloud RDS/Oracle DBA Position Type: Permanent Total Experience: 6-8 years Role Description: • We are looking for... ...an AWS-focused DBA to manage and optimize Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift clusters, with a strong focus on Infrastructure...PostgreSQLPermanent employmentContract work
$153k - $197k per year
...teams ~ Ability to manage priorities and deliver in a fast-paced environment Bonus Points For Experience leading or mentoring DBA teams Exposure to modernization or migration programs Familiarity with financial services environments Knowledge of automation...Work at officeImmediate start- ...Best Job Title: PeopleSoft HRMS Upgrade Specialist / PeopleSoft Administrator (PeopleTools & Oracle DBA) Location: Toronto, ON Work Model: Hybrid (4 Days Work From Office) Experience Required: 8–10 Years Primary Skill • Oracle PeopleSoft Technical...Contract workWork at office
$85.56 - $91.94 per hour
...Full-Stack Data Scope: Combine senior-tier database administration (DBA) infrastructure control with advanced data modeling and data... ...Programming Fluency: Extensive hands-on experience working with Oracle and PostgreSQL databases, writing advanced PL/SQL and PL/pgSQL, executing Linux...PostgreSQLLong term contractContract workManual laborWork at office3 days per week$37 per hour
1000338375 Ontario Inc. (dba Ohiru Cafe) is seeking a Restaurant Manager. Full-time, permanent; $37.00 per hour; 30-44 hours per week. Standard 6–8-hour shifts for this position could be scheduled anytime between 8am and 5pm. Duties: · Oversee the day-to-...Hourly payPermanent employmentFull timeShift work- We are seeking a proactive and skilled Database Administrator (DBA) to join an enterprise Data Warehouse Technology group within Information Technology. In this mid-level hands-on contract role, you will work closely alongside our senior DBA to provide operational database...Long term contractContract work
$110k per year
...business environment. You have: The academic credentials. You hold a terminal degree in a relevant business discipline (such as a DBA, DM, or PhD) and have the expertise required to teach at the graduate level. You bring current knowledge of your field and are...Permanent employmentFull timeWork at officeFlexible hours3 days per week$65k - $85k per year
...and monitoring of all quality and construction processes, procedures, activities, and project deliverables are in accordance with the DBA and ISO 9001:2015 The Arctic Over the Horizon Radar Project is a major federal initiative led by Canada’s Department of National Defence...For subcontractorLocal area$78.62 - $89.34 per hour
...Qualifications Experience: Extensive professional experience in database engineering, platform automation, or database administration (DBA) supporting mission-critical, enterprise-scale application layers. Database Platform Mastery: Deep, hands-on command of Microsoft...Long term contractPermanent employmentFull timeContract workWork at office- ...environments. Provide technical support coordination and working closely with Development, QA, DevOps, Cloud Operations, Infrastructure, DBA, and Customer Success teams. Manage customer-facing escalations and driving them to resolution while ensuring timely communication...Remote work
- ...expect the Director to bring together and lead Site Reliability Engineering (SRE), DevOps, CloudOps, Security, and Database Administration (DBA) functions into a unified production operations organization, while also owning key external partner relationships, including managed...Full timeRemote workFlexible hours
$75.6 - $90.72 per hour
...170 business days) - possible extension Remote - Anywhere in Ontario Must Have: ~10+ years of hands-on experience as a DBA ~ Experience with database optimization, capacity planning, installation and migration, database design, performance tuning, backup and...Contract workRemote work- ...Python). You might not be expert, but we still expect you to try and learn to get the job done ~ Relational database experience (PostgreSQL preferred) ~ Working knowledge of Unix and a solid infrastructure understanding ~ Experience designing/consuming APIs (e.g.,...PostgreSQLFlexible hours
- ...assurer la cohérence de l’architecture. Concevoir, implémenter et maintenir des bases de données relationnelles (Oracle, SQL Server, PostgreSQL) ; Optimiser les requêtes et performances des bases de données ; Assurer la sauvegarde, restauration et récupération des...PostgreSQLHourly payFull timeContract workApprenticeshipRemote workFlexible hours
$150k - $170k per year
...not only a people manager, but also a hands-on engineering leader who can operate across C#.NET, Angular, React, Python, SQL Server, PostgreSQL, MongoDB, Azure Infrastructure, Google Cloud Platform, Azure DevOps Pipelines, and modern software delivery practices. Key...PostgreSQLLong term contractFull timeInternshipWork at officeImmediate startRemote workFlexible hours- ...at least 2 programming languages (Java 21 or JavaScript) and handling multi-thread applications Relational database experience (PostgreSQL preferred) Working knowledge of Unix and a solid infrastructure understanding Experience designing/consuming APIs (e.g., REST)...PostgreSQLFlexible hours
$105k - $125k per year
...building REST APIs, ideally with FastAPI, Flask, or Django ~ Strong relational database skills, including schema design and SQL (PostgreSQL or similar) ~ Experience with ORMs and data modeling ~ Ability to translate requirements into robust, production-ready backend systems...PostgreSQLLong term contractFull timeInternshipWork at officeLocal areaImmediate startRemote workFlexible hours- ...development and data architecture experience combined. PostgreSQLSnowpro for Snowflake certifications preferred. Proficient with PostgreSQL Talend ETL and Snowflake. Proficient in the use of data modeling tools and producingmaintaining logical and physical designs....PostgreSQLPermanent employmentFull timeLocal area
- ...technologies équivalentes; Oracle; VMware; Git; Zabbix; ~ Bonne connaissance des environnements applicatifs suivants : Apache; PostgreSQL; MySQL; PHP; NGINX; ~ Bonne connaissance des services d'infrastructure : NFS; Kerberos; NTP; SMB; Syslog; Connaissance des...PostgreSQLHourly payFull timeContract workApprenticeshipRemote workFlexible hours
- ...Our Tech Stack - Languages: SQL, Python - Data orchestration and transformation: Airflow, dbt - Data storage and warehousing: PostgreSQL, Redshift, MongoDB (for unstructured data) - Machine learning and experimentation: AWS SageMaker - Visualization and reporting: Looker...PostgreSQL
$130k - $150k per year
...technical documentation. Data Strategy: Define and manage the overall data persistence strategy, covering relational databases (PostgreSQL), NoSQL solutions (MongoDB), and high-performance caching layers (Redis). Infrastructure & DevOps Collaboration: Partner with the...PostgreSQLLong term contractWork at office$105k - $125k per year
...as .NET, Python, or Node.js ~ Experience designing and consuming REST APIs ~ Working knowledge of relational databases and SQL (PostgreSQL or similar) ~ Working knowledge of TypeScript ~ Ability to translate product requirements and designs into production-ready features...PostgreSQLLong term contractFull timeInternshipWork at officeLocal areaImmediate startRemote workFlexible hours- ...communication skills. Preferred Skills Java, Kotlin, Go, Python, or Node.js React and TypeScript REST APIs and GraphQL PostgreSQL and Redis AWS cloud services Docker and Kubernetes Git and CI/CD tools such as GitHub Actions or CircleCI Microservices...PostgreSQLRemote workFlexible hours
- ...Database Appliance (ODA) ~ Oracle Enterprise Manager (OEM) ~ Strong experience supporting and optimizing Oracle, SQL Server, and PostgreSQL databases. ~ Experience implementing and supporting Oracle GoldenGate. ~ Advanced SQL and PL/SQL programming expertise. ~ Linux...PostgreSQLLong term contractPermanent employment
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to PostgreSQL DBA. Be the first to apply!
