上海招聘

职位描述：
For Global Top Financial Group!!! Fluent English is necessary! Good education backgroud are required!
Division: IST
Super Dept: Internal Trade RPTG APPS
Position: DB
Description:
Position is for a senior database application DBA/Infrastructure architect on the transactional database team. The team is tasked with producing business critical transactional database systems as well as large Data Warehouses/Data Marts to meet scalability, stability and performance requirements for Trade Capture and Lifecycle Management applications within Institutional Sales & Trading. Work will include designing, enhancing and developing databases across different database environments. The job will involve considering all aspects of the project life cycle and includes proof-of-concept evaluations, coding, designing, testing, implementing, deploying, and continued support of project releases as well as on-call Level 2 support. Collaboration with the Firm?s engineering teams is expected for storage/communication solutions.

Major Roles & Responsibilities:
1. Database Infrastructure Engineering for stability and scalability, capacity planning
2. Application DBA functions: plan & execute database schema changes, bottlenecks analysis, outage prevention/resolution, server/database performance improvements, database maintenance, database recovery
3. Database development (stored procedures, ETL, tools) and queries/stored procedures review and optimization
4. Enforce database security, standards & guidelines

Skills Required:
The candidate will have the ability to propose/review innovative solutions and implement them in production to achieve significant improvements. They will be an expert in performance optimization on server, database, query, data structures and data flow levels, with advanced database architecture knowledge and hands on expertise in OLTP and Data Warehouse design, Federated database systems. They will have excellent Database Administration skills including in depth knowledge of new and existing features to provide effective solutions for critical systems. They will act as a leader in outage resolutions and multi-team global turnovers. They will be the escalation point for major issues.

Required Knowledge:
- At least years’ experience in DB2 Linux relational database work, must have exceptional hands-on application DBA skills.
- DB2 Linux version 9 and above (SQL, Temp tables, plan explains, MQTs, MDCs, referential integrity constraints, etc) - The candidate must be familiar Erwin or some similar modeling tool - The candidate must be familiar with scripting language such as Perl and Unix / K-Shell .
- The candidate must have strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts,

Personal skills: Integrity & ownership, good team player, ability to work under time and resource dependencies and constraints, ability to find simple and effective solutions, high degree of motivation to expand technical and business knowledge.

Nice to have:
- Communications skills are important as the candidate will need to work with other internal/external developers who will be accessing the databases and have change requests.
- Knowledge of other relational databases, especially solid Sybase expertise is a plus - Versioning tools such as perforce, etc.. is a nice to have
- Knowledge of the transactional database requirements of multiple financial asset classes would be a great benefit 举报 分享

about pinnacle access solutions:
平纳科（上海）信息咨询有限公司是一家美资高新技术企业。自1997年以来，已经成为it领域知名的技术服务供应商。致力于rfid的应用方面的技术研究和产品开发。在国内已经有一定的市场占有率。
公司内部为员工，我们提供舒适的工作环境；为客户，我们创造真正的价值；为股东，我们给予最高的回报。作为it服务提供者，我们的客户包括ibm, at&t, d&b, morgan stanley及 citibank 等等。
在过去的几年中, 作为一个全球性的外包服务提供商在上海的分公司，我们在不同的领域提供信息技术服务，例如，互联网技术，物流，流程管理等等。由于世界经济和市场环境的影响我们正在进行从提供技术服务到提供技术产品和相关服务的转型，并且我们正在物色能适应这种转型的各方面人才。
能取得今日的成就，一个主要原因是我们珍视每个员工做出的贡献。对于每一个雇员，我们为其提供***的工作环境，对其进行有效的培训，并不断创造机会和条件使其发挥最大的潜能。我们为员工不仅提供相当有竞争力的工作回报及福利，还不断为员工创造最好的成长机会。如果我们有幸与你共事，你将有机会与最知名的客户合作，从而学习到当今最先进的技术；同时，我们为你提供良好的培训环境。

since 1997, pinnacle access solutions, inc. has been a premier technology service provider in the it field. we provide the best working environment to our staffs, real values to our clients and highest returns to our shareholders. as an it service provider, we have an impressive list of client which includes ibm, at&t, d&b, morgan stanley and citibank etc.

one of the major reasons of our success is that we value very employees’ contribution. we reward our loyal employees by providing them the best working environment, training program and opportunity to achieve their personal goals.

in our shanghai branch, we provide information technology services in varies fields, such as, web technologies, mainframe, sap etc. as a global outsourcing service supplier, we are currently looking for talents in number of technology fields. we not only pay competitive rate, but also provide the best growing opportunities. you will have chance to learn the most advanced technologies by working with our well-known clients and being trained by the best instructor with real life experiences. you will also have opportunities to work in other countries, such as usa, japan and some european countries.