小石头走路队之麦当劳山 little stone team hiking mount McDonald

本次走路,计划不周,准备不充分; 但是临时应变处理是相当的成功,致使我们在弹尽粮绝,手机电尽,无导航的情况下,下午4点赶回来出发点,远远好于预计的天黑之前.

早上一觉醒来, 9:20am, 煮饺子是来不及了. 忽然想起昨天去唐朝老乡家拿的两个肉夹馍还在冰箱,烤烤匆匆吃完,9:50am.拉上邻居湖南小帅哥,急急忙忙赶往出发地点.

参加走路的人空前的少,一共三个壮汉. 穿过黄金溪露营地,顺着平坦的废弃铁路前进.
走着走着,发现不妙,水淹铁路,被迫走钢丝一般的走铁轨,由于紧张,数次踩进水坑. 过了水淹那段铁路,大家都能轻松走单轨. 感觉跟打高尔夫球一个道理,放松, Chillax.

然后就是trail导航软件把我们带到了铁丝网围墙,寻找消失的山路,开始第一次临危应变.
我们没有原路返回,而是继续前进,到达公路交叉处,有一个人(我),走到停车场,开车过来接大家,来到第二个登山出发点: Mount Wells 停车场.
而且我们明白了带叉灰线是铁丝网.

导航地图有一段像 trail 的线路,原来是 flowline , 输水管道. 只好沿着公路走向 trail 入口,狗绳也忘了带,用背包做成简易狗绳,勉强把朱丽叶牵到安全区域.

麦当劳山是走路队数年以来碰到的难度最大山路,其陡峭程度超出了 Mount Finlayson, 虽然路程短很多. 然后是果然有绳索,还是双保险,我们都在由衷的感谢修建绳索的志愿者.
中间朱丽叶上演了一段小插曲,在第二段绳索的起点,朱丽叶没能爬上去,悬在半空,着急委屈的呜呜哭了起来,意思像是说我怎么比人差呢? 从来都是我遥遥领先的. 然后就垮的一下摔了下来,一直退到第一段绳索的最低端,来回慢慢踱步,仿佛在思考什么,突然启动,一口气冲破所有障碍,顺利越过. 不由得赞叹朱丽叶跌倒爬起的勇气.
手机充电不足,错过了许多精彩的照片,下回来补上.

由于早期挫折,有点担惊受怕,原本打算原路返回. 可是又想着为下次走路做准备,三个男子翻过山头,去打探另一面下山的路.
导航软件指示可以绕圈回到停车场,4公里平路,当即决定不走回头路. 此处深山老林,少有人烟,一只黑熊从我们面前游荡蹦跳而过,大伙都在议论称赞黑熊的爬山本领,好身手.
走到一半处,有警告牌出现,同时导航地图显示有灰色叉线,完了,又有铁丝网围墙挡路,难道我们必须原路返回,此时虽未筋疲力尽,但我们已经丧失了再走一遍的勇气.
开始紧急应变,决定走过去看看,到底有没有围墙,地图上连续出现两道障碍,也没能阻挡我们冒险的勇气,终于顺利通过,长出一口气.
最最后,被水库的围墙拦住,有好心山民提示我们可以绕围墙而入. 在望着我们满脸疲惫,他还问我们想走一个小时,还是半个小时,跟我们幽默.

轻轻松松回到了停车场. 下来就是等着因为穿越禁区导致的罚单了, 路上有人提起人脸智能识别技术,再一想,我们节俭的政府才不会费劲搞这些高科技.

我们一共走了12公里,略逊于 华盛顿山 走路支队今天的17公里,该支队分流我们大批人马.
年轻队员说我们也完成了一次速度与激情.

好了,下回可以带领大家走一段精彩的环线.

为啥 Amazon 的 DBA 比较累 worn out

Q: A quick question, are Amazon DBA jobs good? I remembered you said you know them very well.

A: 我认识的亚马逊的DBA们，都走完了。

那里把人都累死球了。  在西雅图臭名昭著，员工待遇 排名倒数第一。

Q: 各位老同事，晚上/ 早上好，为啥amazon的DBA比较累，要维护的数据库系统实例多还是每个实例压力大容易出问题？还是别的原因？谢谢。

A: 李大哥兴趣这么大，鄙人就简单回答一下。

首先回顾一下去年春天，我在北京的可怜样。 人生无常，抓紧时间享乐。哈哈哈。

为什么亚马逊臭名昭著呢?

末位淘汰制。
Raising the bar. 把人往死路上逼。
许多领导向上负责，希望出成绩，向下逼迫，不知道他代表的是谁。
每周工作60到80小时。
客户第一，员工末尾，向投资人负责。 所以可以放心的购买亚马逊股票。

“要维护的数据库系统实例多还是每个实例压力大容易出问题”，
这些是次要的，却也让人受不了，一个人平均维护50个 production 数据库。
全是小学生文化水平就可以干的重复劳动，体力活。
SDE(软件工程师)设计开发的低性能数据库，全靠DBA们擦屁股。权利和责任脱节。

一个云计算AWS部门的北京小姑娘，一晚上被叫起来20次，忍无可忍，离职去了CostCo,
倍感生活舒畅，身体发福，生了两个胖小子。

现如今，从印度抓来大批廉价劳动力。公司里面90%是老印。

好了， 最好祝各位健康幸福快乐！ 有空来西雅图和维多利亚玩耍。

