本文发表在 rolia.net 枫下论坛Dear iamta,
I have more than 10 years of work experience in database design, database administration and application development at banking and finance field, and I have acquired expertise in providing system solutiong to accounting and billing with IT. So I apply for this job. The following is the cover letter and resume.
Thank you,
Simon Ma
Simon Ma
1512-29 Rosebank Drive
Toronto, ON
M1B 5Y7
Cell: 1-416-8385385
Dear Sir / Madam:
I am writing to apply for the position of Database Administrator. As your company is a leadership in the business system in the world, I would like to have an opportunity to work with you. Please find my attached resume for your consideration.
I have more than ten years of work experience in the IT industry. As a result, I have acquired broad and in-depth skills and knowledge in various aspects. The following highlights some of my key accomplishments and expertise:
* Strong database analysis and design capabilities
* Hands-on skills of database administration and implementation in Oracle, DB2, MS SQL Server 2000, Visual Foxpro etc.
* Demonstrated knowledge and ability in finance, accounting and billing solution
* Proficiency in recovery solution for database disaster, system security solution and distributed database solution in a multi-server environment
* Abundant experience in database migrant and data replication
* Outstanding capabilities of database back up and recovery
* In-depth knowledge of UNIX ( IBM AIX, SCO UNIX), Red Hat Linux, and Windows 2000 Server
* Many years of work experience in application development through JDBC and ODBC
* familiarity with IBM Content Manager and Tivoli Storage Manager
* Recent Certificate for IBM DB2 UDB V8.1 Database Administrator
I am a highly motivated team player and look forward to exciting challenges. I am confident that my expertise, skills and years of work experience can make me an asset to your company.
Thank you for your consideration.
Yours Sincerely,
Simon Ma
Encl. resume
SIMON MA
1-416-8385385 simonsphere_ma@yahoo.com
1512-29 Rosebank Drive, Toronto, ON M1B 5Y7
OBJECTIVE: Database Administrator and Designer
SUMMARY OF SKILLS
* 10+ years of experience in database design, database administration, database implementation, database technical support, application development
* Abundant work experience in providing banding, finance and ERP solution including billing and accounting process
* In-depth knowledge of UNIX ( IBM AIX, SCO UNIX), Red Hat Linux and Windows 2000 Server Operating Systems and proficiency in UNIX shell programming (Korn shell)
* Hands-on skills of performance tuning at database, application and OS level and risk management
* Excellent capability of trouble shooting problems and good understanding of ORACLE, IBM DB2 UDB, MS SQL SERVER 2000/7, Visual Foxpro, SYBASE
* Recent DB2 certificate
* Fluent English and Chinese
QUALIFICATIONS
IBM Certified Database Administrator
DB2 Universal Database V8.1 for Linux, UNIX and Windows
July 30, 2004
IBM Certified Database Associate
DB2 Universal Database V8.1 Family
December 6, 2003
PROFESSIONAL EXPERIENCE
SINOTRUST Business Information & Consulting Ltd. (China) 2001 – 2005
Field of working: Database design and administration
Accomplishment:
Design the architecture of the SINOTRUST ERP and the SINOTRUST E-Business, design and implement database, program stored procedures and triggers, provide technical consultation and support for database, set up developing environment, install the production and application, trouble shooting system problems, program and debug shell scripts, and maintain servers.
* Designed the architecture of the SINOTRUST ERP application system. It’s a large and complex system which consists of business credit report subsystem, debt collection subsystem, selling management subsystem, financial subsystem and customer service subsystem. The financial subsystem is a professional financial system which processes financial business data of clients’ account, bill, invoice etc.
* Designed the databases being composed of system tables, static tables and dynamic tables for all applications through AllFusion Erwin Data Modeler software
* Provided recovery solution for database disaster through local and remote data centers, data synchronization among data centers as well as database backup strategy
* Created instance, database, table space, container, buffer pool and other database objects in Oracle and DB2
* Extended file system size for DB container by using OS command
* Programmed stored procedures and triggers through DB2 development center
* Designed and Set up the security strategy for the whole system by dividing users into different schemas, roles and groups
* Tuned the performance at database, application and OS level, such as created indexes, reorganized tables, updated statistics information of system and assigned individual buffer pools to table spaces, optimized SQL statements etc.
* Monitored the database activities and analyzed the diagnostic file
* Maintained database in multi-server environment everyday, such as backed up database data into the tape, restored database etc.
* Performed trouble shooting problems at database, application and OS level
* Wrote various technical documents of architecture and database
* Executed schedule tasks at database level and OS level
* Imported data into database and exported data from database to a external file
* Replicated product data between MS SQL Server 2000
* Migrated database from Sybase to SQL Server by using a utility
* Developed applications through JDBC and ODBC
* Provided the dynamic data solution for the BizTeller product, by using a mapping table and a storing table this solution allows users to add extra columns and its data into a table dynamically when the system is running
* Completed formal technical training in DB2, Oracle, Java, WebSphere, IBM AIX 5L, Tivoli etc.
Vanda System & Communications Holdings Ltd. (China) 2000-2001
Field of working: Database design and administration
Accomplishment:
* Designed and Implemented database in the debit card application system for bank of Nanjing Commerce, which was a comprehensive control and management application of banking. The system coding in C connected DB2 through CICS
* Installed DB2 on AIX and created database objects
* Administrated database and optimized application and SQL statements
* Performed trouble shooting the system and programmed stored procedures and triggers
* Developed a professional utility using PowerBuilder for replicating data from Sybase to DB2
China Financial Computerization Company (China) 1995-2000
Field of working: Database administration
Accomplishment:
* Installed Informix Online DB on SCO UNIX in the Account Examining and Calculating System for PBC (the People’s Bank of China)
* Installed Oracle DB on MS Windows NT 4.0 in the Safeguard System for PBC
* Took part in the CAP (Card Access Processor) System for the National Bank Card Switching Center. The CAP was a primary subsystem in the bank card switching system and communicated with other hosts through many kinds of protocols, such as TCP/IP, X.25, SNA etc.
* Created database and database objects for all systems
* Administrated database and tuned performance of database and application
* Performed trouble shooting problems of database and maintained database
* Completed formal technical training in IBM AIX v4.3 and Oracle
Beijing Tianwei Fuel Injection Equipment Inc. (China) 1987-1992
Field of working: Application Development
Accomplishment:
* Researched and analyzed the frame of a dBASE database file, then developed the Fuel Nozzle Management System using C, and the system manipulated the fuel nozzle data stored in Dbase directly and efficiently
EDUCATION
Master Degree in Computer Aided Process Planning
1995 Shenyang Polytechnic University
Diploma in Machinofacture Technology and Equipment
1987 Beijing Management Institute of Machinery Industry更多精彩文章及讨论,请光临枫下论坛 rolia.net
I have more than 10 years of work experience in database design, database administration and application development at banking and finance field, and I have acquired expertise in providing system solutiong to accounting and billing with IT. So I apply for this job. The following is the cover letter and resume.
Thank you,
Simon Ma
Simon Ma
1512-29 Rosebank Drive
Toronto, ON
M1B 5Y7
Cell: 1-416-8385385
Dear Sir / Madam:
I am writing to apply for the position of Database Administrator. As your company is a leadership in the business system in the world, I would like to have an opportunity to work with you. Please find my attached resume for your consideration.
I have more than ten years of work experience in the IT industry. As a result, I have acquired broad and in-depth skills and knowledge in various aspects. The following highlights some of my key accomplishments and expertise:
* Strong database analysis and design capabilities
* Hands-on skills of database administration and implementation in Oracle, DB2, MS SQL Server 2000, Visual Foxpro etc.
* Demonstrated knowledge and ability in finance, accounting and billing solution
* Proficiency in recovery solution for database disaster, system security solution and distributed database solution in a multi-server environment
* Abundant experience in database migrant and data replication
* Outstanding capabilities of database back up and recovery
* In-depth knowledge of UNIX ( IBM AIX, SCO UNIX), Red Hat Linux, and Windows 2000 Server
* Many years of work experience in application development through JDBC and ODBC
* familiarity with IBM Content Manager and Tivoli Storage Manager
* Recent Certificate for IBM DB2 UDB V8.1 Database Administrator
I am a highly motivated team player and look forward to exciting challenges. I am confident that my expertise, skills and years of work experience can make me an asset to your company.
Thank you for your consideration.
Yours Sincerely,
Simon Ma
Encl. resume
SIMON MA
1-416-8385385 simonsphere_ma@yahoo.com
1512-29 Rosebank Drive, Toronto, ON M1B 5Y7
OBJECTIVE: Database Administrator and Designer
SUMMARY OF SKILLS
* 10+ years of experience in database design, database administration, database implementation, database technical support, application development
* Abundant work experience in providing banding, finance and ERP solution including billing and accounting process
* In-depth knowledge of UNIX ( IBM AIX, SCO UNIX), Red Hat Linux and Windows 2000 Server Operating Systems and proficiency in UNIX shell programming (Korn shell)
* Hands-on skills of performance tuning at database, application and OS level and risk management
* Excellent capability of trouble shooting problems and good understanding of ORACLE, IBM DB2 UDB, MS SQL SERVER 2000/7, Visual Foxpro, SYBASE
* Recent DB2 certificate
* Fluent English and Chinese
QUALIFICATIONS
IBM Certified Database Administrator
DB2 Universal Database V8.1 for Linux, UNIX and Windows
July 30, 2004
IBM Certified Database Associate
DB2 Universal Database V8.1 Family
December 6, 2003
PROFESSIONAL EXPERIENCE
SINOTRUST Business Information & Consulting Ltd. (China) 2001 – 2005
Field of working: Database design and administration
Accomplishment:
Design the architecture of the SINOTRUST ERP and the SINOTRUST E-Business, design and implement database, program stored procedures and triggers, provide technical consultation and support for database, set up developing environment, install the production and application, trouble shooting system problems, program and debug shell scripts, and maintain servers.
* Designed the architecture of the SINOTRUST ERP application system. It’s a large and complex system which consists of business credit report subsystem, debt collection subsystem, selling management subsystem, financial subsystem and customer service subsystem. The financial subsystem is a professional financial system which processes financial business data of clients’ account, bill, invoice etc.
* Designed the databases being composed of system tables, static tables and dynamic tables for all applications through AllFusion Erwin Data Modeler software
* Provided recovery solution for database disaster through local and remote data centers, data synchronization among data centers as well as database backup strategy
* Created instance, database, table space, container, buffer pool and other database objects in Oracle and DB2
* Extended file system size for DB container by using OS command
* Programmed stored procedures and triggers through DB2 development center
* Designed and Set up the security strategy for the whole system by dividing users into different schemas, roles and groups
* Tuned the performance at database, application and OS level, such as created indexes, reorganized tables, updated statistics information of system and assigned individual buffer pools to table spaces, optimized SQL statements etc.
* Monitored the database activities and analyzed the diagnostic file
* Maintained database in multi-server environment everyday, such as backed up database data into the tape, restored database etc.
* Performed trouble shooting problems at database, application and OS level
* Wrote various technical documents of architecture and database
* Executed schedule tasks at database level and OS level
* Imported data into database and exported data from database to a external file
* Replicated product data between MS SQL Server 2000
* Migrated database from Sybase to SQL Server by using a utility
* Developed applications through JDBC and ODBC
* Provided the dynamic data solution for the BizTeller product, by using a mapping table and a storing table this solution allows users to add extra columns and its data into a table dynamically when the system is running
* Completed formal technical training in DB2, Oracle, Java, WebSphere, IBM AIX 5L, Tivoli etc.
Vanda System & Communications Holdings Ltd. (China) 2000-2001
Field of working: Database design and administration
Accomplishment:
* Designed and Implemented database in the debit card application system for bank of Nanjing Commerce, which was a comprehensive control and management application of banking. The system coding in C connected DB2 through CICS
* Installed DB2 on AIX and created database objects
* Administrated database and optimized application and SQL statements
* Performed trouble shooting the system and programmed stored procedures and triggers
* Developed a professional utility using PowerBuilder for replicating data from Sybase to DB2
China Financial Computerization Company (China) 1995-2000
Field of working: Database administration
Accomplishment:
* Installed Informix Online DB on SCO UNIX in the Account Examining and Calculating System for PBC (the People’s Bank of China)
* Installed Oracle DB on MS Windows NT 4.0 in the Safeguard System for PBC
* Took part in the CAP (Card Access Processor) System for the National Bank Card Switching Center. The CAP was a primary subsystem in the bank card switching system and communicated with other hosts through many kinds of protocols, such as TCP/IP, X.25, SNA etc.
* Created database and database objects for all systems
* Administrated database and tuned performance of database and application
* Performed trouble shooting problems of database and maintained database
* Completed formal technical training in IBM AIX v4.3 and Oracle
Beijing Tianwei Fuel Injection Equipment Inc. (China) 1987-1992
Field of working: Application Development
Accomplishment:
* Researched and analyzed the frame of a dBASE database file, then developed the Fuel Nozzle Management System using C, and the system manipulated the fuel nozzle data stored in Dbase directly and efficiently
EDUCATION
Master Degree in Computer Aided Process Planning
1995 Shenyang Polytechnic University
Diploma in Machinofacture Technology and Equipment
1987 Beijing Management Institute of Machinery Industry更多精彩文章及讨论,请光临枫下论坛 rolia.net