首席Oracle数据库实施工程师(银行业)
甲骨文(中国)软件系统有限公司
- 公司规模:500-1000人
- 公司性质:外资(欧美)
- 公司行业:计算机软件
职位信息
- 发布日期:2017-03-20
- 工作地点:北京-朝阳区
- 招聘人数:1人
- 工作经验:8-9年经验
- 学历要求:本科
- 语言要求:英语 熟练
- 职位月薪:2.5+ 万/月
- 职位类别:数据库工程师/管理员
职位描述
职位描述:
? Support performance tuning and optimization
? Support space management - identify objects requiring archiving and purge and preparation archival and purge scripts for EOD / EOW / EOM etc
? Perform or prepare rules and process for doing DB Reorganization
? On-going daily analysis of AWR, TKPROF and other such reports to identify – Top queries, FTSCAN and other such issues on a on-going basis and also create process notes document for bank’s use
? Back-up Handling - Too large DB – how to - SNAP Shot technology – RMAN / alternative options
? Restore handling – procedures and steps
? Archive logs and DR replication
? External datawarehouse/ datamart integration and using Archive logs with efficient performance and also to optimize – using Shareplex / CDC / Golden Gate / IBM DB2 compatible solutions
? As part of Performance Tuning – Identify Bottlenecks and suggest optimizations to Banks. For example, DB memory, Redo log organization, sessions, processes, etc
? Review, monitor and suggest improvements in Gather Stats strategy.
? High Availability testing and parameterization
? Part of Space management – Database Compression implementation
? Support the Oracle database (including RAC) installation in different platforms (AIX, Linux, Windows).
? Support the performance tuning and optimization during product benchmarks in Customer and h/w provider Labs
? Provide the recommendation of the database features and hands on practice for the requirements like data isolation, data masking, distributed architecture
Experience
? 7 – 15 years experience over-all with at least 5 years on Oracle DB 10G and above and preferably 12c.
? Experience working in both Datawarehouse environments as well as OLTP driven high-volume transaction processing environments is desired
? Experience working for Banks, Telco’s, Tech companies would be preferred
? Chinese speaking and preferably Chinese preferred, willing to travel in China to different cities as project need is expected
? Working with cross-cultural and cross geography is an added advantage
? Working or reasonable English language speaking / written is an added advantage
举报
分享
? Support performance tuning and optimization
? Support space management - identify objects requiring archiving and purge and preparation archival and purge scripts for EOD / EOW / EOM etc
? Perform or prepare rules and process for doing DB Reorganization
? On-going daily analysis of AWR, TKPROF and other such reports to identify – Top queries, FTSCAN and other such issues on a on-going basis and also create process notes document for bank’s use
? Back-up Handling - Too large DB – how to - SNAP Shot technology – RMAN / alternative options
? Restore handling – procedures and steps
? Archive logs and DR replication
? External datawarehouse/ datamart integration and using Archive logs with efficient performance and also to optimize – using Shareplex / CDC / Golden Gate / IBM DB2 compatible solutions
? As part of Performance Tuning – Identify Bottlenecks and suggest optimizations to Banks. For example, DB memory, Redo log organization, sessions, processes, etc
? Review, monitor and suggest improvements in Gather Stats strategy.
? High Availability testing and parameterization
? Part of Space management – Database Compression implementation
? Support the Oracle database (including RAC) installation in different platforms (AIX, Linux, Windows).
? Support the performance tuning and optimization during product benchmarks in Customer and h/w provider Labs
? Provide the recommendation of the database features and hands on practice for the requirements like data isolation, data masking, distributed architecture
Experience
? 7 – 15 years experience over-all with at least 5 years on Oracle DB 10G and above and preferably 12c.
? Experience working in both Datawarehouse environments as well as OLTP driven high-volume transaction processing environments is desired
? Experience working for Banks, Telco’s, Tech companies would be preferred
? Chinese speaking and preferably Chinese preferred, willing to travel in China to different cities as project need is expected
? Working with cross-cultural and cross geography is an added advantage
? Working or reasonable English language speaking / written is an added advantage
职能类别: 数据库工程师/管理员
关键字: Oracle
公司介绍
Oracle (NYSE: ORCL) was established in 1977 and is headquartered in Redwood Shores, California, USA. Oracle, a global provider of enterprise cloud computing, is empowering businesses of all sizes on their journey of digital transformation. The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly-Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database.
Oracle entered China in the 1980s with its first office in Beijing. Today, Oracle has a presence in almost every province, autonomous region and municipality with 22 branch offices, five research and development centers, an extensive Oracle Partner Network as well as various community projects. In China, Oracle has more than 25,000 customers, 1,500 partners, and over 5,000 employees. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com or www.oracle.com/cn
甲骨文公司(NYSE:ORCL)创立于1977年,总部位于美国加利福尼亚州红木城。甲骨文是一家全球性的企业云服务提供商,致力于赋能各种规模的企业的数字化转型之旅。Oracle云在销售、服务、市场营销、人力资源、财务、供应链和制造领域提供全面的集成应用,及基于Oracle自治数据库打造的具有高度自治能力和安全性的第二代基础设施。
二十世纪八十年代,甲骨文进入中国市场,在北京设立了首家中国办事处。而今,甲骨文的业务已几近覆盖中国所有的省、自治区与直辖市——我们在中国建立了22个分支机构、5个研发中心、规模庞大且弥足珍贵的合作伙伴网络,开展了多种多样的社区计划。在中国,甲骨文拥有超过2.5万家客户、1500家合作伙伴和超过5000名员工。如需了解更多关于甲骨文公司的信息,请访问:www.oracle.com或www.oracle.com/cn
Oracle entered China in the 1980s with its first office in Beijing. Today, Oracle has a presence in almost every province, autonomous region and municipality with 22 branch offices, five research and development centers, an extensive Oracle Partner Network as well as various community projects. In China, Oracle has more than 25,000 customers, 1,500 partners, and over 5,000 employees. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com or www.oracle.com/cn
甲骨文公司(NYSE:ORCL)创立于1977年,总部位于美国加利福尼亚州红木城。甲骨文是一家全球性的企业云服务提供商,致力于赋能各种规模的企业的数字化转型之旅。Oracle云在销售、服务、市场营销、人力资源、财务、供应链和制造领域提供全面的集成应用,及基于Oracle自治数据库打造的具有高度自治能力和安全性的第二代基础设施。
二十世纪八十年代,甲骨文进入中国市场,在北京设立了首家中国办事处。而今,甲骨文的业务已几近覆盖中国所有的省、自治区与直辖市——我们在中国建立了22个分支机构、5个研发中心、规模庞大且弥足珍贵的合作伙伴网络,开展了多种多样的社区计划。在中国,甲骨文拥有超过2.5万家客户、1500家合作伙伴和超过5000名员工。如需了解更多关于甲骨文公司的信息,请访问:www.oracle.com或www.oracle.com/cn
联系方式
- Email:qi.mel@oracle.com
- 公司地址:地址:span天津路名人商业大厦