people skills on manager 搞好领导关系

• 关心，真心愿意帮助（态度，发自内心）。
• 目标和需求。理解并清楚明白领导心目中的整个团队的目标。
• 紧密反馈：决策，过程和结果。
• 言辞积极。

 非拍马屁式的搞好领导关系.

如何在工作生活中 高效管理时间 ~ GTD + Workflowy + Tomato

各位IT同仁好,

鄙人迟钝, GoLang 还没有修炼到可以分享的程度.

如果大伙不嫌弃, 九月份, 鄙人可以跟大伙分享一下我5年的 GTD 使用经验, 如何使用 Workflowy 和 西红柿, 在工作和生活当中 高效的管理时间.

Fyi,

鄙人的 twitter 的一些摘抄,

https://twitter.com/mujiang/status/504286423516987392

任务多，忙起来 以后，仅仅使用GTD是不够的。一定要采用 GTD 加 西红柿工作法，两者互相配合，威力暴增，工作效率和产出率陡然上升。

https://twitter.com/mujiang/status/502554862916497410

来了项目三个月，终于开始干活了。任务多，忙起来以后，GTD方法就开始显示威力了。作为GTD初中级用户，着重DRY，每天 Review 任务优先级，善用 waiting box 和 trash box.

Thanks,

Charlie 木匠 | Database Architect Developer

https://twitter.com

http://mujiang.blogspot.com/

USA telecom jobs 美国工作机会: data migration Project Manager

继续上干货.  有兴趣的请留言. 或者发邮件： dba.myra  at gmail

Rate: $80+ / hour.

If you have any friends that has very strong Project Management data migration skills? Please take a look at the job description below and let me know:

Project Manager – BSS Transformation

Ericsson/T-Mobile

Position Name: Project Manager - BSS Transformation - Testing

Status: Open

We need a strong candidate, PM who has had significant data migration skills. Please send resume ASAP. Preference would be local Seattle.

Scope of Work: 

7+ years of experience in managing complex systems integration projects.
Strong technical background with proven track record of managing complex BSS systems.
PMP certificaiton preferred.
Experience in establishing project controls to ensure controlled progress, including TEST MANAGEMENT, reporting, tolerances and governance structures.
Deep knowledge of Project Management and Quality Management concepts and principles.
Sound knowledge of telecommunication technologies and trends.
Excellent skills in Test Management is required.

6 month renewable contract (this project has plans to go through December 2015)

Location: Washington-Bellevue

Target Assessed Level: Project Manager II

Weekly Pay Rate – discussed with candidate on the phone when recruiter receive’s resume.

phishing scam your google account 新型谷歌账号盗取伎俩

最近出现了一种新型的企图盗取谷歌账号的欺诈手段, 比QQ和微信的各种手法更加隐蔽,更加恶毒. 大伙看仔细了.

貌似华人所为, 出现了江苏徐州字样.

我亲爱的华人同胞们呀,有这些聪明才智,怎么就不用到正道上呢? 为什么呢?

好了, 请看这个小伎俩的详细介绍, 谨防上当受骗.


1) 冒充 google 官方邮件发信, 告诉你有人企图登录你的邮箱. 骗取你的信任.

no-reply , 或者类似别名.

google给出了警告信息, 但是不够醒目:
This message may not have been sent by: Account@gmail.com  Learn more  Report phishing

2) 告诉你时间, IP 和 地点. 进一步骗取你的信任.

Friday, June 13, 2014 2:30:44 PM UTC
IP Address: 122.192.185.201
Location: Xuzhou, Jiangsu, China

3) 显示一个 google 风格的按钮,让你重设密码, 链接到骗子自己的网站.
链接地址里面有 google 字样, 以假乱真.
骗子的网站里面要求你输入用户名,密码,电话等等各种保密安全信息.

[Reset password] , URL: http://mail.google.ormeco.com.ph/

4) 落款还显示了google 公司地址等一堆真实的官方信息. 再进一步骗取你的信任.


* 识破骗局 *
我就奇怪了, 重设密码, 为啥还要再次输入用户名? google自己肯定知道我的用户名的邮件地址.

=======

欺诈邮件内容 屏幕截取 Snapshot :

	Hi, Someone recently tried to use an application to sign in to your Google Account. We prevented the sign-in attempt in case this was a hijacker trying to access your account. Please review the details of the sign-in attempt: Friday, June 13, 2014 2:30:44 PM UTC IP Address: 122.192.185.201 Location: Xuzhou, Jiangsu, China If you do not recognize this sign-in attempt, someone else might be trying to access your account. You should sign in to your account and reset your password immediately. Reset password If this was you, and you are having trouble accessing your account, complete the troubleshooting steps listed at http://support.google.com/mail?p=client_login Sincerely, The Google Accounts team
	This email can't receive replies. For more information, visit the Google Accounts Help Center.

You received this mandatory email service announcement to update you about important changes to your Google product or account. © 2014 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA

Seattle to Victoria trip 西雅图到维多利亚的旅行线路

应新同事的邀请,写一篇文章,介绍西雅图到维多利亚的旅行线路.

从西雅图到维多利亚（加拿大）有4条线路，各有优劣。

(一)
5号路北上,开车两小时,到 Anacortes 小镇, 搭乘华盛顿州轮渡 到悉尼市,然后开车南下到维多利亚, 坐船3小时, 开车15分钟.
步行者: $19,
连车带司机: $68,
停车费: 每天$10,

