I have total 14+Years experience in Database Administration(Informix Version 7.xx,9.xx,11.xx and Informix Terbo 5.11 version), Netezza 126.96.36.199, MQ Admin, Unix Shell Script, Database Migration, System Analysis, Software Development, Implementation, Maintenance and Customer Support.
Read More »
• Good hands on experience in Informix DB, Netezza 188.8.131.52, Oracle DB.
• Good experience in UNIX and shell scripting and worked on design and development.
• Experience in working on PLSQL, SQL, ESQLC, 4GL, SQL, C.
• Good experience in IBM MQ.
• Automation of...
• Ensure Netezza 7.0.2..12 database on line 24X7 basis.
• Assisted in installation, management and tuning of Netezza databases and other records.
• Executed processes for timely release of database changes as per assigned timelines.
• Performed backup and recovery functions of databases on Disk
• Implemented procedures for daily database monitoring, backup and configuration changes.
• Supported optimal performance of databases by gathering statistics in coordination with architects and developers.
• Resolved database problems and issues by troubleshooting and responding to service requests.
• Create batch job in BlueSky Integration to load and retrieve data from Netezza DB
• Performed data movement from Production to Stage and Dev database
• Install and Configure of Informix engine and databases..
• Configure and Maintain HADR instances.
• Implement Netbackup facility using Veritas NetBackup facility.
• I have configured some cron job(alert message like Dbspace full, logical log file backup pending, logical log file full, Secondary server not available Database backup ) at Maestro and FSAC server.
• Create database object like table, index, function, tiger, view etc.
• Fragment table in different dbspace.
• Reorg table when reach more than 140 Extent size
• Pursing old data from critical and non critical tables to manage free space for transaction with out error.
Read More »