We are looking for DB2 administration
Support the organization in developing, operating and managing large and sophisticated enterprise database environments
ü Coordinate activities performed by the team, track and report on team activities, define and document team processes, troubleshoot escalated issues and will be hands-on in operational DBA tasks which involves database-monitoring, performance tuning, backup and recovery, installation, maintenance, and disaster recovery.
ü Responsible for upgrades, performance monitoring, installations, managing replications, diagnosing system problems, disaster recovery testing and maintaining user
ü accessibility
ü Resolving complex issues involving: database performance, database capacity, resiliency, stability, replication, and other key aspects of distributed database technology
ü Ability to craft and alter of DB2 object according to the requirement (Ex: Database, Table space, Table, Index, etc)
ü Experience in Online/Offline utility: Running Reorgs and Runstats, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities, Administering database organizations, standards, controls, procedures, and documentation
ü Providing technical support for day-to-day DB2 with High Availability (HADR) in AIX Power HA environment including developing and applying procedures for periodic
ü Database backups using IBM TSM, measuring database performance and troubleshooting complex database and HADR issues
ü Backup plan configuration using the T-SQL statement Rebuild/ Re-organize index configuration using the maintenance plan DB maintenance and I/O error report Checking the Lock and block on the instance.
ü Configuring TSM online DB backups, TDP configurations.
ü Database restoration based on the request for support assets.
ü Start up and shutdown of database instances Data file and log file movement.
ü Application PATCH execution.
ü Service pack /PATCH updates on cluster server.
ü DR reconfiguration and setup in case of failure due to incident.
ü Log Shipping configuration in standby mode/no recovery mode/ different domain.
ü Mirroring configuration in asynchronous mode/synchronous mode without automatic fail-over/ synchronous mode with automatic fail-over/ different domain.
ü Configuration and setup DB cluster
ü Monitoring the database performance by DB2MON & DB2TOP & DSM
ü Database performance tuning using db2advis, DB2explain utilities
ü Trouble shooting database issues using db2diag and notification logs, snapshot, event monitor.
ü Generating report on database performance using Database server management tool.
ü HADR environment and log shipping issues, replication in DB2 UDB environment Working knowledge of Unix Working on server upgrades, fix pack install and database migration.
ü Implementing and maintaining databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods; including maintenance of database dictionaries, and integration of systems through database design and implementation
ü Maintaining database dictionaries and documents Job Control Language (JCL), SQL, Perl and shell scripts and batch processes
ü Coordinating and Implementing changes to DB2 (vesion 9.7,10.5 and above) and DB2 FixPaks in AIX,Linux and Windows environments to improve performance, stability and security
ü Configuring, maintaining and monitoring system, user databases, schemas, table spaces, tables, indexes, buffer pools, logs and instances in an AIX,Linux and Window environment