Responsibilities職責(zé)
???Set?up?and?optimize?high-availability?and?clustering?solutions建立和優(yōu)化高可用性和集群解決方案
???Manage?vendor?datasets?(pricing,?security,?fund?performance,?economic)管理供應(yīng)商數(shù)據(jù)集(定價(jià)、安全、基金業(yè)績、經(jīng)濟(jì))
???Performance?tuning?for?SQL?Server?stored?procedures,?functions,?views,?SSIS?packages?and?SSRS?reports?SQL?Server存儲(chǔ)過程、函數(shù)、視圖、SSIS包和SSRS報(bào)告的性能調(diào)優(yōu)
???Participate?in?enterprise?wide?security?audits參與企業(yè)范圍內(nèi)的安全審計(jì)
???Ensure?SQL?data?assets?are?available?for?use?by?applications確保SQL數(shù)據(jù)資產(chǎn)可供應(yīng)用程序使用
???Assists?in?the?design?of?data?models?and?physical?databases,?data?dictionaries?and?schemas協(xié)助設(shè)計(jì)數(shù)據(jù)模型和物理數(shù)據(jù)庫、數(shù)據(jù)字典和模式
???Installs,?upgrades?and?tests?database?software安裝、升級(jí)和測試數(shù)據(jù)庫軟件
???Monitors?database?environment監(jiān)控?cái)?shù)據(jù)庫環(huán)境
???Monitors?database?growth?and?activities監(jiān)控?cái)?shù)據(jù)庫的增長和活動(dòng)
???Manage?development,?QA/UAT?and?production?environments管理開發(fā)、QA/UAT和生產(chǎn)環(huán)境
??
??Qualifications任職資格
???Bachelor's?degree?in?an?IT?field?related?to?database?administration數(shù)據(jù)庫管理相關(guān)IT專業(yè)學(xué)士學(xué)位
???A?minimum?of?five?years?of?full-time?SQL?Server?Database?Administration?and/or?Engineering?experience至少5年全職SQL?Server數(shù)據(jù)庫管理和/或工程經(jīng)驗(yàn)
???Knowledge?and?understanding?of?MSSQL?High?Availability?and?Disaster?Recovery?options?and?where?those?technologies?would?apply?to?fill?a?requirement了解MSSQL高可用性和災(zāi)難恢復(fù)選項(xiàng)，以及這些技術(shù)將應(yīng)用于何處以滿足需求
???The?ability?to?troubleshoot?and?resolve?database?performance?problems?using?native?monitoring?tools能夠使用本地監(jiān)控工具排除和解決數(shù)據(jù)庫性能問題
???Experience?with?Windows?Server?and?the?proper?disk?configuration?and?layout?to?support?large,?scalable?SQL?Server?environments具有Windows?Server和正確的磁盤配置和布局經(jīng)驗(yàn)，以支持大型、可擴(kuò)展的SQL?Server環(huán)境
???Basic?knowledge?of?Reporting?Services?and?scale-out?SSRS?farm?configurations具備Reporting?Services和橫向擴(kuò)展SSRS場配置的基本知識(shí)