Jun 15, 2014 - Sep 20, 2014

Anacortes, Sidney B.C.
8:25  ,    11:05
2:50  ,     5:00

Sidney B.C. Anacortes
Noon ,      2:10
5:55 ,      8:30

这条线是我走的最多的一条.
可以停车在Anacortes码头, 节省船票, 早点上船,抢占联排椅子,可以一直躺着睡觉,跟火车卧铺差不多了.

2014-06-20 :

关于停车: 1,2,3号停车场经常会爆满. 私人停车场稍微便宜一些, $7,$8一天.
山坡上的备用停车场(overflow parking)很大,总有空位,也多走不了几步路.
从2号停车场南端入口,可以开上去. 还有一条trail小石子路, 从 2号停车场北端入口走上走下, 下了船,除了海关,走一会儿迎面就可以看见.

停车收费: 记住你的停车位号码, 按照停车时长, 在入口电子收费器 交钱, 可以用信用卡, 收据随身带上, 方便回来找车, 也方便以后超时补缴费.

卫星地图:
https://www.google.com/maps/place/Anacortes+Ferry+Terminal/@48.50355,-122.6781428,1148m/data=!3m1!1e3!4m2!3m1!1s0x5485790ea2748ed5:0x5c9a071494b5411f

轮渡公司网站:
http://www.wsdot.com/ferries/schedule/ScheduleDetailByRoute.aspx?route=ana-sj-sid

(二)
从西雅图市中心,一直向东,开车3小时,到达 天使港 Port Angeles 小镇. 搭乘黑球公司的私营轮渡,航行90分钟,到达维多利亚.
船上可以带狗金乘客舱.

镇上的西餐: Next door. 中餐: Tendy's Garden 自助餐, 顶饱.

缺点:船上停车位特别拥挤, 从 西雅图 到 Bainbridge Island,需要摆渡一次,等船浪费时间.

票价和时刻表:
Victoria: 10:30am, 4pm
Port Angeles: 8:20am, 2pm

Vehicle & Driver $63, Passenger $19

(三)
5号路一直向北,开车3小时,过了美加边境,和平门海关,再到Tsawwassen 小镇搭船,夏天每小时一班,航行90分钟.
连人带车 $72,
步行者: $17

缺点是海关排队时间有时候比较久.
优点是BC省轮渡公司的班次特别多,从早上7点,到晚上10点. 停车位宽敞. 船上设备精良.

Tsawwassen Ferry Terminal Parking, 码头过夜停车信息:

1.  BC Ferries : $16 / day

2. Park & go,
1406 Tsawwassen Drive
Delta, B.C. V4M 4G2
(604) 943-9991

For parking near Tsawwassen Ferry Terminal, there is a good option available. The Tsawwassen Ferry Park N' Go is a large lot located at the end of the causeway before the ferry terminal entrance. This parking lot is much larger and the rate is a flat CAD 10/24 hours. Additional hours are charged at CAD 1/hour, up to the daily maximum of CAD 10. A complimentary shuttle runs between their parking lot and the Tsawwassen Ferry Terminal front entrance.

(四)
Clipper 快艇.  不能开车. 从西雅图市中心,到维多利亚市中心, 两小时40分钟.
单程票价每人$100, 往返$180, 提前一周预订,往返大约$120.

优点是快.
缺点是贵, 容易晕船的朋友,需要经常走到二层甲板上吹冷风.

订票：http://www.clippervacations.com/clipper-ferry/

*******

从维多利亚到温哥华，有2条线路。

Swartz Bay 搭船， 车 $55, 人 $17.

奶磨市 搭船，到温哥华。

*******

西雅图到温哥华，只有一条线路，就是5号路一直北上。

BC / Seattle border wait time, 海关等待时间查询:

• Go Canada : http://www.cbsa-asfc.gc.ca/bwt-taf/menu-eng.html
• Go US: http://bwt.cbp.gov/?com=1&pas=1&ped=1&plist=3004

*******

维多利亚 的游玩推荐:

我老婆认为室内最好的景观是出海看鲸鱼. 许多外地人喜欢去宝翠花园, 去一次就够了, 毕竟是人工的.

东边

近处, 开车一小时,有 East Sooke 公园, 维多利亚该有的景色,这里都有了.
海滩,海景,山崖,草地,树林,山坡. 好像没有湖泊.

远一点, 继续沿着14号公路,顺着欢徳福卡海峡向东,有 French beach, China beach, Mystic beach.
China beach 有著名的黑沙滩.
French beach 都是粗石子.
Make Mystic Beach a perfect day trip to Victoria.
If you want to catch a taste of Vancouver Island’s wild West Coast,
but don’t have the time to make the trip to Tofino,
head out on West Coast Road past Sooke to hidden Mystic Beach in Juan de Fuca Provincial Park.

走到头,是欢徳福卡海峡和太平洋交汇的小镇 Renfrew, 住一天也不错. 尽头有个饭馆,能吃饱,宽敞温馨,有海景.  这里还有必须带小孩探索的 Botanical Beach, 著名的 tide pool, 没赶上退潮而留下的各种小动物.

北边.

近处有 Duncan市, 和 Cowichan lake 大湖周边的一些小镇子, 都非常悠闲安宁. 比如: honeymoon bay, 听着就有诗意.
可以在 B & B (bed and breakfast) 或者 motel 住一两天.

