徐万新-英文自我介绍
I have over 7 experience in the area of oracle Apps DBA and Oracle RDBMS DBA.
Extensive Oracle DBA and Oracle Applications DBA experiences.
Familiar with Oracle Database installation and patching, backup and recovery, and performance tuning.
Familiar with Oracle 11i/R12/R12.2 installation, upgrade, patching, maintenance and administration.
Extensive [ik'stensiv] adj. 广泛的；大量的；广阔的
familiar [fə'miljə] adj. 熟悉的；常见的；亲近的
I used to work in Beijing Zhongdian Huizhi Technology Co., Ltd from 2014 to 2017.
My main responsibility was maintaining and managing the database of China Power International, including EBS, Peoplesoft, Hyperion, BI etc.
###I used to work in the project of china power international from 2014 and 2017.
###My main responsibility was maintaining the oracle database.
###To be exactly, I’m responsible for implementation, upgrade, migration, troubleshooting, architecture design, performance tuning, and capacity planning.
###The Capacity of the database of China Power's ERP system is about 4TB (terabyte), the amount of concurrent access volume is about 2000 sessions,
###I have accumulated abundant maintenance experience for the system that a large of concurrent access and large of volume data in this project,
###accumulated adj. 累积的；累计的；达到
###abundant adj. 丰富的；充裕的；盛产
###predict vt. 预报，预言；预知
###adjustment n. 调整，调节；调节器
###initiative n. 主动权；首创精神 adj. 主动的；自发的；起始的
These experiences help me to have the following advantages in the future work:
I am able to quickly resolve the problem of the production system, to better improve the system architecture design,
predict the future development trend of the system and give the correct advice and make their own adjustments with more initiative and practical ability,
with excellent writing skills.
In 2016, I obtained the Award of Outstanding Performance in …
It is for this project to work,
I cannot forget those days of hard work.
My colleagues and I worked hard and cooperated actively in order to project on-line work overtime together.
We were very excited each time we achieved satisfactory results and we kept learning and improving our technical skills.
I have the following skills in database technology:
1, to obtain oracle 11g Oracle Certified Professional/Oracle Certified Master certification, including the maintenance of the database version 10g, 11g, 12c,
2, highly available database architecture experience, including RAC, dataguard, goldengate aspects
3, familiar with the oracle middleware weblogic maintenance and management
4, for performance sql tuning knowledge and practical experience
5, made a six-year EBS system management, version include: 11i and R12/R12.2
6, there is a lot of experience in program development, including the development of language: plsql, shell scripts
conversion [kən'və:ʃən] n. 转换；变换；[金融] 兑换；改变信仰
=================================================================================================
*9090
Chief Applications DBA
Summary:
I Have over 7 years of IT experience, about 7 years of Oracle Apps DBA/RDBMS DBA experience
with 8i/9i/10g/11g/12c, RAC/DataGuard/GoldenGate,
EBS 11i/R12/R12.2, upgrade/migration/loadbalance/PCP/shared_apptop
on Linux/AIX/HP-UX/Solaris/Windows...
Hello everyone, I am Xu.wanxin and Xu is many Surname, you can call me Tony, I am graduated from Inner Mongolia Normal University.
and I have got the Bechelor of Computer Science and Technology(2010) and Bechelor of Education(2010).
Beijing Zhongdian Huizhi Technology Co., Ltd 2014-2017
serve China power international
SRS2 Inc. (China), Shanghai, China 2012-2014
Inner Mongolia Zhenglian Information Technology Co.Ltd
1.
I have over 7 years of IT experience, including Applications administration, Oracle database administration, which has
over two years of global experience in OOD services;3 year experience on team management as Oracle Applications DBA Lead.
2.
I am familiar with Oracle Apps 11.5.8/11.5.10/12.1.1/12.1.3/12.2.4/12.2.5/12.2.6 management. Including
installation, implementation, maintenance, cloning, upgrades, migrations, tuning,
troubleshooting, etc;
3.
I have rich experience in Oracle Apps high availability, including Shared APPL_TOP, DMZ, Load blance, PCP;
Cross-platform migration of EBS 12.1.3
4.
I have a good command of Oracle Database 10g/11g/12c on AIX, Linux, Solaris,HP-UX and other
platforms, backup and recovery, data management, data warehouse management,
performance management, Enterprise Manager, DG, RAC/ASM, OGG , troubleshooting and tuning;
Strengths： n. 力量；力气；兵力；长处
Oracle Database, Oracle Apps 11i/R12/R12.2
Qualifications: n. 资格；条件；限制；赋予资格
11g OCA/OCP/OCM
Bechelor of Computer Science and Technology(2010)
Bechelor of Education(2010)
• Chinese: Native
• English: Advanced, CET-4
QUALIFICATIONS:
• Bechelor of Computer Science and Technology(2010) in Inner Mongolia Normal University
###• Fluent command of written and spoken in English
• Strong trouble-shooting and analysis desirable
• Good communication, documentation and interpersonal skill.
• Positive, enthusiastic attitude, self-motivated.
desirable [di'zaiərəbl] adj. 令人满意的；值得要的
enthusiastic [in,θju:zi'æstik] adj. 热情的；热心的；狂热的
self-motivated 自我激励的
Inner Mongolia Normal University
I am currently principal consultant with Oracle Consulting, based out of Beijing PRC.
I have about 7 years of experience as an Oracle DBA and Oracle Apps DBA. I specialize in Oracle RDBMS
(8i/9i/10g/11g/12c) and Oracle applications Administration (11i/R12/R12.2).
I have rich experience in supporting multiple production and development databases under various Unix
and Windows environment.
principal adj. 首要的；最重要的
consultant n. 顾问；咨询者；会诊医生
Extensive work experience includes Implementations, Upgrades, Support and Maintenance of Oracle 11i/R12.0/R12.1/R12.2 E-Business Suite,
the associated Oracle Technology Stack and Oracle Database in a multi-tier/multi-node environment.
extensive adj. 广泛的；大量的；广阔的
Projects Summary:
Project: Oracle Apps R12.2 Project
Period: Oct 2016
Role: Chief Oracle Apps DBA
Responsibilities: Oracle EBS R12.2 installation on Linux. RAC database migration and multi application server load balance, backup, clone, patch
Project: Oracle Migration Project
Period: Mar 2016
Role: Chief Oracle Apps DBA
Responsibilities: Oracle EBS 12.1.3 migration and upgrade from AIX to Linux x86-64.
RAC database migration and multi application server loadbalance. PCP
Project: Oracle EBS Implementation
Period: Nov 2013-Jun 2016
Role: Chief Oracle Apps DBA
Responsibilities: Production system build, RAC/PCP/loadbalance, backup and patch.
DEV and TEST instance clone. Performance tuning. troublehooting, system health check
Project: Oracle on demand [Alcoa upgrade and support Project]
Period: Nov 2012-Jun 2013
Role: Chief Oracle Apps DBA
Responsibilities: Multi Oracle EBS 11i instance upgrade R12.1, Oracle EBS database from 9i to 11.2.0.4.
Migrate oracle ebs database fro single instance to RAC
Troubleshoot Oracle ebs R12.1 issues. Patching, backup, clone, SQL tuning and performance tuning.
Oracle EBS Release 12.2 is next release of EBS
R12.2 Introduced major architecture level changes and new features
Replaces OC4J J2EE Application Server (R12.1.3) with Oracle J2EE WebLogic Server (R12.2)
Dual File System : Two identical file systems are installed with 12.2 Run and Patch Edition
Online patching capability to reduce the downtime
EBR – Edition Based Redefinition is the basis of OLP and comes with 11gR2 (11.2.0.3). Hence 11gR2 is base DB version required in 12.2.
RESPONSIBILITIES:
As the role of project DBA to support and coordinate with world-class functional and technical team on database and Oracle ERP,
also working for operating system migration and conversion for Oracle custom applications.
• Backup/Recovery, Performance tuning in Oracle E-business database system.
• Implement SQL scripts, PL/SQL and UNIX shell programming.
• Install, upgrade, patch, clone database and appliactions.
• Work with Oracle (US) DBA to analyze and tune Oracle 11i/R12/R12.2 E-Business suite instances in Oracle On demand Data Center
• Work with Oracle Support (US) to raise and resolve TAR.
• Install, patch and clone 11i/R12 system. Also work for Application DBA daily duty.
• Upgrade from piror 11i/R12 version of Application system platform to R12.1.3 platform
capability n. 才能，能力；性能，容量
adop
prepare apply finalize cutover cleanup fs_clone
Analyze the execution plan
Analyze the execution plan
Concurrent request slow, the first log
Concurrency request conflict
Trace a Concurrent Request And Generate TKPROF File
View background sql
Through the session id to find the background process
Sorry ,I do not quite understand what you mean
Repeat, please
I do not quite understand what you mean
Can you repeat it please?
The database throws an ora error
We are doing some work
I went to drink the water just now
I have some sql development capabilities
内部职位应聘失败的话
I am committed to this company and its advancement so, should I not be selected,
I will work with and support whoever might get selected.
However, I do feel that my experience in the department and with the team would make me the best candidate
你老板怎么描述你
"My boss would describe me as hard working, loyal, friendly and committed.
He would say that I work well on my own initiative and deliver what he wants on time and to a high standard".
工作压力
“I know that all jobs involve some sort of pressure at some time.
I can work as well under pressure as I do at any other time but when I am busy,
I prioritize activities so that my workload is manageable.”
prioritize
[prai'ɔritaiz, 'praiəri-]
vt. 把…区分优先次序
vi. 把事情按优先顺序排好
--------------------------------------------------------------------------
Oracle EBS R12.2 Upgrade Paths
<11.5.9==>11.5.10.2 Baseline==>12.2
11.5.9==>12.1 ==>12.2
11.5.9==>11.5.10.2 Baseline==>12.2
11.5.10.2==>Baseline==>12.2
12.0/12.1==>12.2
Phase 1
1. Upgrade the database on the existing EBS 12.1: Apps DBA team
2. Execute a functional test: EBS functional team
Phase 2
3. Install all application pre-upgrade patches: Apps DBA team
4. Verify the instance: EBS functional team
Phase 3
5. Execute all functional pre-upgrade tasks including customizations: functional team
6. Perform a full system backup: System and Apps DBA team
Phase 4
7. Apply localization and 12.2 pre-upgrade patches: Apps DBA team
8. Upgrade to 12.2.0: Apps DBA team
9. Enable online patching: Apps DBA team
10. Apply tech stack patches: Apps DBA team
11. Upgrade to 12.2.4/12.2.5: Apps DBA team
12. Perform all post-upgrade tasks: Apps DBA and functional teams
13. Application function test cases: core business users
Chapter 1: Architecture
Chapter 2: Installation and Configuration
Chapter 3: Oracle E-Business Suite Upgrades
Chapter 4: Oracle E-Business Suite 12.2 File System
Chapter 5: Patching Concepts
Chapter 6: Working with the Applications DBA Online Patching Tool (adop)
Chapter 7: Managing FMW/WebLogic
Chapter 8: AutoConfi g to Manage EBS System Confi guration Changes
Chapter 9: SYSADMIN Fundamentals
Chapter 10: Oracle EBS Concurrent Managers
Chapter 11: Cloning Oracle EBS Systems
Chapter 12: An Introduction to Oracle EBS Security
Chapter 13: Oracle E-Business Suite 12.2 Performance Recommendations
Chapter 14: Oracle E-Business Suite 12.2 on Engineered Systems
High-Level Clone Process with AD and TXK Delta6 德尔塔6
Follow these steps:
1. Execute adpreclone.pl dbTier and appsTier.
2. Copy the database and application files (run file system) from the source to
the target.
3. Configure the database tier on the target server.
4. Configure the application tier on the run edition.
5. Copy the run edition to the patch edition.
6. Configure the application tier patch edition.
High-Level Clone Process with AD and TKX Delta7 德尔塔7
Follow these steps:
1. Execute adpreclone.pl dbTier and appsTier.
2. Copy the database and application files (run file system) from the source to
the target.
3. Configure the database tier on the target server.
4. Configure the application tier on the run edition with the dualfs option.
adop phase=prepare,apply,finalize,cutover,cleanup
--------------------------------------------------------------------------
精通 [jīng tōng]
master
be proficient in
have a good command of
be familiar with
be good at
be hot in
be skilled in
be right down one's alley
be perfect in
be well versed in
be practised in
be skillful at
be acquainted with
have an intimate knowledge of
have a good knowledge of
have the knack of
have an intimate acquaintance with sth.
know sth. very well
be expert in
know from A to Z
be saturated with
be at home in
make oneself master of
be great at
be well up in
steep in
be accomplished in
be deeply read in
be a dab at sth.
be adept in sth.
excel in
be conversant with
get a thorough knowledge of
be at one's best in
be certainly A one at
attain proficiency in
a dab hand in
be handy with
old hand (at)
up one's street
Ｘ室 Room Ｘ
Ｘ号 No. Ｘ
Ｘ单元 Unit Ｘ
Ｘ号楼 Building No. Ｘ
Ｘ街 Ｘ Street
Ｘ路 Ｘ Road
Ｘ区 Ｘ District
Ｘ县 Ｘ County
Ｘ镇 Ｘ Town
Ｘ市 Ｘ City
Ｘ省 Ｘ Province
中国各级行政区划的英文表达
中国行政区划（administrative division）分为几个级别（government level/level）；宪法（Constitution）规定了三个级别（de jure level），但实际上有五个级别（de facto level/practical level）——33个省级（province/province-level region/province-level division）、333个地区级（prefecture/prefecture-level region/prefecture-level division/second-level division）【非宪法区划】、2862个县级（county/county-level region/county-level division）、41636个乡级（township/township-level region/township-level division）及无数村级（village/village-level region/village-level division）【非宪法区划】行政区。各个级别又有不同名称，下面加以详细讨论【具体数字以2005年统计数据为准】。
省级行政区具体包括22个省（province）【台湾省也可以叫‘据称’的省份，claimed province】、五个自治区（autonomous region）、四个直辖市（municipality/centrally-administered municipality）及两个特别行政区（special administrative region/SAR）【香港（Hong Kong）与澳门（Macau/Macao）】。直属（subservient to）中央政府（central government）。省长叫governor。
地区级行政区具体包括17个地区（prefecture）、30个自治州（autonomous prefecture）【少数民族叫ethnic minority）】、283个地级市（prefecture-level city）及三个盟（league）。 县级行政区具体包括1464个县（county）、117个自治县（autonomous county）、374个县级市（county-level city）、852个市辖区（district）、49个旗（banner）、三个自治旗（autonomous banner）、一个林区（forestry area）和两个特区（special district）。
乡级行政区具体包括14677个乡（township）、1092个民族乡（ethnic township）、19522个镇（town）、6152个街道办事处（subdistrict）、11个区公所（district public office）、181个苏木（sumu）及一个民族苏木（ethnic sumu）。
村级行政区具体包括80717个社区居民委员会（neighborhood committee）【社区叫neighborhood或community）】及623669个村民委员会（village committee）或村民小组（village group）【包括行政村（administrative village）和自然村（natural village）】。
此外还有些特殊情况，包括副省级城市（sub-provincial city）、副地级市（sub-prefecture-level city）及副省级城市辖区（sub-provincial district）【如上海的浦东和天津的滨海】。
中国又可以分为几个大区，但不是严格的行政区划：
华东（East China） 东北（Northeast China） 华北（North China） 中南（South Central China） 华中（Central China） 华南（Southern China/South China） 西部（Western China） 西北（Northwest China） 西南（Southwest China）
