PostgreSQL with Ansible

6 months ago

Montréal, Canada Atlantis IT group Full time

**JD**:
**Role
- **PostgreSQL with Ansible**

**Location-**Montreal, QC (Hybrid)**

**Duration
- **Fulltime**

Skills and Responsibilities:
Experience in Installing, configuring, performance tuning & troubleshooting PostgreSQL Databases. Have strong experience on configuring & troubleshooting of primary/replica configurations in clustered & non clustered environment.

Main Accountabilities/Responsibilities:
Install, configure and manage PostgreSql.

Ability to independently monitor and administered databases.

Creation & managing PostgresSQL, DB objects & user, roles and groups.

Index management, Partitioning and system catalogues.

Performance tuning, query tuning by generating and explaining SQL plans for SQL queries.

Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.

Knowledge on High Availability, streaming replication, Replication failover, repmgr.

Expert with setting up and troubleshoot replication issues.

Monitoring Alert log, scheduled jobs & troubleshooting database problems.

Hands on maintenance activities such as vacuum, vacuum full, analyze the databases.

Analyze, recommend and implement configuration for Optimized performance.

Analyze to plan hardware capacity requirements for storage, memory & CPU Cycles.

Contribute to document company database standards, guidelines and operational procedures.

Should participate in Major incident management calls

Front end customers on technical discussions

Other skills required:
Understand and deploy Ansible Playbooks

Skills in a Linux environment
- ssh, Kerberos, TLS
- memory management
- filesystems

Python
- Read/update existing code.
- Manage virtual environment.

Nice to have:
Working knowledge of ServiceNow

"

Thanks & regards,

Jack

**Apptoza Inc.**

Phone: (678)-869-5418 Ext 5003

  • PostgreSQL with Ansible @ Montreal, Qc

    7 months ago

    Montréal, Canada Atlantis IT group Full time

    **Role PostgreSQL with Ansible** **Location Montreal, QC** **Duration Long Term** Job Summary/ Purpose: Experience in Installing, configuring, performance tuning & troubleshooting PostgreSQL Databases. Have strong experience on configuring & troubleshooting of primary/replica configurations in clustered & non clustered environment. Main...

  • Postgres Dba

    3 months ago

    Montréal, QC, Canada virtusa Full time

    **Role: Postgres DBA** **Location: Remote/Canada** **Duration: 6-12+ Months** - We are seeking an experienced **Database Administrator (DBA) with Site Reliability Engineering (SRE)** skills to join our DevOps team. - You will work closely with our development and operations teams to ensure seamless database performance, scalability, and...

  • Database Administrator

    3 weeks ago

    Montréal, QC, Canada Squarepoint Capital Full time

    Department: Application Engineering Position Overview: Platform Applications Specialists Database role will be part of a global systems team responsible to deliver highly available, high-performance, and scalable infrastructure to support trading and research using the DevOps methodology. As part of this role will be focused on working...

  • Administrateur de Bases de Données

    7 months ago

    Montréal, Canada Paysafe Full time

    **À propos de Paysafe** Êtes-vous prêt à avoir un impact? Joignez-vous à notre équipe inspirée par une vision unifiée et propulsée par la passion. Nous sommes à la recherche d'un **administrateur de base de données** pour rejoindre notre équipe de solutions de base de données. Il s'agit d'un poste contractuel d'une durée d'un (1) an basé à...

  • Enterprise Database Administrator

    3 weeks ago

    Montréal, QC, Canada Hunter Bond Full time

    Job Title: Database Systems Administrator Client: Elite Tech Firm Salary: Up to $125k CAD + Huge Bonus Location: Montreal Sells: Cutting-edge tech, ownership of multiple greenfield projects, no red tape, a friendly/collaborative environment, beautiful offices, personal projects on Fridays! An Elite FinTech Firm is looking for highly...

  • Database Administrator

    3 weeks ago

    Montréal, QC, Canada Squarepoint Capital Full time

    Department: Application Engineering Position Overview: Platform Applications Specialists Database role will be part of a global systems team responsible to deliver highly available, high-performance, and scalable infrastructure to support trading and research using the DevOps methodology. As part of this role will be focused on working collaboratively...

  • Application Support Specialist

    7 months ago

    Montréal, Canada Pointus Partners Full time

    **Pointus Partners is a privately held Canadian-based proprietary trading firm located in Montreal. Our core principles are innovation, collaboration, and communication. We think critically, share ideas, and solve problems as a team. We embrace the entrepreneurial spirit, promote work-life balance, and maintain a flat organizational structure in an open...

  • Cloud Operations

    6 months ago

    Montréal, Canada SherWeb Full time

    Location: Work from anywhere_ **Here's how you will contribute to the company’s success.** Being part of the team at the core of Sherweb’s strategy, you will be delivering API integrations of products we resell as well as contributing to automate delivery of new technologies to support own developed products. You will have the opportunity to help shape...

  • Spécialiste en Ingénierie de Fiabilité Des Sites

    4 weeks ago

    Montréal, QC H1Y 3L1, Canada i3D.net Full time

    **Vos tâches**: - Concevoir, déployer, surveiller et maintenir des systèmes Linux au sein d’équipes de produits agiles; - Contribuer à l’évolution des groupes de produits en apportant de nouvelles idées et en proposant des améliorations; - Encadrer, soutenir et guider d’autres membres de l’équipe, et contribuer à l’amélioration des...