这一带最令人兴奋的游乐项目就是淡水漂流, Cowichan river. 全世界排名前十位,鄙人评选的.
水深平均约半米,偶尔会有激流冲击的深潭. 带上充气轮胎,气床,只要是能浮起来的东西 就行. 再专门带上一个冰箱,放满啤酒和大麻,一边漂,一边喝,一边吸,总共漂大约三个小时,缓缓而下,乐不思蜀.

安全提示: 下游有悬崖激流, 早几百米就开始有多处警告牌,赶紧上岸,小命要紧.

更详细的漂流介绍, 可以参考 开吻 的博客. 链接在右上角.


温哥华岛:

西边: Tofino 太平洋西海岸国家公园: 听涛观海浪, 还有十三公里长的细沙粒沙滩, 大片温带雨林, 4号公路,路过几个巨大的湖泊.

北边: Parksville 和 Qualicum Beach. 大片的浅水温暖沙滩.

最北边, 开车550公里, 小镇port hardy, 只有5000人, 规模却很大, 还有著名的野生黑熊公园 Cape Scott.
北端西头, 有小镇 Port Alice, 翡翠上的珍珠, 一定要去住两天, 在饭馆喝着茶,就可以看到海峡里面的鲸鱼喷水,海豚跃出水面. 珍贵的原始生态.
小镇唯一饭馆的香港华人老板娘叹息三个孩子不善经营餐馆,远走高飞. 她总想让我继承她家的大业, 不知怎的就看中了我做接班人, 颇为有趣.
他们家经常夏天出海钓鱼,给我描绘鲸鱼围扑三文鱼的宏观场景,邀请我同去,总是没机会(找借口), 各种石斑鱼,鳕鱼味道好极了. 东南亚人少,华人少, 这里很容易钓到又大又鲜美的生猛野生螃蟹.

如果看官您恰巧夏天路过 Port Alice, 我可以介绍您给餐馆老板.

Q&A

Q: 需不需要预订船票?
A: 如果赶时间,一般都需要预订,悉尼这条线路不多收预订费. 其它航线需要多收一二十块钱的预订费.  步行者不需要预订.



未完待续...


Thanks,
Charlie 木匠

USA telecom jobs 美国工作机会+获取绿卡: 电信计费业务专家

-=-=-=-
咱直接上干货.  有兴趣的请留言. 或者发邮件： dba.myra  at gmail

1. 美国工作机会+工作签证+绿卡: 电信计费业务专家。 特别适合中国大陆人士 来美国。
Rate: $80+ / hour.

雇主提供 H1b 工作签证， 远程电话面试。

Contact me you or your friends resumes that have System Integration Systems experience in Telecom Billing and Order Management Systems from China.

Billing Transformation Senior Solutions Architect.

Ericsson is the world's largest telecom services provider, supporting operators in creating competitive, attractive and appealing offerings to consumers. Our technology leadership, business understanding and extensive experience of managing telecom and IT projects make Ericsson the market leader in telecom services.
The key to our success is our people, those who have the right mindset, competence and ability to achieve our business objectives. What we look for are employees who are customer focused, have a consultative and entrepreneurial mindset and take great pride in customer satisfaction. We value accountability, flexibility, a sense of urgency, strong team work and the ability to adapt to changes and take ownership.

The Ericsson BSS CSI Organization works very closely with Engagement Practice and Customer Units. We help drive sales strategies and manage solution design and delivery.
The BSS CSI Organization provides high value services in the areas of BSS Transformation Programs, Convergent Charging, Billing, and Customer Relationship Management Solutions. Within these areas we deliver product-near and product-far CSI services.
The team’s mission is to grow revenues in BSS by transforming Ericsson’s business into the System Integration and Consulting domain.
As a BSS Transformation Solution Architect you are part of a CSI Organization in Region North America responsible for Presales as well as Delivery of Business Support System (BSS) and IT solutions and services across all industries.

Objectives:

This is a position as a Senior Solution Architect for Business Support Systems (BSS).
The successful candidate should be a natural leader capable of building and growing customer relationships at all levels. As a member of the BSS team you will be a leading figure in the Service Delivery capability for Region North America (RNAM).
A background in System Integration and sound experience in the Solutions Architect role for BSS solutions is essential to this role. Superior interpersonal and communication skills with the ability to communicate at all levels are an absolute must. The candidate must have strong leadership, organizational, and strategic skills, as well as a dynamic and engaging personality.

The successful candidate will direct, coordinate and administer pre-sales and delivery opportunities. This includes:

• Actively support the sales and delivery of billing transformation engagements, working with the Customer Units and Engagement Practice organizations.
• Be responsible for the IT systems architecture for large-scale billing transformation projects in complex BSS environments.
• Manage solutions with new and existing multi-vendor BSS products for all types of service providers including wireless, wire-line, cable, or utilities. 
• Work with the customer to develop a vision for billing transformation.
• Respond to RFIs and RFPs, and ensure quality and consistency of scope, and cost estimates.
• Map business requirements to functionalities, perform gap analysis and provide solutions for customer business requirements.
• Scope the project and engineer the desired solution.
• Drive transformative consulting engagements.
• Act as the technical lead for solutions, with a high level of Customer interaction and co-ordination with Product Development Units, Operations & Competence Centers and the Customer Technical and Marketing Teams.
• Lead the project and manage and guide teams as Customer Solution Responsible (CSR).  
• Drive BSS CSI services business across the telecom and IT domain. 
• Engage in on-site consulting for BSS system integration projects and ad hoc consulting assignments.
• Establish a solid relationship with the customer aimed at increasing Ericsson credibility as the primary partner for delivering transformation programs and in doing so clearly articulate the scope and benefits that would be delivered.
• Find new business opportunities based on expanding existing customer solutions as well as creating new ones.

