DB2 DBA -Larsen & Toubro Infotech Ltd

Designation DB2 DBA

Job Description Extensive experience in DB2 Database Administration.
Certification in Database Technology.
Db2 server installation, database creation, alteration and setup.

Desired Profile • Schema Design Review, Physical Tablespace Layout
• DB2 Server Installation, Database Creation, Alteration, and Setup
• DB2 Server Database File Management
• DB2 Server Storage Segment Administration Including Table, Index, LOB, Rollback, and Temporary Segments
• DB2 Server Memory Segment Administration Including Library Cache, Data Dictionary Cache, Buffer Cache, Redo Log Buffer, and Java Pool
• DB2 Server Network Connectivity Management
• Database User Administration Including User Creation, Quota Assignment, Object-level Privilege Administration, Security Management, and Role
Creation
• Database Backup and Recovery Implementation and Management Including Instance Failover to Standby Server, Dataset Propagation, Incremental
Backups, Full Backups, Point-in-time/Point-of-failure Recovery, Logical Backups, Logical Recovery
• Logical to Physical Data Model Conversion
• Dimensional and Normalized Architecture Review
• Table Partitioning Scheme Generation and Implementation Including Range,
Hash, and Composite
• Parallel Query Tuning, Parallel Server Tuning
• Database Block Optimization
• Strong interpersonal skills and ability to work with all departments and levels within the organization.
• Highly organized and detail-oriented.
• Must possess effective verbal & written communication skills.

Experience 3 - 8 Years

Education UG - Any Graduate - Any Specialization
PG - Any PG Course - Any Specialization
Location Mumbai
Keywords Db2 DBA, Table, Index, LOB, Rollback,temporary segments
Contact Larsen & Toubro Infotech Ltd

Email ims.vashi@lntinfotech.com
Website http://www.Lntinfotech.com



MNC JOB OPENINGS ON THIS TECHNOLOGY-APPLY HERE