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.
- ...Iris's Fortune 100 direct client is looking for DB2 DBA . Please find below Job description and share me your updated resume at ***email_hidden*** . Position: DB2 DBA Location: Toronto ON Key Responsibilities ~ Manage, maintain, and optimize enterprise database...SuggestedFor contractorsFlexible 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
- ...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...SuggestedWork at officeImmediate start- Key Technologies: · Python · PostgresSQL · RiskWatch · GCP · CI/CD · Django Key Responsibilities: · Understand current process flows, how the change would integrate into current systems. · Enhance and improve current designs while adding...PostgreSQLContract work
- ...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
$300k per year
...team that values patient care, health promotion, and community health advancements. Clinic Locations ~600 The East Mall, Etobicoke Employer Details 13753131 Canada Inc. DBA: Foundation Health 2841B 39 Street SW, Calgary, Alberta, T3E 3G8 #J-18808-LjbffrLong term contractFull timePart timeWork at officeImmediate startFlexible hours- ...comprehensive 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
- ...execution. Solid understanding of database testing, writing SQL queries, and validating data in relational databases (Oracle, MySQL, PostgreSQL, etc.). Excellent communication skills and effective negotiation skills. Qualifications 7+ years of experience in software...PostgreSQLContract workRemote workFlexible hours
- ...workflow automation — n8n belongs to Workflow Automation Engineer Not ML / AI engineering — model development belongs to AI team Not a DBA — no infrastructure provisioning or cluster management Our Values: We know our people are what allows us to achieve all that we...Full timeInternshipWork at officeRemote work1 day per week
- ...following How to set up and navigate a Ruby on Rails project (including writing specs). Basic knowledge of Databases (such as PostgreSQL, and MySQL). Knowledge of templating engines (for example, ERB, Smarty, Liquid, …). Basic knowledge of web security (XSS, SQL...PostgreSQLFull timeFor subcontractorWork at officeImmediate startFlexible hours
- ...Spring Integration context. Strong skills in SQL, and extensive experience working with relational databases, such as SQL Server, PostgreSQL, or Oracle, and non‑structured database such as MongoDB. Have knowledge on application security in Cloud environment, for example...PostgreSQLContract workMonday to friday
$82.6k - $132.6k per year
...scalability Create and manage cloud infrastructure using AWS CDK (TypeScript/Python), including services like ECS, API Gateway, RDS (PostgreSQL), S3, and EventBridge Build and maintain CI/CD pipelines using GitHub Actions to automate build, test, security scan, and...PostgreSQLFull timeWork at officeLocal areaShift work- ...standards: REST Health care data exchange standards: Fast Healthcare Interoperability Resources (FHIR), HAPI FHIR, SmileCDR Databases: PostgreSQL, relational, hierarchical and non‑relational (document‑oriented) databases Communication protocols: FTP, SFTP, TCP/IP Desired Skills...PostgreSQL
- ...operational needs in planning discussions Requirements: • Experience with AWS, Azure, or GCP cloud platforms • Familiarity with MySQL, PostgreSQL, and other databases • Proficient in Linux system hardening techniques • Knowledge of relevant auditing tools • Understanding of...PostgreSQL
- ...frameworks like Spring Boot and Celery. Your proficiency in machine learning projects using Python, as well as strong SQL skills with DB2 or PostgreSQL, will be invaluable. Collaborating with a team, you’ll develop APIs while enhancing your skills in front-end technologies and cloud...PostgreSQL
- ...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
$110k - $150k per year
...professional software development experience. Strong knowledge of modern development languages (Python, Go, or Rust). Proficient in PostgreSQL and SQL optimization. Experience using Docker, Infrastructure as Code, and deploying to cloud providers like AWS or Google Cloud....PostgreSQL- ...engineering practices Requirements Minimum 5 years of backend software engineering experience Proficiency in Kubernetes, AWS, and PostgreSQL Solid understanding of DevOps and quality engineering Ability to conceptualize distributed systems clearly Excellent written and...PostgreSQL
- ...implementing user-facing components. Ideal candidates will have 4-6 years of experience, strong skills in Node.js and TypeScript, as well as proficiency in React and PostgreSQL. The position offers equity in a high-growth start-up and a collaborative work environment. #J-18808-LjbffrPostgreSQLWork at office
- ...développement orienté objet et architecture MVC • Minimum de 3 ans d’expérience en développement web et d’API RESTful • Bonne connaissance de PostgreSQL et des types JSON / BSON pour la manipulation de données • Connaissance approfondie des principes SOLID, DRY et des design patterns...PostgreSQLRemote work
$84k - $175k per year
...Django 5.x and Django REST Framework, including middleware, custom permissions, migrations, and ASGI deployment. Experience with PostgreSQL, including schema design, query optimization, and multi-tenant architectures. Strong understanding of REST API design, OpenAPI/Swagger...PostgreSQLLong term contractPermanent employmentTemporary workFlexible hours- ...React 18, TypeScript Backend: Go (Golang) Tooling: Vite, SWC, Jest, ESLint, Prettier Styling: Sass, CSS Modules Database: PostgreSQL (Kysely) Infrastructure: AWS We prioritize performance, type safety, and developer experience across the stack. What We’re...PostgreSQLWork at office3 days per week
- ...security and architecture documentation objectives. Provides input in creating new and modifying existing database Co-ordinates with DBA and Capacity manager for regular application sanity check Highlight technical projects which need to be initiate Own the...Full timeFlexible hours
- ..., and implementation of platform and data solutions, as well as lead, mentor, and grow a team of talented platform, data engineers and DBA’s. This role requires strong platform engineering, data engineering skills and leadership, effective written and verbal communication skills...Long term contractFull timeLocal areaFlexible hours
$65k - $80k per year
...stakeholders ~ Ability to manage multiple priorities in a fast-paced environment Bonus Points: Experience with Snowflake, PostgreSQL, or Azure-based environments Experience with data pipeline tools (e.g., FiveTran) Exposure to Power Automate or workflow...PostgreSQLLong term contractFull timeFlexible hours$110k - $125k per year
...designing and supporting relational databases as a Database Engineer, Data Engineer, Database Developer, or similar role. ~ Strong PostgreSQL experience: performance tuning, indexing strategies, schema design, and database security. ~ Experience designing databases for...PostgreSQLPermanent employmentFull timeInternship$60k - $65k per year
...improve implementation quality and performance testing. Contribute hands-on development using Java, Spring Boot, Docker, Kubernetes, PostgreSQL, and related technologies. Continuous Improvement Improve onboarding experiences through enhanced processes, reusable assets,...PostgreSQLFull time$80k - $120k per year
...GitHub Copilot, Microsoft Copilot) and their practical application in daily coding ~ Working knowledge of relational databases (Oracle/PostgreSQL) and NoSQL databases (MongoDB/DynamoDB) from both storage and compute perspectives ~ Familiarity with RESTful API development and...PostgreSQLLong term contractTemporary workWork at officeImmediate start2 days per week- ...instance performance issues and Linux performance analysis on-prem and on Hyperscaler ~ Own complex incident RCA across multi-tenant PostgreSQL/MariaDB fleets at scale ~ Develop observability and automation to prevent recurrence of critical issues ~ Influence...PostgreSQLFull timeWork at officeRemote workFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to PostgreSQL DBA. Be the first to apply!
