玉面飞龙的BLOG

this is a new team, and will be reponsible for whole ebay database performance planning/predict/review.

it will get great support from a global great dba team.

interested, email to binzhang#ebay.com
——————————————————————————-

Database Performance & Capacity Analyst

Primary Job Responsibilities

Reporting to the Manager of Performance and Capacity Planning, this individual will serve as a primary resource for monitoring, tuning, analysis, reporting, capacity planning and consulting on performance related issues of site production Oracle systems running on Solaris. This position is part of a team based in Shanghai, China that provides performance monitoring and capacity planning services in the Site Operations production environment. A variety of performance monitoring tools on Oracle Statspack and Unix platforms will be used to model and analyze system performance and resource usage data to: highlight existing/pending/future system bottlenecks and make appropriate recommendations for optimal tuning.

Job Requirements

•        The successful candidate will have strong communication skills in both written and oral form in English, and will be capable of explaining complex technical issues to both technical and non-technical audiences. Ability to interface with all levels of management, negotiating and influencing, to build consensus is required. The candidate should be able to take initiative, obtain required resources and cooperation of needed participants will also be necessary. Occasionally this individual will be responsible for the implementation of various programs and projects. These projects will vary in scope but will be focused around enhancements and changes to data collection, archiving, reporting and analysis.

•        The candidate needs to have a solid knowledge with Oracle internals such as latching, locking, Oracle IO, data block fundementals and index structure plus a good understanding of Solaris internals in terms of file system, process, memory, IO subsystem and CPU management.

•        The individual also needs to demonstate the ability to estimate, measure and quantify database impacts with new projects, indentify and alert inefficient SQL/design flaws, forecast mid to long term system capacity growth need and contribute to overall site availability and scalability design and improvement plans.

Basic Qualifications

- Minimum 5 years of hands on Oracle database administration experience in a  production environment.
- Unix server performance analysis and systems administration experience.
- Strong analytical and technical communication skills a must.
- Proficiency with both spoken and written English.
- SAS Programming and reporting experience a plus.
- Knowledge of queuing theory a plus
- Familiarity with HyPerformix Optimizer, Capacity Manager or Workbench a plus.
- Proficiency with Unix based tools for file and data management including sh, ksh and perl.

Demonstrated ability to:

- Analyze Statspack data to identify database bottlenecks.
- Explain complex Oracle internals to developers in easy to understand expressions.
- Identify system level issues based on variety of OS data.
- Maintain and report from large volumes of data
- Develop creative and efficient reporting techniques
- Analyze problems and think creatively to develop alternative solutions
- Evaluate cost/risk factors to make recommendations
- Communicate clearly and effectively in both written and oral form
- Organize and manage multiple concurrent tasks/duties
- Manage priorities to meet deadlines in a high-energy productionenvironment
- Understand and react to the politics inherent in organization structures
- Exercise independent judgment in methods, techniques and evaluation criteria for obtaining results

Education: BS in Computer Science or related subjects.

If you also want to be one of world’s luckiest DBA’s, send CV to me.