Logo
Saxon Global

Db2 DBA Consultant

Saxon Global, Lansing, Michigan, United States, 48900


Hello,

Hope you are doing well !

Let me know if you are interested in below position.

Position - DB2 LUW/UDB, MongoDB

Location - Lansing MI- Onsite

Duration - Fulltime Positions.

Experience in MongoDB Installation, configuration, and administration for very good large and complex databases in various MongoDB versions 3.4, 4.0, 4.4 and 6.0.Experience in designing MongoDB multi-sharded cluster and monitoring with Ops Manager.Hands on experience on Create, Read, Update and Delete (CRUD) Operation.Creating replica set (Arbiter, Priority, Hidden, Delayed nodes) & sharded clusters in MongoDB.Proficient in upgrading various versions of Mongo database on different platforms.Experience in managing multi-node MongoDB clusters.Created aggregation queries for reporting and analysis.Creation of Indexes (Single Field, Compound, Unique, Multi-key index, Text & Hashed Sharding indexes).Data Backup and recovery using Mongo dump, restore & Mongo export, import.Refresh MongoDB data from staging to production and vice versa.MQL Query tuning and optimization with appropriate index creation for effective processing.Responsible for administration, maintenance, Performance analysis, and Capacity planningEnsure the continuous availability of our mission critical MongoDB clusters using replication across data centers.Performance tuning and indexing strategies using mongo utilities like Mongo stat, and Mongo top.Installing OPS Manager for MongoDB.Good experience in 24*7 production environment supportdb2 installations and fix pack upgrades, instance and database creationDB2 11.5 Version Migration and upgrades from prior versionsHADR server build and TSA installation, failovers and rolling upgrades.Hands on DB2 DPF Environment (BACKUP/RESTORE)Create and schedule jobs, such as Backups, Runs tats, Reorgs and Table space monitoring etc.Extensive exposure to DB2 Tools (db2look, db2pd, db2move, Load, Export, and Import)Enabling the archive logging and configured database backups to Disk.Troubleshooting Databases issues using db2diag, db2dart, db2support, snapshotsGranting/revoking various authorizations to different Users/GroupsAnalyzing SQL Queries by using db2advis and creating indexes based on requirement.IBM CDC replication tool (Change data capture)Having good knowledge on Shell scriptingExperience in Problem & change management process.Good in Communication and interpersonal skillsEncryption configuration setup for DB2 filesystemsAdd on Skills: Sybase and PostgreSQL database administration, Oracle DB upgrade experience will be an added advantage.

Thanks & Regard

Roshan Singh

972 430 7053 Ext- 336

Mob - 209 448 4677

Saxon Global

Roshan.s@saxonglobal.com