This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Part-time job opportunities in English for the people in Montreal

To post a job, login or create an account |  Post a Job

   montreal part-time jobs   

Bringing new part-time opportunities every day!

previous arrow
next arrow

Tata Consultancy Services: Netezza & Postgres Sql Administrator

Tata Consultancy Services

This is a Full-time position in Montreal, QC posted February 17, 2021.

Job Type :Full-TimeJob role :Netezza & Postgres SQL AdministratorExperience level: Mid Senior levelResponsibilities:Must have skills* Install, configure and manage PostgreSQL & Netezza Abilityto independently monitor and administered databases Creation & managing PostgreSQL, Netezza 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 discussionsKey responsibilities* Proficient in managing large Netezza, PostgreSQL Database environment.

Good Problem solving, organizational, interpersonal & communicational skills.

Communicate regularly with technical support, applications & operational staff to ensure database integrity & security.

Performed Database administrative maintenance, monitoring on Netezza, PostgreSQL database systems in global 24*7 operational environments.

Perform capacity planning required to create and maintain database environments.

Perform Database recovery and create/write Disaster recovery plan.

Good knowledge on Unix/Windows server Operating systems