Qualifications:

• BS or MS in Computer Science, or Computer Engineering or acceptable equivalent.
• Over 10 years of IT experience designing and integrating telecom BSS solutions related to Billing, Customer Relationship Management, and Order Management.
• At least 5 years of experience implementing solutions involving BSCS or Amdocs as Billing Platform.
• Any other deep knowledge of COTS billing platforms is an advantage.
• Strong understanding of BSS components and integration with other systems.
• Understanding of operational and maintenance issues related to billing systems.
• Strong knowledge of telecom billing processes and standards for wireline, wireless providers is a must.
• Good knowledge of cable service providers is an advantage.
• Ability to drive large scale complex business transformations with processes, solutions and operations.
• Experience with Business Process Definition and Re-engineering.
• Established experience and good abilities to communicate and articulate value propositions at customer C-Level.
• Have the technical expertise to be recognized by the operator as an authority figure.
• Have the Experience, Ability, Professional and Business Skills to operate comfortably in some of the largest and most strategic business deals Ericsson will have in RNAM.
• Experience in consulting, business systems analysis, end-to-end solution design, development and implementation of large-scale integrated systems.
• Knowledge of eTOM, NGBSS, TAM, ITIL, TOGAF and SID framework for designing solutions for service providers.
• Knowledge of 3GPP standards; CAMEL, Gy, Ro, Sy.
• Charging mechanisms for emerging technologies: IMS, LTE, VoLTE, M2M
• Data charging and policy control
• Offline roaming mechanisms, TAP/RAP etc
• Product catalogue integration
• Experience working with Billing Systems and CRM systems for a wireless carrier is a plus.
• Experience with Mediation or Prepaid platforms is a plus.

Product Knowledge:

The more knowledge from the following list of Ericsson /vendor products the better and is a clear advantage:
• Ericsson MultiMediation, Comptel Mediation or other
• Ericsson BSCS billing alternatively Amdocs CES or Ensamble
• Convergys Billing
• Ericsson Charging System
• Ericsson Mobile Broadband Charging
• Ericsson Charging & Billing in One

Required Personal skills:

• Exceptional Customer Orientation and Consultative Skills, Consultative Selling Ability. 
• Exceptional Communication skills (Presentation, Interpersonal and Influencing Skills). 
• Establish and maintain a solid relation with key BU and DU contacts and provide feedback to R&D.
• Excellent oral and written English skills.
• Ability to lead and motivate others and work in a team environment.
• Problem Solving Ability and Creative Thinking.
• People-, Team work and collaboration skills. Ability to take a leadership role and lead a team and work under stressful situations, meet tight deadlines and deliver services with high quality. Previous track record within Project Management or Team Leadership experience is a definite advantage.
• Broad Technical Acumen.
• Knowledge of market insight and competitor intelligence.
• Financial Understanding

Looking forward to hearing from you. 

Thanks,

Charlie 木匠

first day in Bellevue/Seattle 西雅图贝勒府上班第一天

第一天上班，一片混乱，主要是生活安排方面有点乱。
(更新：找到两个合适的住处，下午下班以后搬家)

开吻比我从容多了。

再说说好的一面，工作不错，领导宽松，好相处，同时融洽，人事部友好，乐于帮助
公司也不错。比以前极度抠门的公司大方多了，舒服。

和新领导已经 1o1 一小时了。 一个好领导，比啥都重要。 理解，倾听，心态开放.

我每两周跑一趟。 比开吻好些，他一边跑，找了个一千块钱的特价机票，就高兴的不得了。要知道，现在加拿大温哥华到中国的往返机票才六七百。

能够在微信谈这么久，说明比上一家公司 Myra. com 还轻松 淡定 有条不紊。
我的第一个任务是学习和探索如何在Oracle数据库和Hadoop之间移动数据。

Canada income tax 加拿大人上缴多少税?

加拿大人的收入税比对表

 一，联邦税：

    第一级：$42,707以下，交15％；
    第二级：$42,707－$85,414，交22％；
    第三级：$85,414－$132,406，交26％；
    第四级：$132,406以上，交29％。

    二， 每个省的收入税略有不同，一般在联邦税的一半以下，以BC省为例，共有5级：

    第一级 : $37,013以下，交5.06％；
    第二级 : $37,013－$74,028，交7.7％；
    第三级 : $74,028－$84,993，交10.5％；
    第四级 : $84,993－$103,205，交12.29％；
    第五级 : $103,205以上，交14.7％。

    以一个典型的单身打工族为例，看看不同年薪在BC省需要交的收入税：

    3万年薪需交联邦税$4,500,省税$1,518,共$6,018；
    5万年薪需交联邦税$8,010,省税$2,873,共$10,883；
    10万年薪需交联邦税$19,594,省税$7,718,共$27,312；
    15万年薪需交联邦税$33,122,省税$14,990,共$48,112.

    2013年加拿大报税政策又有了一些细微变化。联邦政府 宣佈，从2013年1月1日开始，个人免税储蓄帐户(TFSA)每年的免税额由原来的5000元每年提升至5500元。对于大多数加拿大人来说，他们的 CPP可领取最高数额可以每月增长25.83到1012.50元不等，或者每年增长12150元，而OAS福利金，按季度调整，每月可从1.09调升到 546.07元。

