DB2 DBA

TATA Consulting Services-posted about 1 month ago

$90,000 - $120,000/Yr

Full-time • Mid Level

Framingham, MA

5,001-10,000 employees

Professional, Scientific, and Technical Services

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

The ideal candidate will be responsible for the installation, configuration, performance tuning, backup/recovery, and troubleshooting of DB2 databases across various versions (including 10.5, 11.1, 11.5, 12 etc). The candidate should have experience working in high-availability environments and demonstrate strong skills in automation, security, and compliance.

Perform periodic maintenance
Monitor database performance and perform proactive tuning.
Implement and manage robust backup and recovery procedures, including RTO (Recovery Time Objective) and RPO (Recovery Point Objective) consideration, while supporting data replication and migration between different DB2 environments.
Define and implement best practices and automation initiatives.
Lead database migration projects (on-prem to cloud / version upgrades).

8 years of experience as a DB2 Database Administrator.
In-depth knowledge of db2 database versions 10.5, 11.1, 11.5, 12 etc.
Strong knowledge of IBM DB2 LUW and/or DB2 z/OS database platforms.
Database Administration - DB2 LUW Support critical production environment.
Familiarity with monitoring tools like db2top, IBM Data Server Manager.
Hands-on experience in performance tuning and query optimization.
Experience with DB2 commands: - Stop/Start Databases, Display command, Cancel thread and Term & Display utility, others.
Hands on experience on DB2 utilities: Reorg and Runstat, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities.
Ability to bind/rebind the Plans/Packages and Granting required accesses to Packages/Plans/Collections.
Experience in Database replication - IBM DB2 Data Propagator.
DB2 administration - Strong Troubleshooting skills.
Must have performed Db2 migration
Addition and removal of hosts from the cluster manager and shared file system.
Good communication skills with both technical and management teams

Experience with remote installation and configuration of the Db2 pure scale feature.
Knowledge of Oracle, PostgreSQL or MySQL DB administration.
Experience in database security auditing and compliance.
Familiarity with Ansible or Terraform tools for database deployment automation.
Cloud certifications (e.g., AWS, Azure) are a strong plus.
Familiarity with ITIL processes and change management procedures.

Disc retionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Ma ternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commute r Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Track Jobs with Teal

Job Search Resources

•

AI Resume Builder

•

SQL DBA Resume Examples

•

Cover Letter Examples

DB2 DBA

Job Search Resources

Tools

Career Hubs

Guides

Company