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

希格斯資訊科技有限公司

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

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 ) ​

Share this Job

Please Sign in or 회원가입 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 8달 ago

CakeResume Job Search

Tens of thousands of jobs listings. Salary transparency. Accurate and instant search experience.

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

Technology Jobs

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

Full-timeMid-Senior level48K ~ 90K TWD/monthUpdated 5달 ago

DevOps - System Engineer 系統工程師

Full-timeMid-Senior levelUpdated 9달 ago

Software QA engineer

Full-timeEntry levelUpdated 9달 ago

DevOps - Network Engineer 網路工程師

Full-timeMid-Senior levelUpdated 10달 ago