SQL Database Administrator

At Panda we all share a common mission: deliver exceptional Asian dining experiences by building an organization where people are inspired to better their lives. We invest in our people because great people run great operations that will exceed our guests expectations. Talk to any of our associates and you will experience a culture dedicated to its mission and our five fundamental values - Proactive, Respect/Win-Win, Growth, Great Operations, and Giving.

Panda Restaurant Group includes the original Panda Inn fine dining restaurants, Panda Express, our Gourmet Chinese food concept served in a fast casual environment, and Hibachi San, our Japanese grill concept. The family owned and operated company is still run by founders Andrew and Peggy Cherng. Annual sales in 2009 were in excess of $1.2 billion. Panda Express added 88 new locations in 2009 and have added more than 500 locations in the last four years throughout the United States.  In 2010, Panda will be operating well over 1,300 restaurants.

Panda offers excellent benefits and rewarding opportunities, from entry-level positions to management. We have restaurant positions available nationwide and support center positions in Rosemead, CA. Come join the nations largest and fastest growing Asian restaurant company.

Responsibilities:

• Maintain and monitor database backup and restore processes.
  
  
• Coordinate with the Network Administer & Developers to ensure data security & availability and meet the necessity of database refresh in development/staging environment.
  
  
• Understand the effects of different replication methodologies to select and configure the settings while maintaining the stability of the data stream.
  
  
• Own database performance tuning analysis & optimization.
• Troubleshoot vendor and in-house applications.
  
  
• Communicate and maintain SQL Server concepts and best practices including SSAS & SSRS.
  
  
• Plan, design, and implement the database capacity, physical and logical modeling, and security practices for every phase of major .NET application development.
  
  
• Administer varieties of SQL Server jobs and proactively monitor & optimize any data replication/ETL processes.
  
  
• Review the design and deployment of data objects from development/staging to production.
  
  
• Act as the first technical contact for any query/database performance issues and assist developers and business power users in query requests and enhancements.
• Understand the implications of various replication methodologies and SQL Server security best practices including SSAS and SSRS.
• Execute and enforce operational and administrative tasks with a focus on maintaining the stability of the data stream.
  
• Assist in deployment of .NET applications, SSIS packages, SSRS-RDL and SSAS cubes. 
  
  
• Ensure data objects naming convention and enforce data integrity by building data cleansing rules and refining the ETL processes.

Panda Restaurant Groups culture is strongly guided by our Mission and Values, highlighted on the Panda websites.  We recommend all interested candidates become familiar with our Mission and Values, as well as the principals of The Seven Habits of Highly Effective People, by Stephen Covey.

Panda Restaurant Group, Inc is an Equal Opportunity Employer.

• MS in Computer Science, Engineering or Business.  MCITP: Database Administrator and/or MCTS Database Specialist on SQL Server 2005 (MCTS: SQL Server 2005) or equivalent.
  
  
• 5+ years of experience as a SQL Database Administrator with at least 3 years working directly with SQL Server required.
• 3+ years experience with T-SQL production.
• 2+ years experience with Client Server or .NET programming background.
• Expertise in creating sophisticated SSIS from scratch.
  
• Exposure in 3rd party backup and performance diagnosis & monitoring tools. 
  
• Hands on technical lead role experience in the migration of SQL 2000 to 2005/2008 along with the installation of SQL 2005/2008 and configuration of SQL Server with best practices of storage performance.
• Hands on experience in Transactional, log-shipping and mirroring replication.
  
• In-depth knowledge of indexing strategy to include solid T-SQL skills and strong understanding of SQL 2005/2008 system view.
• Ability to automate routine processes with any combination of delivered tools and scripting languages (i.e. VB, Java & PowerShell) under strict time and resource constraints.
  
  
• SSRS and SSAS are bonus skills.
  
  
• Focus on high ROI strategic projects.