DBA- Oracle

Experience : 2 to 3 Years
Location : Kolkata
Job Role : Others
Posted on 03 Jan 20
Job is expired
Job DescriptionLast Date 26 Jan 20
DBA- Oracle
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 Databases
  • Create, modify and delete database and database objects Create, 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 crashAdd, 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 crash Usage of data dictionary views, Expert in database administration (undo, redo, space, memory management)Installation of databases .
  • Upgradation and Patching of DatabasesPatching 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 Databases Good Knowledge in troubleshooting issues , Advanced Backup and recovery Database performance tuning,Trouble shooting 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 dive RCA preparation
  • Experience in logshipping and mirroring .
  • Experience on 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 Type : Full Time
Interview Type : Face to Face Interview
Company Description
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.

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

Job is expired
Teamlease does not charge any kind of payment for a job.