TESCRA India

Job Role:

• Detailed knowledge about DB2 V10.5 new features.
• Minimum of 12 years for experience with database design, administration and maintenance in distributed environments.
• Strong DB2 Database Administration experience to diagnose DB without help of third party tools.
• Strong experience with Database and SQL Performance tuning as per application requirement. —Mandatory
• Experience in DB2 Database Administration on various OS including AIX, Linux etc.
• In depth knowledge of HACMP/HADR backup/restore, cloning.
• Experience with MQ SERIES and Q-Replication refreshes for various scenarios.
• Experience in IBM InfoSphere Change Data Capture (CDC) environment is a plus
• Extensive experience in TSM Infrastructure. Knowledge on Storage and Network configuration.
• Ability to solve HA issues related to HADR, MQ Series, and Replication methods.
• Experience in migrations and upgrade of database in heterogeneous platform.
• Experience in Monitoring, Configuration and Installation on all Unix or Windows OS
• Experience in Backup & Recovery, Replication and Import/Export and ingest utility.
• Experience in setting up monitoring as per best practice for databases
• Experience in working independent with limited guidance.
• Experience on upgrade, patching DB2 database
• Adhere to ITIL processes and ability to work in PROD, DEV, TEST and QA environments.
• On call troubleshooting experience.
• Excellent communication skills.
• Experience in creating Stored procedures/Functions using DB2 PL/SQL
• Experience in performance tuning of Stored procedures/Functions and SQL queries
• Unix shell and Perl scripting experience