PostgreSQL with Ansible

3 weeks 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 DBA

    12 hours ago

    Montréal, QC, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed...

  • PostgreSQL DBA

    7 hours ago

    Montréal, QC, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed...

  • DevOps

    1 month ago

    Montréal, Canada Inc. Full time

    You will play a critical role in our It department. As a DevOps you will be part of an You will contribute to complex and diverse initiatives though building automatte4d solutions-Including robotic process automation, automating orchestrated jobs, and enhancing other integrations for file transfers, back-end database updates through frontend (vice versa).In...

  • Application Support Specialist

    1 week 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...

  • Application Consultant

    1 month ago

    Montréal, Canada ARO Inc Full time

    *Hybrid: Remote/Office *Location: Montreal, Quebec *Part-Time (annual contract) - Contract to be refreshed every year In addition to above, below is needed for the role: - **The How**_**: This is how you do things!** - Assesses impact of design decisions to the computer solution/product/service being developed (i.e. performance, schedule, budget,...

  • Developpeur full stack Java

    12 hours ago

    Montréal, QC, Canada Lexum Full time

    OrganisationLexum informatique juridique inc. (« Lexum ») développe des outils d’information juridique parmi les plus rapides et les plus appréciés. Le site web de CanLII – une réalisation de Lexum – est identifié par la quasi-totalité des avocats canadiens comme la ressource la plus commode pour trouver l’information juridique. Les...

  • Developpeur full stack Java

    7 hours ago

    Montréal, QC, Canada Lexum Full time

    OrganisationLexum informatique juridique inc. (« Lexum ») développe des outils d’information juridique parmi les plus rapides et les plus appréciés. Le site web de CanLII – une réalisation de Lexum – est identifié par la quasi-totalité des avocats canadiens comme la ressource la plus commode pour trouver l’information juridique. Les...

  • Developpeur full stack Java

    2 days ago

    Montréal, Canada Lexum Full time

    OrganisationLexum informatique juridique inc. (« Lexum ») développe des outils d’information juridique parmi les plus rapides et les plus appréciés. Le site web de CanLII – une réalisation de Lexum – est identifié par la quasi-totalité des avocats canadiens comme la ressource la plus commode pour trouver l’information juridique. Les...

  • Developpeur full stack Java

    7 hours ago

    Montréal, QC, Canada Lexum Full time

    Organisation Lexum informatique juridique inc. (« Lexum ») développe des outils d’information juridique parmi les plus rapides et les plus appréciés. Le site web de CanLII – une réalisation de Lexum – est identifié par la quasi-totalité des avocats canadiens comme la ressource la plus commode pour trouver l’information juridique. Les...