Role : DB2 Admin (Production Support)

Location : Montreal (Hybrid)

Type : Full Time

Skills :

DB2 LUW(Linux, Unix and Windows) DBA/ Database administration and Production support

Job description-

• Production support of the large production and non-production databases (including DPF) along with monitoring, performance tuning, and maintenance.

• provide critical support services including database design, processing developers' requests for database maintenance and migrations, application performance, troubleshooting, disaster recovery, and scheduled database maintenance in addition to Production support.

• Responsible for the design and implementation of the physical data model and the creation of all the relevant database objects and deployments of those objects from development to QA and production as well as ensuring data security, availability, and integrity

• Design, setup, installation, and upgrade of DB2 multipartition DPF large-sized databases

• Data migration of large-size databases

• Setup and maintenance of HADR and SQL and Q Replication

• Responsible for monitoring and optimizing the performance of the database and performing query optimizations.