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）分为几个级别（ level/level）；宪法（Constitution）规定了三个级别（de jure level），但实际上有五个级别（de facto level/practical level）——33个省级（/-level region/-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个省（）【台湾省也可以叫‘据称’的省份，claimed 】、五个自治区（autonomous region）、四个直辖市（municipality/centrally-administered municipality）及两个特别行政区（special administrative region/SAR）【香港（Hong Kong）与澳门（Macau/Macao）】。直属（subservient to）中央政府（central ）。省长叫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 office）、181个苏木（sumu）及一个民族苏木（ethnic sumu）。

村级行政区具体包括80717个社区居民委员会（hood committee）【社区叫hood或）】及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）