DB2 Database Administrator

Washington, DC
Oct 18, 2019
Oct 22, 2019
Full Time
The incumbent will be a DB2 DBA with expertise in DB2 databases, DPF and HADR. Provide day-to-day database support for misson critical applications on DB2 DPF (Database Partitioning Feature) and DB2 HADR (High Availability Disaster Recovery) databases. Rotating 24x7 on-call support responsibility Manage and monitor DB2 HA (High Availability) infrastructure and TSA (Tivoli System Automation) to ensure 24 x7 system availability Design and implement DB2 management functions such as system backup, database reorganization, runstats, etc for HA environment and to maximize system availability and use. Conduct performance tuning and optimization work on multiple DB2 databases tuning SQL and database structures for optimal performance and system throughput. Analyze performance issues and troubleshoot hardware, storage, network and workload for optimization. Install, configure, and manage the full DB2 software stack on AIX environment for HA and maximum performance. Partner with project teams and interact with customers to identify technical solutions for projects and operational issues Provide support for data replication between production site and disaster recovery site Ensure stability of both infrastructure and software stack Provide support for performance testing sytem optimization Work with product vendors (eg, IBM and EMC) for troubleshooting and collecting traces for enhanced vendor support

Similar jobs