天津招聘

Responsibilities:

- Implement and administer Microsoft native High Availability and Replication technologies as well as those of third parties' in Disaster Recovery and Scale-out scenario.

- Create, administer & fine-tune the database backup, restore and archiving strategies and processes.

- Proficient in database performance tuning & optimization; Apply server and database wide settings based on dynamic need of resources - memory, CPU & storage.

- Coordinate with the Network Administer & Developers to ensure data security & availability and meet the necessity of database setup and refresh in development/staging/QA environments.

- Monitor the database capacity and physical & logical modeling for every phase of major .NET application development.

- Design and implement indexing strategies; Routinely review and refine indexing strategies; Plan and apply index defragging and statistic update policies.

- Automate routine processes in SQL job agent with any combination of vendor's script and other scripting languages; Configure the notification and send out message to the owner of failed job for subsequent troubleshoot.

- Follow and implement the SQL Server security best practices such as separate and run SQL Server services under different Active Directory accounts AND using Kerberos authentication.

- Define, select & monitor database performance metrics and sending alerts/warning in advanced to support department/company overall SLA; Taking ownership of root cause analysis.

- Collaborate with system and storage engineer to install, configure & fine-tune SQL Server on physical and/or virtual machine.

- Exposure to set up, admin and deploy applications to SQL Server in Azure.

- Being a liaison between internal partners and external vendors application/databases.

Requirements:

Bachelor degree major in computer science from 4-year accredited college preferred. MCITP: Database Administrator and/or MCTS Database Specialist on SQL Server 2008/2012/2014/2016.

Preferred minimum 2 years of dedicated experience as a SQL Server Database Administrator. Developer/part time DBA or non-SQL server DBA is acceptable.

Solid experience (hand-on) in Transactional, Log-shipping and Mirroring replication; AlwaysOn Availability Group is a big bonus.

Solid experience in the migration of 2008 to 2012/2014/2016 along with the installation of SQL 2012/2014/2016 and configuration of SQL Server with best practices of storage performance.

Understanding of index internal structure; Solid T-SQL skills and strong understanding of SQL 2008/2012/2014/2016 DMVs.

Ability to use scripting language including but not limited to PowerShell, VB, java & DOS batch command.

Power user in Windows 2008/2012/2016 and general knowledge of Active Directory and Group Policy; Capable of communicating the fundamental of network and firewall knowledge.

Strong discipline of following project timeline and excellent time management skill.

碧艾吉（天津）科技有限公司（PX (Tianjin) Software Development Company, LLC）, 是一家美国独资的专业软件应用解决方案提供商。致力于为客户提供优质软件定制解决方案，并提供基于解决方案的相关咨询，应用开发，系统集成，商务智能及系统实施和维护等专业化服务。
我们始终秉承为客户创造价值及双赢合作的理念，以卓越的软件解决方案帮助客户达成各种需求，成为客户强有力的IT技术后盾，得到美国客户的高度赞赏。今天，我们以务实的服务理念将高品质的IT服务带入中国，帮助中国客户创造新价值。
公司历史：
公司于2007年在天津由美国著名企业Panda (US) Technologies Company, LLC全资注册成立，主要面向美国高端客户提供IT软件技术服务。中国强劲的经济发展，吸引了大批高端技术与服务进入中国。2011年，公司进驻天津空港经济区。办公面积增加到1600平方米，注册资金增加为500万美金，总投资额增加为1000万美金。公司将进入大力开拓中国市场的全新阶段。
美国洛杉矶总部熊猫快餐网站：http://www.pandaexpress.com/