IMSI jobs - DBA - DB2

DBA - DB2

IMSI
experience 2 to 3 Years
salary Salary not disclosed
Posted: 4 Years ago
Views: 0
Applications: 0
Openings: 1

Job Description

DBA - DB2
Qualification: 10+2+3 (Graduate / Diploma )
Certification: Trained
Experience Level:2-3 Years
Locations:  Delhi NCR, Bangalore, Chennai, Hyderabad, Pune, Ahmedabad, Mumbai, Kolkata
Job Description: 
  • Perform Monitoring of Critical parameter of DatabasesCreate, modify and delete database and database objectsCreate, modify and delete users and properties
  • Create, modify and delete jobs perform periodic database performance tuning as per the documented procedures
  • Perform periodic house-keeping of 
  • Perform maintenance activities like database consistency checks, index maintenance
  • Perform orderly start-up and shutdown of database services
  • Restore databases in the event of a server crashed, modify and delete permissions to database objects and troubleshoot user loginsRectify database configuration problems
  • Perform regular defragmentation activities for better space management and performance
  • Perform table-loading jobs Grant and revoke database access to users
  • Participation in DR drillHousekeeping on DR server- cleaning up of Archive logs and Alert logs/transaction logs Re-build DR in case of a crash
  • Usage of data dictionary views, Expert in database administration (undo, redo, space, memory management)Installation of databases.
  • Upgradation and Patching of Databases
  • Patching Standalone and RAC databases with multiple node environments
  • Database refresh from production environment using Active database, database cloning, cold / hot backup restoration and Export/ Import.
  • Extensively using the Export/ Import utilities for selective regular backup, transferring the object from Oracle Databases for refresh option Database backup & recovery Backup scheduling (using OEM, crontab jobs) , troubleshooting on backup failures and database recovery in various scenarios Standby database creation/ Rebuild.
  • Implemented backup strategy for Production and Other databases
  • Working Knowledge of configuring Data Guard Physical Standby Database / Logical Standby database, using offline backup, RMAN, Active database
  • Migration of DatabasesGood Knowledge in troubleshooting issues , Advanced Backup and recovery
  • Database performance tuning, Troubleshooting database issues, Basic SQL and PL/SQL knowledge.
  • Good knowledge of Unix and shell scripting ,  Handling database Corruption issues Implementing Best practices Performing technical deep diveRCA preparation experience in logshipping and mirroring
  • Experience in Reporting Services, Development environments & Replication and Cluster Server Environments.
  • Managing & controlling security, setting up new users, auditing user activity & setting-up user profiles.
  • Experience in Database backup and disaster recovery procedures.Managing job queues.
  • Managing production/test databases, ensuring database integrity and availability.
  • Responsible for Database security and Installations of Databases.
  • Deadlocking and troubleshooting SQL Related issue.
  • Backup & Recovery, Capacity Planning, Database Exports, Database Migrations.Responsible for the availability of the Databases and optimum running of the Business Applications.
  • Taking Database Backups and Restoration of databases and verify if backup is restorable.
  • Performing Re-indexing, Defragmentation and Integrity Jobs on the database to optimizing the database performances.
  • Create and manage tables, indexes, Spaces and stored procedures. 

Job Particulars

Role Others
Who can applyExperienced (2 to 3 Years)
Hiring Process Face to Face Interview
Employment TypeFull Time
Job Id258575
StateGujarat
Country India

About Company

We are innovative, knowledge and process-driven and enters each client engagement with the goal of building long term relationships and total client satisfaction on every project supported. IMSI excels in IT, Professional Staffing and Business Process Outsourcing (BPO) and Call Centers. Expert staffing resources have industry knowledge, 2-10 years of experience, certification and skills, are self-driven and have great teamwork and communication skills.
Specialties

IT / Telecom / Engineering Staffing, BPO/Call Center Facilities, Project Management

Jobs By LocationVIEW ALL
Active Jobs By Role
Accountant (3667) Admin (20) Agriculture and Dairy (0) Architect (574) Bartender (0) Beauticians / Spa (15) Bouncer (0) BPO / Customer care (26256) Caretaker / Nanny (0) Carpenter (1) Cashier (1) Cleaner / Washer (0) Construction / Laborer (1) Content Writer (585) Cook / Chef (72) Counsellor (244) Data Entry / Back Office (15824) Data Analytics (2) Design / Animation (2995) Delivery (86) Digital marketing / SEO (902) Draughtsman/Draftsman (0) Doctor / Physician (77) Driver (7) Electrician (6) Engineer (38988) Engraver (0) Event Planner (0) Fire Fighter (1) Fitter (2) Gardener(Mali) (0) Ground Staff (3) Hospitality Executives (299) Housekeeping (8) HR (1728) Insurance Consultant (0) IT Hardware Engineer (2033) IT - Mobile Developer (2982) IT Software-Engineer (23471) IT Software-QA/Tester (19) Lab Technician (1) Language Translator (1) Legal (2) Librarian (0) Management Trainee (1286) Mechanic (469) Media / Journalism (293) MIS Executive (7) Moulder (0) Nurse (598) Nutritionist / Dietician (0) Office Assistant / Helper (9) Operations (9) Operator / Machinist (3) Packager (3) Painter (0) Pharmacist / Medical Rep (849) Photographer / Videographer (1) Physiotherapist (1) Research/JRF/SRF (67) Plumber (0) Receptionist / Front Office (1092) Retail / Store Executive (204) Rigger (0) Sales / Marketing (6892) Security / Guards (5) Sports Trainer (0) Tailor/ dress designer (89) Teacher (340) Tool & Die Maker (2) Tourist Guide (0) Trainer (10) Waiter / Steward (2) Ward Boy (0) Warehouse Executive (4) Welder (1) Others (732)
safety tipsSafety Tips
Teamlease does not charge any kind of payment for a job.
get job tipsHow to get a Job early? Follow these tips

1.The more the Jobs you apply, the higher your chances of getting a job.

2. Keep your profile updated Update

Recruiters prefer candidates with complete profile information.

3. Keep visiting the Teamlease.com daily

Daily visit will ensure you won’t miss out on any Job opportunity.

4. Watch videos to improve Watch videos

Be a better candidate than others by watching these Job-related videos.