2013年部分税额调整表：

项目      2013年  2012年
个人免税额 $11038 $10822
长者免税额 $6854 $6720
配偶免税额 $11038 $10822
薪资抵扣额 $1117 $1095
残障抵扣额 $7697 $7546
孩童扣抵额 $2234 $2191
亲人抚养额 $4490 $4402
净入息限额 $6548 $6420
残疾儿童补贴 $4490 $4402
最低收入门槛 $3333 $3268

图解：加拿大各省收入税+销售税大比拼

收入税：联邦最黑拿大头；安省和BC省对8万下收入最有利，5%--9%；阿省对富人最有利统一10%；魁省最坑爹：穷人也要交16%，10万就交富人税。

销售税：魁省，NS和王子岛15%；安省，NB和NL省13%；卑诗（B.C），曼省12%；萨省10%；阿省和北极3个特区无省税，只交5%GST。

蒸馒头 Chinese steam bread

鄙人蒸馒头的名气越来越大，名声远扬，多次被叫到朋友的家里现场操作。

索性写篇文章，分享鄙人每次100%成功蒸馒头的秘籍。

* 准备酵母菌:
40℃温水，50ml, 白糖一匙(teaspoon)，发酵粉yeast两匙(teaspoon),搅拌均匀，放入烤箱，40℃，生长10分钟。

* 准备面粉:
面粉900ml, 冷水450ml, 倒入长好的酵母菌，和面。可以用筷子搅均匀，揉成一整团就行了，放入烤箱，40℃发酵一小时。

* 揉面:
均匀撒上干面粉，用手掌压，折叠，再压，...，大约5分钟。压出气泡。
切成小块，揉成馒头形状，二次发酵20分钟, 室温即可。
然后放入蒸锅。

* 蒸:
大火8分钟，
中火8分钟，
关火以后，盖8分钟。

好了，香喷喷的馒头出锅了。

简单吧？ Simple is beautiful !

Any questions please let me know.  有问题，请留言。

SQL Techniques 周六维多利亚 IT Club 分享

首先祝各位 马年健康快乐，马上来钱，马到成功，龙马精神，万马奔腾, 春风得意马蹄疾。

公告板：

SQL Techniques 周六IT Club分享
________________________________
时间: 1月18号 星期六 下午2点半
地点: 2121 Cedar Hill Cross Rd. EBC church second floor meeting room.

主讲人: 木匠

本次主题是: SQL Techniques.

去年春天回中国，得了一场怪病，颓废了大半年。
终于康复了70%, 赶紧回来跟大伙分享数据库知识, 为社区做贡献。

欢迎前来捧场。

Agenda

What do you need to write “good” SQL

The Schema Matters

Knowing what is available

Using rownum (yes, to 'tune')

Scalar subqueries

Analytics

Some hints

Don’t tune queries!

Other things

Materialized Views

With subquery factoring

Merge

…

Access Paths

There are a lot of them

There is no best one (else there would be, well, one)

A little bit of physics

Full scans are not evil

Indexes are not all goodness

How the data is managed by Oracle

high water marks for example

IOT’s, clusters, etc

What your query needs to actually do

Is that outer join really necessary or “just in case”


Thanks,
Charlie 木匠 | Database Architect Developer

将数据处理逻辑SQL放在数据库后端的存储过程到底好不好? data logic SQL in Database vs in Web Application server

将数据处理逻辑放在数据库后端的存储过程到底好不好? @诸超_小石头爸爸 是反对的, @OracleAskTom 是坚决推广的.这一点,我和Tom站在一边. 希望有一天和ChaoPing兄弟来个辩论会,互相学习到有益的经验. 两个人辩论肯定比一个人讲更有意思,更能吸引到听众的注意力.

把问题具体细化一下. (data logic)SQL放在哪里?
追加一个细化条件: 99% 纯SQL, 基本没有CPU运算 的 数据处理逻辑.

关于如何区分 UI, business logic 和 data logic :
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:5662105500346364576

先谈谈我的亲身体会.

案例 1,

当今社会,网络成为瓶颈的机会很大. 我们有个登录事务,4个简单SQL,查序列号,删除旧曲奇,插入新Cookie,COMMIT.一共四次网络传输,如果改成存储过程,只需要一次网络传输,网络立刻畅通. @yong321 @诸超_小石头爸爸 你们怎么看?

案例 2,

十年前, Java developer写了一个客户订单查询系统, 没有做分页处理, 随着时间的推移,用户数据量越来越大,查询响应时间越来越长,极大的浪费了数据库资源. 可是开发人员不对数据库负责,总是提不上他们的议事日程.
这是一个简单而至关紧要的关于控制权和责任的问题, Control and Responsibility.
Facebook说了, Control and Responsibility是他们成功的最重要因素.

参考文章: Scaling Facebook to 500 Million Users and Beyond
http://www.facebook.com/note.php?note_id=409881258919

案例 3,

在我们的好多关键业务模块,同一条一模一样的SQL被执行了好多次,连绑定变量值都是一样的.
Java developer非常依赖ORM, 而且懒得写SQL,或者草草了事,不在乎或者不知道SQL的执行效率.
同上一个案例一样,除非该模块导致数据库停机,他们懒得修改,也不负责任.

