Oracle Database Administrator

Tata Consultancy Services; Dadri, Ghaziabad District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Tata Consultancy Services is seeking a Database Administrator with 4-8 years of experience to manage DB2 LUW and Oracle databases in Noida/Vaishali/Vasundhara. The role involves installation, maintenance, performance tuning, and collaboration with OS and development teams.

Candidate will handle migrations, DR planning, and utilization of DB2 utilities like db2pd/db2top to optimize database performance and reliability.

Qualifications

• DB2 LUW versions 10.1/10.5/11.1/11.5 experience
• Oracle Database knowledge required
• Strong relational and non-relational database concepts
• Basic Linux commands familiarity
• Certifications in Database Administration preferred

Responsibilities

• Install, setup, upgrade DB2 LUW on Linux/Windows servers
• Day-to-day DB2 administration, performance monitoring, patching
• Apply Fix Packs / APARs as needed
• Support DB2 PureScale cluster, HADR & HACMP
• Work with data movement utilities IMPORT, LOAD, EXPORT, db2pd, db2top
• Plan backups and DR replication strategies
• Migrate databases from Oracle to DB2 with minimal risk
• Collaborate with Linux/OpenShift/Windows/Backup teams
• Use db2advis and db2explain for performance tuning
• Handle incidents, problems and change requests
• Prepare and share reports for business/management

Skills

DB2 LUW

Oracle DBA

Linux basics

Windows basics

Enterprise experience

Job description

Role:

Database Administration

Required Technical Skill Set:

DB2 Database Administrations, Oracle DBA

Desired Experience Range:

4-8 Years

Location of Requirement:

Noida / Vaishali / Vasundhara

Desired Competencies (Technical/Behavioral Competency/Skills) :

• Certifications Any certification in Database Administrations
• Experience in implementing enterprise-wide
• DB2 LUW Version 10.1/10.5/11.1/11.
• Strong knowledge of relational & non rational database, Database Administration, Data Integrations, Oracle Database, Basic Linux commands

Responsibility of / Expectations from the Role:

• 1. Install, setup, upgrade, DB2 LUW 10.1/10.5/11.1/11.5 on Linux and windows-based DB servers.
• 2. Day-to-day Database Administration, Performance monitoring and Patching of Production Database servers.
• 3. Apply Fix Packs / special builds to comply with any APAR etc
• 4. Supporting DB2 pure Scale cluster, HADR & HACMP
• 5. Working with data movement utilities IMPORT, LOAD, EXPORT and db2pd, db2top as required.
• 6. Planning Backup, replication to DR sites and Restore Strategies for all database servers
• 7. Database Migration from Oracle to DB2 efficiently without any loss
• 8. Collaboration with OS teams such as Linux,/OpenShift, Windows, Backup, Application development team.
• 9. Working with db2advis & db2expln utilities for query performance improvement
• 10. Resolution of incidents, problem & Change Management
• 11. Creation and submission of various reports regular & on demand by the business partners and management