Experience

Cannery Casino Resorts
• Gambling Facilities and Casinos
• 100 - 200 Employee
• Manager Database Administration

  • Dec 2013 - Present


Cache Creek Casino Resort

• United States
• Gambling Facilities and Casinos
• 300 - 400 Employee

• SQL Database Administrator /Report Writer

  • Mar 2004 - Dec 2013

  * Design and implement MSSQL data warehouse, Oracle data warehouse, DTS, ETL (Extract Transform and Load)* Create reports using SQL Reporting Services and OBIEE * Develop infrastructure setup, physical database, reporting and analytical functionality.* Develop, implement and maintain databases, which include: installs, fine-tuning, data modeling, dumping, restore, backup, etc.* Setup and maintain complete policies and procedures for all database system.* Provide distinct environments for production, testing, development and automation of day-to-day tasks.* Develop, implement and maintain the security of applications with the database.* Document, maintain and administer all databases.* Develop, implement, document, test and maintain disaster recovery plan for all databases.* Develop statistical reporting for all casino departments as requested.* Trouble shooting performance issues for IGT Gaming system with 3000 slot machines, Opera for Hotel, Micros for POS. Show less

• Database Administrator - DBA

  • Mar 2004 - Dec 2013



CHP Headquarter in Sacramento

• Programmer

  • Jan 2005 - Aug 2005

  - Developed VB.Net GUI for CAD (Computer Aid Dispatch). - Updated CA mapping system - Developed VB.Net GUI for CAD (Computer Aid Dispatch). - Updated CA mapping system