相对来说, Java developer写出的SQL要比数据库专业开发人员写出的SQL效率低二到十倍.
(因为鄙人经常能够经过重新设计一些功能模块,提高数据库处理效率五到数十倍)
所以,很多情况下,你根本就不需要水平拆分split, 一个新的优化的设计,就帮助你解决扩展性问题.
还节省了购买新软硬件的成本,降低了因为拆分导致的系统复杂性.

补充一点, 就算是拆分了以后, 你依然可以调用后台存储过程, 中间件应用服务器只需要做一个分发调度器就可以了. 某书店的工作流软件就是这么实施的,大概拆分出十多个数据库.

案例 4,

接着 案例1 的上下文, 其实前3个SQL可以简化成一个SQL INSERT,就解决问题了,
取序列号可以省掉,替代主键索引可以省掉, DELETE可以省掉, 查询配合B+树索引 +INDEX_DESC hint, SELECT 取最新的一条记录就行了, 逻辑读恒定,不会随着数据的增长而增加. INSERT比UPDATE/DELETE引发更少的阻塞锁.
Java developer一般不在乎或者不知道高效SQL,也不是非常了解数据库是如何工作的.
而且他们控制了代码,又不对数据库的问题负责任, 这个, 很难...很难!  这个就是普遍的现实,我们不能活在虚幻当中.
所以要着手解决现实问题. 由数据库专业人员来控制数据库存取的SQL代码.

备注:

@yong321 要求拿出Profiling数据,证明网络是瓶颈.
这一点很好, Critical Thinking: Be critical to what you hear and read. "Critically Analyze What You Read and Hear" 要的就是积极主动的分析思考, 批判性学习. 而不是被动的接受信息.
我们有完整的 Profiling 数据, 剔除敏感信息以后, 性能剖析分析矩阵会被补充进来.

@诸超_小石头爸爸 建议用匿名PL/SQL块(Anonymous PL/SQL block), 也能减少网络传输, eBay就是这么做的.

反方意见:

@诸超_小石头爸爸: 关于业务逻辑作为存储过程数据库里面:如果database不需要licemse我不反对，如果database和app一样容易scale我不反对，如果我是oracle vendor我不反对。如果是传统企业或者很小业务我不反对，如果注定做不大或者就是尝试快速试错我不反对。如果没有7+24的可用性要求我不反对。如果 (11月4日 22:40)

@推车老王: 把业务逻辑放在数据库中？不谈别的，从可扩展性来说是增加APP服务器方便，还是split数据库方便？根本就没有可比性啊！从系统运维角度来看，系统规模越大，业务层与数据层分离就越重要。

@刘德伟goodxp:赚钱不等于正确。没听过技术债吗？欠了多少没人知道，我面试时就遇见过编个理由离开原公司的，因为已经搞不起了，老总还当功臣留他。存储过程效率高，但很难维护，如果逻辑复杂还是应该放在Daemon里，数量多的话可以考虑做一个业务规则引擎。


@yong321:I agree with 推车老王 and 刘德伟. If logic is or will be complicated, it's better stored at app layer; easier to scale up and make it OO (if needed). Otherwise, put it whichever has free CPU capacity.


各位老大说了: It depends.
一定要根据自身条件,设计出能够解决自身问题的合适方案.

这些反方意见对我们目前的情况来说,都不是问题. 我们目前最大的问题就是命名规范. 如何简洁明了的把相关功能特性组织在一个模块里面,使重用最大化.

欢迎各位看官猛烈评论, 给出积极的建设性意见.

-木匠, 2012年冬天

职场软技能 Soft skill

职场软技能-周六 维多利亚 IT Club 知识分享

时间: Saturday (Nov 17) 2:30pm
地点: 2121 Cedar Hill Cross Rd. EBC church second floor meeting room.

Soft skill. by Neil Han.

本次主题是: 职场软技能, 及如何与老板谈判加薪.

Neil今天带给我们的[软技能]知识分享,那是相当的精彩和实用, 鄙人还要再揣摩揣摩,进而结合实践. 

• take control 行动,并且多走一里路. (一个球友说: 我妈妈讲了,如果让别人控制你的情绪, 你就是失败者)
• win win (太深奥. 如果不知道怎么做, 直截了当的问对方: 怎样才能让你受益和获利)
• understand before to be understood. (listen, 继而融洽合作)

以上三点来自 高效能人士的七个习惯

(赶紧做笔记, 外加个人体会, 不然明天就会忘记一半).

希望明年再来一次,弥补一下那些不能够来的人的缺憾.

华人软技能好的都在中国发展了; 出来靠做技术吃饭的, 厚黑学功底太弱.

谢谢Neil的精心准备和流畅的演讲.

最近工作稍忙, 没有来得及在华枫网和BBS上门预告. 不然, 会有更多的人受益.

- 木匠

2012 Vancouver DBA job 温哥华数据库管理员工作机会

一个待遇比较好的工作机会. 却是在赌博行业,被一个1997年离开中国甲骨文的维多利亚的老朋友深深的鄙视着.  ;)
2006年的时候,这个职位给110k基本工资, 现在应该更高了. 全看你个人的薪水谈判能力. 

如果需要学习提高如何谈判薪水的能力, 看这里: 

http://blog.wenxuecity.com/myblog/40440/201108/7295.html  -- 职场人心：谈判薪水的艺术

