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 & Administration .
Good Knowledge on Triggers and Stored procedures, authorizations, designing of new objects using Designing tools like ERWIN.
Shahi, the most successful export company in India, started its new Home furnishings... division in 2004. Read full description