Hiring for Job | DB2 | Data Base Administrator | Shahi Exports | Faridabad Faridabad for Exp. 5 - 8 Years at Shahi Exports Pvt Ltd..

  • Esteemed client of Orion TrueTech Services India
  • Faridabad, Haryana, India
  • Apr 16, 2018
Full time Engineering / Manufacturing Jobs

Job Description

Job Description:Job Description: On-call support, Responsible for supporting the Oracle Databases,DB2 databases on AIX/AS400 and ensuring their performance, availability and security. Responsible for troubleshooting and problem solving of Oracle/DB2 databases. Responsible for Disaster Recovery, Performance Tuning and SQL Tuning. Responsible for improvement and maintenance of the databases to include rollout and upgrades. Responsible for implementation and release of database changes according to agreed timescales. Responsible for upgrades and patch fixes, installations solving performance related problems. Implementing automations to improve business support and avoid outages. Responsible for creating database objects and modeling according project requirements. Should have knowledge of Oracle Utilities like SQL Plus,SQL Loader,Export/Import , Recovery Manager Should have knowledge of DB2 Utilities like REORG, LOAD, UNLOAD, REORG, IMAGECOPY,RECOVERY Should have knowledge in backup and recovery concepts and logging. Review Daily Space Report and add space to database files as needed. Monitoring HADR environment and troubleshooting HADR issues . Good knowledge on Integrations and ETL tools ex. Webmethods, SOA, Informatica etc. General UNIX/ Linux/AIX concepts &amp Administration . Good Knowledge on Triggers and Stored procedures, authorizations, designing of new objects using Designing tools like ERWIN.