年终小结英文

1. database daily monitoring and maintenance

Real-time local factories and CIC, OPEN the database operation monitoring, such as db lock, cpu and memory usage, wait event, etc.

Periodic table space usage, the database backup status monitoring.

2. database emergency and emergency treatment

Database on OP reports an exception for timely processing, such as shutdown, alter db log an error ora-, table space-thresholds, archiving, and backup failed, etc.

3, database optimization

On the business performance of the database for tuning, and monitoring to identify slow-running SQL.

Through the optimization of the database on LNTDERN1_LNTPROD to CPU usage significantly decreased, as Poland has done a project online.

There are also on LGESYMDBSY1M_CHMES, LGENT_NTMES, LNT-XM, SQL tuning, some business module performance has dramatically improved.

4, database, and backup and recovery

Due to business needs, such as for a new server, deploy, development environment, completed a production environment for data backup and recovery,

On the part of the plant database do backup policy adjustments. If LGENT_GSPISND LGECHMWDDBJ0Q_EZPTEST LGEHN_MES, etc,

5. complete new database creation and patch

Due to business needs, create and deploy a new database, such as the cnmas, CHNATMT

And team members completed the CIC dblink patch upgrade all databases, and other security patch upgrade

6, domestic travel project and human support

(1). the complete Guangzhou LGD database deployment projects

(2). the complete project of Tianjin FANHAN database optimization

(3). daily to Fuzhou MKL database monitoring and maintenance

7. participation in the database migration and integration

And team members completed a LGECHMDBBJ1Q Server database consolidation and migration work

8, KEB RAC database environment monitoring and maintenance

9, new technology and skills upgrading of learning

Through their own learning, on AIX, SOLARIS, UNIX, LINUX systems have a better understanding of oracle 10g11g enhances learning

The next annual work plans and prospects:

1. do a good job database daily monitoring and maintenance work.

2. database emergency treatment to more timely and accurate.

3, conscientious and individual business sector database support.

4. on the database high availability, and new technologies are more in-depth learning to adapt to the company's development.

Individual assessment and concluded:

All in all this work is done smoothly, as a member of the DBA team, be responsible for completing the leaders and team tasks, assigned by the Minister

Timely and accurate processing of various database exception, the maintenance system stability, the error loss to a minimum. Be careful to comply with company rules and regulations, the sense of ownership.

In a year's work, I feel my ability of technology has dramatically improved, so I hope the new year wage increase can be adapted to reflect my values.

Finally, I wish the company and our departments and the team of everyone in the new year is a good development.

Thank you!