6B Bangalore, Hyderbad, Kolkata DB2 DBA Admin After hours support – note the support is 7 days a week, night shift and 24 hours on weekends. DB2 DBA (Database Administrator) Knowledge on below Databases (or ready to learn) o Netezza o Sybase ASE o Sybase IQ o MongoDB Candidate will work on - Work on DB2 servers that were configured with HADR environment. - DB2 restores and redirect restores from Prod to multiple environments. - Working with AIX and Linux teams to resolve any kind of space issues for file systems. - Troubleshooting performance issues for Production databases. - Perform database maintenance activities such as backup, reorg, runstats. - Install and configure DB2 UDB new releases, upgrades, and patches. - Design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases - Assisting with the creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes) - Monitor DB2 UDB processes andlogs for any anomalies, provide corrective actions. - Use tools like db2advise, db2look to monitor, analyze and make changes in the database. - Perform database maintenance activities such as backup, reorg, Runstats, Table partition Detach/Attach. - Worked regularly on Table level sync-up activities (Load-Cursor/Export & Import). RTH-Y