职位描述如下:

Client Location: Vancouver
Duration: Permanent
Contact:  博客留言, twitter留言, 或者给鄙人发邮件.

Job Description:
As a member of the development DBA team, you will be responsible for
the Oracle database platform central to our software applications and
Data Warehouse/BI platform. As a technical leader with a strong
delivery focus, you will collaborate with all levels of the
organization including software and quality assurance engineers to
deliver software that is highly available and scalable.

Responsibilities:
-Collaborate with data and application architects to determine the
appropriate logical and physical architecture, including table
layouts, indexes, data, storage schemes, etc. for OLAP environments
-Contribute to development of data warehouse from analyzing business
requirements to development of design, ETL code development and
testing using standard and in-house ETL tools
-Technically assess current infrastructure, design and implementation
of scalable platform to support growing demand of users and processes.
-Facilitate database design and development through liaising with
individuals across functional departments to gather knowledge and gain
a strong understanding of all enterprise systems and business
processes.
-Understand business change requests and how to manage stakeholders expectations
-Communicate objectives and approaches with a variety of audiences
including: business stakeholders, executive management and technical
teams.

Additional Job Info:
Qualifications
-Expert knowledge of data warehousing on Oracle 11g/Unix platform (at
least Oracle 10g) -Hands-on and proven leadership experience in
designing and building enterprise portal, reports and analytics with
professional report building software packages -Experience with
JasperSoft BI Suite or other business intelligence software is
required -Must have a high comfort level with report terminology and
concepts such as drill-down, roll-up, aggregation, cross-tab etc.
-Experience with in-house developed or off-the-shelf ETL tools -Expert
knowledge and experience in writing complex SQL and PL/SQL code
-Ability to write Technical specifications, presentations, training
materials, user documentation, and technical documentation -Proven
ability to demonstrate initiative, take responsibility for timely
delivery and ensure customer satisfaction  Software is a world leader
in online interactive technologies, bringing life to the e-gaming
experience of thousands of users daily.  is an Agile software
development shop using Agile Scrum methodologies with a number of
cross functional teams focusing on the design, development, testing
and implementation of our expansive software product suite (listed at
www..ca). We are currently growing our team and have an opening for a
Development DBA. Founded in 2004,  is comprised of the best and
brightest professionals from a wide variety of disciplines, including
software development, quality assurance, database administration and
product management. The company culture is dynamic, contributing to an
employee experience of fun and creativity!

Top 3 Skills (stack ranked) :
1. Dimensional Modeling 2. ETL 3. Oracle

Work Environment (culture, deadline intensive, flexible hours, dress code) :
Very deadline intensive, fast paced environment. Not your typical
gaming environment - a little bit more on the conservative side, but
still a very young, keen, motivated group, who work together in a
collaborative AND team-driven fashion. Business casual dresscode,
relatively flexible hours.

Business Challenge Client is Tasked with Solving :
Software manages 12 Product lines, with consistent upgrades on the go
for at least 6 of them, at any given time. Their 3 largest products
are: eCommerce, Management Tools, AND Casino.  runs some of the
highest traffic websites in the world. Downtime or crashes in the
system due to scalability issues or defects is not an option. A
non-functioning gaming site could cause a massive loss in revenue and
customer loyalty.

Who is the Internal/External Customer? (i.e., end-user or end-client) :
The external customers are the participants who play 's online games.
The internal customers are those at  (developers, marketing, etc.) who
use the information from the databases.

Impact to the Internal/External Customer? (i.e., how does the
end-users job become easier?) :
By having a DBA, they can liase with other groups at  in order to use
the data and information to benefit the organization in order to
create a wider variety of quality gaming platforms and a stable,
secure ecommerce system for end customers transactions.

Project Stage/Lifecycle Info :

Technical Environment :
Oracle, Java/J2EE, Jaspersoft BI Suite, Apache, VMware, TestComplete)
and a number of web and open source toolsets/technologies such as
JMeter, Maven, Hudson Continuous Integration, Subversion, CentOS,
JBoss, Spring, ActiveMQ , HTML5, etc.

Non-technical Skills (i.e., communication, problem solving, etc.): :
- Strong verbal and written skills, and an ability to present within a
small team - Mature, professional demeanour and work habits -
Resourceful, ‘can-do’ attitude, ability to identify potential problems
early and make decisions - Excellent troubleshooting skills - Ability
to work under minimal supervision - Strong team-oriented attitude -
Must be flexible in nature, a proven problem solver, and possess a an
ability to mentor - Strong desire to break software in a creative, but
controlled manner

EVP (why would someone take this position?) :
At  you will be working with a great blend of best-in-class enterprise
technology (e.g. Oracle, Java/J2EE, Jaspersoft BI Suite, Apache,
VMware, TestComplete) and a number of web and open source
toolsets/technologies such as JMeter, Maven, Hudson Continuous
Integration, Subversion, CentOS, JBoss, Spring, ActiveMQ , HTML5, etc.
Long term, permanent employment, with lots of opportunity for
advancement AND career progression. Great location, with exceptional
benefits, vacation and the promotion of work/life balance. Our
innovative approach to technology, our outstanding perks and benefits
and our amazingly talented employee base make  Software one of the
best companies to work for in Vancouver.


Thanks,

Charlie 木匠
=======
Database Architect, 汉唐 田园牧歌DBA
https://twitter.com/mujiang