Db2 Dba Resume
0/5 (Submit Your Rating)
Dearborn, MI
SUMMARY
- 作为DB2 UDB DBA,拥有5年丰富的IT经验.
- 实现的数据库恢复、应用程序的性能调优和备份.
- 使用DB2的Explain实现应用程序性能调优,以改善性能下降和查询性能优化, Visual Explain and advises tools.
- Performed installs of DB2 software and builds of new instances; set up High Availability Disaster Recovery environment (HADR) for DB2 applications.
- 通过准备文档为新的数据库管理员提供帮助和指导, training plans and performing knowledge transfer.
- Having strong experience in Unix shell scripts, New Korn and awk shell scripts, 使用Unix Shell开发执行runstats的自动化脚本, reorg, rebind, backup, load, export, import, load, auto - load, backup, 还原/365下注平台实用程序和其他相关的数据库活动,如完整的HADR设置.
- 根据应用程序团队的需求在数据库上创建了多个模式.
- 使用脚本监控生产数据库的表空间利用率.
- 致力于数据库分区特性(DPF),包括物理分区和逻辑分区, formerly known as EEE.
- 联机完整备份和增量备份的数据库备份和恢复经验, online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.
- Complete knowledge of design concepts of MQTs, MDCs, Range-Partitioned tables, Range-Clustered tables, and distribution keys.
- 有产品缺陷根本原因分析的经验,并且是团队中所有问题的关键人物.
- Quick learner & 具有良好的团队合作精神,工作灵活,喜欢掌握新的工作任务.
- Possess excellent communication skills & leadership abilities and loyal work ethics.
- 成功地应对新的技术挑战并找到满足客户需求的解决方案.
- Provided DB2 support during every quarterly release.
- Migrated DB2 from v9.7 to v10.5 FP5 and upgrades to latest fix packs.
- Provided 7x24 DB2 support.
PROFESSIONAL EXPERIENCE
Confidential, Dearborn, MI
DB2 DBA
Responsibilities:
- Perform rolling fixpack apply on HADR environments.
- Database utility experience including reorg, runstats, rebind, export, import, load, autoload, backup, restore and recover database utilities.
- Migration of DB2 from v9.7 to 10.5
- 使用跨不同备份/恢复解决方案的重定向恢复,执行从Prod到低级环境的数据刷新.
- 根据解决方案请求/更改安装/升级DB2 Server、DB2 Client、DB2 Connect.
- Create Instances and databases as per Solution Requests.
- Experienced in UNIX shell scripting and troubleshooting. 使用shell脚本来监视数据库的不同方面.
- 支持分区环境(DPF)上的cognos应用程序,具有8个物理分区和29个分区仓库环境.
- 具有使用mdc、MQTS、范围分区表和范围集群表的经验.
- 使用脚本监视数据库上的临时空间使用情况.
- 在所有实例上应用安全补丁和修复包更新.
- 联机完整备份和增量备份的数据库备份和恢复经验, online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.
- DB2 HADR的高可用性(HA)和灾难恢复(DR)体验.
- 使用DB2 Health Center的实例和数据库监视和调优经验, 快照和事件监视器用于监视和优化实例和数据库配置参数, table spaces, and buffer pools.
- 使用DB2的Explain进行数据库和SQL访问计划优化, Visual Explain, and advisor tools. Stored procedure (SP).
- 有使用shell脚本自动化数据库维护和监控的经验,包括自动化系统事件日志记录, e-mail alert notification, 以及使用DB2实用程序和命令行处理器(CLP)进行报告.
- IBM Problem management, 使用DB2诊断日志工具的经验, administration notification log, trace facilities.
- 执行数据库备份和恢复等管理任务, Monitoring database health in terms of memory, CPU utilization, disk space and security.
- 负责为执行缓慢的查询运行优化器计划, 运行跟踪并创建查询性能和数据库恢复的标准报告. 性能调优使用OPM、db2advis、db2expln进行查询优化.
- 有良好的故障排除技术经验,以确保快速和成功的解决方案(快照), db2pd, db2top etc.).
- Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
- 允许Federation在连接到另一个数据库时检索其他数据库对象,以及设置注册表变量以启用Federation of Cross RDBMS.
- 准备文件,培训计划并进行知识转移.
Environment: Operating System: AIX 5.1/6.0/7.1.
Confidential
DB2 DBA
Responsibilities:
- 根据业务需求实现数据库的备份和恢复策略.
- 从联机和脱机备份执行时间点前滚.
- 在迁移和升级时绑定数据库和创建包.
- Performing Reorg, Run stats.
- Changing the Database from Circular to Archival logging.
- Updating Instance memory and Database memory.
- 在QA和开发区域中建立与生产环境中相同的数据库.
- 导出、导入和加载实用程序,用于在测试区域中设置与生产环境中存在的相同的引用.
- Perform TSM setup.
- Retrieval of the LOGS and Database backups from TSM.
- 根据应用需求,负责协调DPF备份和数据库恢复
- Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
- Reducing the HWM using reduce max.
- Database and Server migration from 9.7 to 10.5
- 精通使用MQT和Staging表优化SQL查询,以获得更好的读操作.
- 提供一些减少大型数据库备份时间的方法.
- 用于共享环境的db2实例的移动.
- Setting up of Federation across RDBS platforms.
- 10.5 upgrades and applying Fix pack patch (rolling patch).
- Setting up of backup/restoring strategy of TSM.
- 日常维护和支持活动以及每月基础设施变更窗口的变更.
- 根本原因分析,在问题和严重程度期间24*7的可用性.
Environment: 操作系统:Windows XP, Windows server 2003/2008, AIX, Linux