Job Title: Sr DBA
Department: IT

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 ives 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 in Microsoft SQL and in a clustered, adhoc SQL queries, log shipping and store procedures.
?7-10 years’ experience as a DBA in a fast paced, high growth, technology and intensive environment.
?Solid in Postgres DB
?Strong understanding of Linux operating system and ability to navigate the operating system
?Solid of SQL Server native/SharePoint integrated reporting services administration, reporting services security, configuration and report deployment.
?Solid in Microsoft SQL Server/Analysis services in a clustered environment
?Solid 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

愛(ài)齊（上海）商貿(mào)有限公司是美國(guó)Align Technology Inc. 我們的產(chǎn)品為隱形牙套，是Align Technology專有的產(chǎn)品，在全球100多個(gè)國(guó)家銷售，并于1998年通過(guò)美國(guó)食品藥品管理局（FDA）審批。Align Technology Inc. 于2000年在美國(guó)納斯達(dá)克上市，全球至今已經(jīng)有幾百萬(wàn)患者使用過(guò)Invisalign隱適美產(chǎn)品。
愛(ài)齊公司強(qiáng)調(diào)創(chuàng)新、以結(jié)果為導(dǎo)向、以客戶與團(tuán)隊(duì)合作為中心、自我領(lǐng)導(dǎo)的能力與精神，為員工提供多元化的發(fā)展空間，并為員工創(chuàng)造學(xué)習(xí)、友好、合作、健康的工作環(huán)境。
我們?cè)谥袊?guó)成立六年多，已經(jīng)成功建立了市場(chǎng)品牌并開始商業(yè)運(yùn)作，我們竭誠(chéng)邀請(qǐng)充滿工作激情，具有挑戰(zhàn)精神的精英加入到我公司，共同創(chuàng)造你與公司的成功！