北京招聘

SUMMARY

This individual will be responsible for providing database administration for all testing and production DB infrastructure. This individual will handle new database configurations, performance analysis, tuning and all regularly scheduled maintenance. This individual will all be responsible for Microsoft SQL Server RDMS, SSIS, OLAP (Analysis services), SQL Server Reporting services, Postgres in Amazon’s Cloud, and SharePoint. This individual will be the primary person responsible for the Align Production database infrastructure environment.

ESSENTIAL DUTIES AND RESPONSIBILITIES

· Implement, upgrade and enhance cost-effective fault-tolerant database infrastructure

· Analyze system performance. Establish and uphold performance metrics for the system as whole and key business applications in particular.

· Fine-tune the databases to match application requirements.

· Provide database support and maintenance. Support user’s requests in relation to system problems and requests for enhancements.

· Ensure systems uptime

· Design indexes for existing applications, choosing when to add or remove indexes

· When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes

· Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specification

· communicating regularly with technical, applications and operational staff to ensure database integrity and security

· Support software projects involving the database infrastructure which this person supports.

Additional responsibilities:

· Ensures the effective fulfillment of objectives and deadlines assigned to the group.

· Comply with all safety policies, practices and procedures. Report all unsafe activities to supervisor and/or Human Resources.

· Participate in proactive team efforts to achieve departmental and company goals.

· Perform other duties as assigned.

Other duties may be assigned.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION and/or EXPERIENCE

· BA degree in a design-related field.

· Solid background in Postgres DB is must

· Solid background in Microsoft SQL and in a clustered, adhoc SQL queries, log shipping and store procedures.

· 5-8 years’ experience as a DBA in a fast paced, high growth, technology and intensive environment.

· Strong understanding of Linux operating system and ability to navigate the operating system

· Solid background of SQL Server native/SharePoint integrated reporting services administration, reporting services security, configuration and report deployment.

· Having experience on Cloud Database design/implementation and operation, like RDS on AWS

· Solid background in Microsoft SQL Server/Analysis services in a clustered environment

· Solid background in Windows server administration, Analysis Services, Integration Services, or Reporting Services.

· Power BI or other BI tools skill/experience is plus

· Certifications from Microsoft in current versions of SQL a positive

爱齐公司是一家跨国公司，成立于1997年2月，于2001年在美国纳斯达克上市。其使命是成为创新牙齿矫正设备的主要供应商，我们的产品有隐形无托槽矫治器和口内扫描仪等。 爱齐科技设计和制造世界上先进的隐形矫治器系统 — 隐适美系统，提供 iTero 口内扫描仪和相关服务，以及 CAD/CAM 软件。爱齐科技旗下品牌隐适美拥有超过八百万用户，并通过iTero 口内扫描仪和 exocad 的CAD/CAM 软件推动数字化口腔医疗的发展，打造数字化正畸和修复流程，实现口腔治疗的现代化转型，致力于帮助口腔专业人员提高诊疗效率，优化患者的治疗效果。
爱齐公司强调创新、以结果为导向、以客户与团队合作为中心、自我领导的能力与精神，为员工提供多元化的发展空间，并为员工创造学习、友好、合作、健康的工作环境。我们竭诚邀请充满工作激情，具有挑战精神的精英加入到我公司，共同创造你与公司的成功！