SQL Database Developer 資料庫設計師 (MS-SQL)

希格斯資訊科技有限公司

Job Description

1. 熟稔T-SQL及SP編寫。 
2. SQL Server In-Memory OLTP 開發經驗
3. 確保資料庫系統性能優化。 
4. 資料庫異動維護服務執行。 
5. 資料庫系統規劃、設計、建置(具DB HA架構建置和維護經驗-AlwaysOn)。 
6. 資料庫管理(SQL Server 2016/2017、NoSQL等)、日常維護、監控、故障排除。 
7. 資料庫備份管理、災難復原。 
8. 解答客戶及同事資料庫相關問題。 
9. Support, maintain, and document software functionality

Primary Responsibilities, 
• Microsoft SQL Server focused and proficient with SQL server 2017. 
• Database installation and HA (cluster, AlwaysOn, log-shipping, replication) configuration. 
• Database backup/recovery, upgrade/migration. 
• Database monitoring, server performance tuning, SQL tuning. 
• 4+ years experience working as a SQL Server developer. 
• Proficiency with schema object development ( table, index, stored procedure, trigger, function, partition ) .
• Proficiency reading SQL execution plan and being able to optimize SQL and indexes design. 
• Proficiency with troubleshooting performance issues (example: slow query, bad indexes design, bad TSQL, bad transaction process(deadlock or long blocking) ). 
• Script development for automating maintenance tasks (powershell, Python, etc) 
• Archiving, restoring & migrating existing data. 
• Work on shift and support off-hours urgent call. 
• Positive attitude to learn the product design and data flow.
• Linux(Centos) and Windows Server Administrator and config
• Grafana dashboard design and Server Administrator
• Design data flow via SSIS


Requirements

1. 使用及管理MS SQL Server Replication (Transnational)和AlwaysOn 經驗 4年以上 2. 具DB Server Consolidation經驗 3. 熟悉DB壓力測試方法論與實作 Better to have: • Positive attitude to learn NetCore(c#) programming. • Positive attitude to learn to support Mongo DB, Redis and Elasticsearch. ( Basic training will be provided ) ​

Company PhotosSee all

希格斯資訊科技有限公司 work environment photo希格斯資訊科技有限公司 work environment photo希格斯資訊科技有限公司 work environment photo希格斯資訊科技有限公司 work environment photo希格斯資訊科技有限公司 work environment photo希格斯資訊科技有限公司 work environment photo希格斯資訊科技有限公司 work environment photo希格斯資訊科技有限公司 work environment photo

Share this Job

Please Sign in or Register to get your personal invite link.

希格斯資訊科技有限公司

新北市新店區北新路三段221號8樓

About us

本公司成立於2017年底 且鄰近"捷運大坪林站"(台北矽谷二期大樓),主要成員都是行業中的佼佼者且不以現況為滿足,公司的主旨為革新產業的資訊技術、優化系統流程和分散式系統,以突破和創新來為顧客和我們都帶出更大的成長動能。 我們的公司文化:卓越,創新,溝通,玩樂、誠信。並且,定期舉辦 open house 的活動,讓全體員工可以一起討論公司的發展與政策,以培養公司與員工間的互相信任和共同的價值觀。讓大家可以在和諧、愉悅、有活力、富創造力、高生產力的環境,使組織成員發揮所長,貢獻智慧,和在同事間彼此的工作方面亦是互相支持與真誠關心的關係,不僅是同事的關係,而是朋友的關係。 我們希望加入我們公司的每個人,之後都能培養出以下三個能力 : 1. 要有解決問題的能力 2. 挺身而出的領導力 3. 謙卑的態度 公司特色 : 1. 扁平式管理 2. 彈性工時 3. 良好的工作環境 4. 樂於分享知識技能的氣氛 5. 擅長於有挑戰性和多變的環境中成長 公司的五個核心的組成部分: ● Vision ● Strategic Decision ● Performance ● Management ● Company Culture We are a well-capitalized start-up and seek talented web/mobile developers and product design specialist to help pioneer commerce on the Internet. Our aim is to build high-performing, happy teams and develop amazing products for you and customers. Expected talented, motivated, intense, and interesting co-workers. Must be willing to share your knowledge and discuss with teams. What we want and what we need: ■ Top-notch communication skills are essential. ■ Must have a BS, MS, or PhD or great experience in following items or the equivalent. o Computer Science & Information Engineering o Information Management o User Interface/ User Experience o Customer Relationship Management o Accounting/Finance o Business Administration ■ Experienced designing and building large and complex systems.

See more

Learn more

Team

Higgs

Similar Jobs

資深軟體工程師 / 全端工程師 - 台北

新加坡商鈦坦科技 - Full-timeMid-Senior level1M ~ 2M TWD/yearUpdated 5 months ago

Google Cloud Platform 數據工程師 (Data Engineer)

CloudMile 萬里雲互聯科技 - Full-timeMid-Senior level40K ~ 100K TWD/monthUpdated 7 months ago

Other Popular Jobs at 希格斯資訊科技有限公司

Technology Jobs

全端 (前/後端) 軟體工程師 (.NET C#)

Full-timeMid-Senior level48K ~ 90K TWD/monthUpdated about 2 months ago

Software QA engineer

Full-timeEntry levelUpdated 6 months ago

Design Jobs

Senior UI Designer 資深UI設計師

Full-timeMid-Senior levelUpdated about 2 months ago