← Back to jobs

Avance Consulting Logo
DBA Lead

Avance Consulting

 

Lansing, MI, United States

Posted On: 2 days ago
Experience: 5+ years
Availability: Hybrid
Openings: 2
Category: Oracle DBA Lead
Tenure: Full-time Only
Related Jobs

No related jobs found

Description

Lead the administration, maintenance, and performance optimization of mission-critical MongoDB and DB2 environments.

This role is on-site.

Responsibilities

  • Manage MongoDB installations, configurations, and administration across versions 3.4 through 6.0.
  • Oversee DB2 LUW installations, fix pack upgrades, instance creation, and version 11.5 migrations.
  • Ensure continuous availability of clusters through replication, HADR server builds, and TSA installation.
  • Execute data backup and recovery strategies using Mongo dump/restore and DB2 disk-based configurations.
  • Own incident, change, and problem management processes within a 24/7 production environment.

Required Skills

  • 5+ years of experience in database administration.
  • Expertise in MongoDB multi-sharded clusters, replica sets, and Ops Manager installation.
  • Hands-on experience with DB2 DPF environments, including backup/restore and tablespace monitoring.
  • Proficiency in MongoDB CRUD operations and complex aggregation queries for reporting.
  • Advanced indexing skills, including Single-Field, Compound, Unique, Multi-key, Text, and Hashed Sharding.
  • Deep knowledge of DB2 tools such as db2look, db2pd, db2move, db2diag, and db2dart.
  • Experience with IBM CDC (Change Data Capture) replication.
  • Strong SQL query tuning and optimization capabilities.
  • Proficiency in Shell scripting for database automation.

Preferred Skills

  • Experience with Sybase, PostgreSQL, or Oracle DB upgrades.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs