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