DBA Lead

Overview

On Site
Depends on Experience
Full Time

Skills

DB2 LUW DBA
DB2 DPF Environment

Job Details

Job Title: DBA Lead
Location: Lansing,MI
JOB TYPE: Full Time
Remote/ Hybrid/ On-site: 100% On-site

DB2 LUW DBA

  • Good experience in 24*7 production environment support
  • db2 installations and fix pack upgrades, instance and database creation
  • DB2 11.5 Version Migration and upgrades from prior versions
  • HADR server build and TSA installation, failovers and rolling upgrades.
  • Hands on DB2 DPF Environment (BACKUP/RESTORE)
  • Create and schedule jobs, such as Backups, Runstats, 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, snapshots
  • Granting / revoking various authorizations to different Users/Groups
  • Analyzing SQL Queries by using db2advis and creating indexes based on requirement.
  • IBM CDC replication tool (Change data capture)
  • Having good knowledge on Shell scripting
  • Experience in Problem & change management process
  • Good in Communication and interpersonal skills
  • Encryption configuration setup for DB2 filesystems
  • Add on Skills: Sybase and PostgreSQL database administration, Oracle DB upgrade experience will be an added advantage.

The pay range for this role is $100,000 - $120,000 per annum including any bonuses or variable pay. Tech Mahindra also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience and location of the candidate.

Tech Mahindra is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at .

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Tech Mahindra (Americas) Inc.