SUMMARY

• Oracle certified professional with 9 years of progressive hands - on technical experience in Oracle database versions 8i, 9i, 10g和11g.
• 丰富的策划经验, 安装, 打补丁, 配置, 在各种UNIX上升级和管理大型Oracle数据库 & Windows环境中.
• Proficient in managing high availability solutions like 真实应用集群, Dataguard, Goldengate复制和自动存储管理.
• 具有设计和实现数据库备份的专业知识 & recovery plans using RMAN, and setting up secondary backups using Datapump.
• Good understanding and implementation experience in database performance monitoring, 诊断和调优.
• 高度关注预防性维护, 管理事件, 变更控制过程, 满足P1/2解决方案SLA和过程改进.
• A good team-player with a proven ability to deliver high quality services and to mentor/train other DBAs and provide technical guidance

技术技能

数据库: Oracle 8i, 9i， 10g和11g企业版

操作系统: Sun Solaris, HP-UX, IBM AIX， LINUX, Windows NT

语言: C， SQL, PL/SQL，基本UNIX Shell编程

数据库工具 & 公用事业: Oracle恢复管理器, 真实应用集群, GoldenGate复制, 数据保护, SQL *加载程序, Datapump, 导出/导入, 蟾蜍, SQL开发人员

专业经验

保密

Oracle高级数据库管理员

职责:

• Responsible for all end to end technical activities starting from day-to-day jobs monitoring, 用户管理, 空间管理, 数据库设计, 备份和恢复, 迁移, 升级等.
• 设置和配置备份 & Recovery solutions for the production databases, 按照定义的标准和流程. 每天监视备份的成功完成情况.
• Performing monthly 维护 activities as analyzing data growth and setting up data archival, 创建当月所需的分区, 分析性能并计划未来的改进.
• 使用ASM存储管理管理RAC实例.
• Managing and monitoring the Goldengate replication environment configured for real time replication of data.
• Review and manage changes to data and database structure via formal change control process. 管理事件、服务请求和变更.
• Participate in weekly data meeting with the client for addressing the business data related issues raised by the client and business users.
• Frequently meet with the application teams to review the application requirements and changes.
• 按照Oracle的建议应用PSU和一次性补丁.
• As a member of the Oracle projects team responsible for all the major databases related projects.
• 监控数据仓库负载 & 报告工作. Troubleshooting and rectifying the issues in case of any failures or delays, to avoid SLA misses.
• 参与审计和合规活动

环境: Oracle 11g/10g/9i、RAC、Goldengate、Sun Solaris、AIX、蟾蜍、RMAN

保密

Oracle高级数据库管理员

职责:

• 设计, Implementing and administering database High Availability solutions like 真实应用集群 and standby databases, 按照已定义的标准. 维护环境以确保高可用性和可靠性.
• 设置和配置备份 and Recovery solutions for the production databases, 按照定义的标准和流程. 并每天监控备份的成功完成情况.
• 设置实际应用程序集群数据库, 节点添加, 服务配置, 负载均衡设置, 处理节点退出问题的RCA, 管理资源故障转移和集群软件资源.
• ASM （Automatic Storage Management）的实现 & 维护.
• Configuring and administration of the Golden Gate replication tool for real-time data replication. Managing the configuration changes in co-ordination with the third party vendor which manages the source databases.
• Perform Database Patch/Version upgrades and 迁移s to various platforms. 并为操作系统补丁和维护活动提供DBA支持.
• Meeting the P1/2 tickets resolution SLA as defined, for the service tickets management. 重点关注P1/2/3故障的完整和准确的RCA.
• 按要求参加团队/客户会议和研讨会.
• 关注预防性维护和数据库性能调优. Ensuring that all the supported environments have correct monitoring in place for pro-active problem solving.
• 关注生产质量的变化. Making sure the change details are obtained on time, and performing a thorough review and test.
• 作为Oracle 10g升级技术SME和质量审核团队的一员, driven the Oracle 10g database upgradation efforts for the team and helped with the progress of the upgrades for all the 保密 databases.
• Contributed for the standardization of the upgrade procedures and guidelines.
• 执行跨平台和版本的数据库迁移/升级
• Educating the team about the guidelines, procedures and Processes to be followed for any upgrades.
• Participate in weekly SME meetings to track the progress and effectiveness of the planned database upgrades, 解决任何问题/顾虑, 并探讨了改进项目规划的有效途径
• Monitor/audit the upgrade process and ensure that the DBA teams are following established guidelines and procedures
• Participate in major release activities right from the initial plan reviews till the implementation. 主要的发布活动包括：
• Participating in Walk thru Meetings with all the application teams, and addressing the issues if any
• 为发布活动提供人员配备计划
• Perform database refreshes for the ORT/QA/Break Fix environments to sync to structure with production database.
• Receiving the script packages from Test DBA team and testing the packages in QA environment
• Sketch out all the necessary pre-works to be performed, and performing them prior to the release
• Coordinating with the third party vendor on the changes related to GoldenGate replicated tables and making appropriate changes at the target.
• Deployment of the planned changes in production database as per the project plan
• Performing post-release steps and assisting with the post-deployment testing.
• Providing on-call support for business critical applications on a 24x7 basis and Follow-The-Sun method.
• Participate in ERD Review meeting and address any of the known requirements, 风险, and/or dependencies to the user community with all stake holders involved.
• 培训和指导新员工和初级dba, 并在需要时提供技术援助. 为团队组织各种主题的知识分享.

环境: Oracle 11g/10g/9i, RAC, ASM, GoldenGate, 数据保护, Sun Solaris, AIX, HP UNIX

保密

数据库管理员

职责:

• Installation and configuration of Oracle 9i products and its related tools on various OS platforms like Linux, Windows NT, 2000.
• 数据库的创建和维护. Created databases for different applications keeping in view the space requirements for coming months.
• 创建用户、配置文件并向用户授予角色/特权. Managing database security by assigning appropriate roles and privileges to users depending on the user activity. 控制和监视用户对数据库的访问
• Managing the Tablespaces for different user by granting quota on default and Temporary Tablespaces
• Creating primary database objects and day-to-day monitoring of the database.
• 设计和实现数据库备份和恢复程序. 配置和维护恢复管理器（RMAN）存储库
• 使用逻辑导出对数据库进行备份和恢复 & 导入)和物理（在线） & 离线备份).
• 执行Oracle补丁和数据库升级.
• Performing 维护 with Recovery Manager by 配置 retention policies, 交叉检查备份和副本, 删除过时和过期的备份.

环境: Oracle 10g/9i, Windows NT, Sun Solaris， LINUX, SQL开发人员