新足迹

 找回密码
 注册

精华好帖回顾

· 我最喜欢的牛仔裤 (2005-6-27) 小米 · 菜菜菜鸟之新规则今日Carlton一次路考通过记! (2008-8-15) 珂儿朵朵
· 传奇(八楼更新,九楼大结局) (2010-11-10) 明河素月 · 参赛-东北人的春节,小鸡炖蘑菇 + 凉拌拉皮 (2007-2-21) powermao
Advertisement
Advertisement
查看: 4119|回复: 13

[VIC/TAS] 一个SQL DBA工作,中级水平 [复制链接]

退役斑竹

发表于 2013-2-18 19:40 |显示全部楼层
此文章由 月亮 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 月亮 所有!转贴必须注明作者、出处和本声明,并保持内容完整
* Develop and maintain the structure of data including performance, subscription, ticketing and season codes for Box Office, promo codes for Marketing and fund and campaign codes for Development;  * Perform quality control audits to ensure accuracy and completeness of data  * Manage user profiles and security for the Tessitura database  * Coordinate with the Interactive Marketing Manager on all data-related issues related to the website * Analyze the database health and maintain all necessary logs and backups and disaster recovery * Assist in the internal promotion and use of Tessitura, including the coordination of training, webinars and formalising documentation * Be primarily responsible (in collaboration with the Project Manager) for administering, maintaining and developing the Tessitura system; * Manage priorities and demands of constituents/users to provide excellent service * Provide day-to-day support and maintenance with particular focus on Box Office, marketing and development functions  * Create and maintain documentation and Tessitura standard operating procedures for all users  * Gain a thorough understanding of database API procedures for web * Troubleshoot technical issues  


SYSTEMS ADMINISTRATION * Work with the Tessitura Leaders Group to discuss and prioritize projects such as custom reports and upgrades * Coordinate with staff, Tessitura, and third-party vendors regarding periodic upgrades and enhancements, systems analysis and testing and troubleshooting  * Serve as an organizational representative with Tessitura and Tessitura user groups.  * Provide decision-making support to management and assist in formulating solutions to problems and objectives * Take responsibility for data integrity, including overseeing de-duplicate processes and data cleansing practices; * Conduct regular audits of database content; * Support the administration and coordination of marketing campaigns and special offers, including the coordination of the data extraction processes * Undertake analysis of data to provide customer insights and other information that assists in the various processes of the organisation;

REPORTING AND

ANALYSIS * Develop and provide analytical reports, lists and extraction sets as required by users, including custom reports, stored procedures and custom views using Microsoft SQL Server, SQL Server Reporting and Analysis Services and other Tessitura system tools  * Verify and report on data integrity  * Perform ad-hoc SQL queries  * Assist in analysis of current and historical ticketing and fundraising transactions  * Evaluate and respond to user needs, solicit enhancement requests for system functionality and reporting  * Write SQL scripts to manipulate the database and produce customized reports * Stay abreast of industry standards and best practices.

OH&S * Work with management and other team members to ensure that all occupational health and safety (OH&S) risks are minimised through awareness and application of safe working practice.  

OTHER * Demonstrate an interest and engagement with the MSO product; * Behave in a manner consistent with MSO values; and * Carry out any other associated duties as reasonably requested.


工资70k base,在MEL city,喜欢的同学发简历给中介:Brendan Sweeney   brendan@dubconsult.com

评分

参与人数 2积分 +11 收起 理由
namu + 3 感谢分享
steveking + 8 感谢分享

查看全部评分

Advertisement
Advertisement

发表于 2013-2-20 11:56 |显示全部楼层
此文章由 飞飞鱼 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 飞飞鱼 所有!转贴必须注明作者、出处和本声明,并保持内容完整
支持传递正能量!

发表于 2013-2-20 11:57 |显示全部楼层
此文章由 马秋尹 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 马秋尹 所有!转贴必须注明作者、出处和本声明,并保持内容完整
DBA Dev 70K似乎少了点吧?

发表于 2013-2-20 12:00 |显示全部楼层
此文章由 realfenglin 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 realfenglin 所有!转贴必须注明作者、出处和本声明,并保持内容完整
马秋尹 发表于 2013-2-20 10:57
DBA Dev 70K似乎少了点吧?

不错了,最近行情一般
不管怎么变,只有一点不变:永远都是穷人先倒霉!!!

发表于 2013-2-20 19:13 |显示全部楼层
此文章由 keys 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 keys 所有!转贴必须注明作者、出处和本声明,并保持内容完整
进来领行情的, 70k确实不多啊

发表于 2013-2-21 10:06 |显示全部楼层
此文章由 namu 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 namu 所有!转贴必须注明作者、出处和本声明,并保持内容完整
想搞dba,可惜经验不足啊,只是在开发中用过多年db
Advertisement
Advertisement

发表于 2013-2-23 12:34 |显示全部楼层
此文章由 yiyioz 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 yiyioz 所有!转贴必须注明作者、出处和本声明,并保持内容完整
谢谢分享。。。

发表于 2013-3-13 22:12 来自手机 |显示全部楼层
此文章由 huaxianz 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 huaxianz 所有!转贴必须注明作者、出处和本声明,并保持内容完整
我碰巧今天也接到这个人的email了,在linkedin上。不过不是这个工作。

发表于 2013-3-27 21:53 |显示全部楼层
此文章由 hwan30 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 hwan30 所有!转贴必须注明作者、出处和本声明,并保持内容完整
除了工资和养老金,有其他福利吗?譬如奖金什么的?

发表于 2013-3-27 21:55 |显示全部楼层
此文章由 liushui0729 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 liushui0729 所有!转贴必须注明作者、出处和本声明,并保持内容完整
版主是女生?

退役斑竹

发表于 2013-3-27 21:59 |显示全部楼层
此文章由 大饼 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 大饼 所有!转贴必须注明作者、出处和本声明,并保持内容完整
算了,我就不重操旧业了.
Advertisement
Advertisement

发表于 2013-4-1 14:47 |显示全部楼层
此文章由 mileswei2012 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 mileswei2012 所有!转贴必须注明作者、出处和本声明,并保持内容完整
DBA 需要足够经验的。

发表于 2013-4-16 19:23 |显示全部楼层
此文章由 iamawitch 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 iamawitch 所有!转贴必须注明作者、出处和本声明,并保持内容完整
it is a hard job, i cannot do it
anybody is business analyst??
i am BA

发表于 2013-4-17 23:52 |显示全部楼层
此文章由 huaxianz 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 huaxianz 所有!转贴必须注明作者、出处和本声明,并保持内容完整
iamawitch 发表于 2013-4-16 18:23
it is a hard job, i cannot do it
anybody is business analyst??
i am BA

晕倒
DBA和BA不挨边儿啊

发表回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则

Advertisement
Advertisement
返回顶部