GENERAL SUMMARY
The Information Technology (IT) Database Administrator administers and controls all organization data resources. Uses repeatable practices to ensure data availability, integrity and security, recover corrupted data and eliminate data redundancy, and leverages database tools to improve database performance and efficiency.


FOUR DIAMOND SERVICE AGREEMENT

All Team Members will display a Four Diamond commitment to Customer Service through the delivery and maintenance of the Quality Standards established by Pechanga Resort and Casino. See the Talent Management Operations Partner Service Agreement, which describes the knowledge, skills, and abilities required to demonstrate Four Diamond service in this position.


KEY RESPONSIBILITIES
• Designs, implements, monitors and maintain all PR&C databases, data warehouses and data marts
• Reviews and approves schema change requests for databases
• Reviews and approves all access to databases by users and vendors
• Monitors and maintains production and development databases
• Documents, recommends, implements, and approves proposed changes and enhancements to the database environment
• Documents databases and the environment, creates ERDs of databases
• Design and implement DBMS by creating models, building table structure, establishing referential integrity & preparing documentation
• Manipulate data through normalization, transfer, tuning, cleansing/scrubbing processes and database population
• Design and maintain DB software library, specifications, documentation and operating procedures
• Researches, evaluate and test proposed products, product versions and systems solutions
• Develops quality standards based on industry standards, best practices and evaluates available technology & resources
• Manages projects involving responsibility for establishing objectives, activities, and timelines then completing the work in accordance with established project plan for all database projects
• Performs performance, stress and QA testing
• Tests databases upgrade scripts from vendors in QA for system upgrades
• Reviews and maintains change documentation for databases
• Practice and knowledge of troubleshooting issues with SQL Server including: High Availability, MSCS/SQL clustering, instancing, blocking, deadlocking, query optimization, linked servers, distributed queries, SSIS, recovery models, access violations, hangs, and run-time error scenarios
• Identification, analysis and documenting any issues that affect the performance or production quality of the databases that may be presented to development or vendors for product planning/issue resolution
• Very good interpersonal skills, critical thinking, written and oral communication, communications skills, and strong technical documentation skills required
• Performs security audits quarterly of PR&C databases
• Performs disaster recovery tests quarterly of databases
• Responsible for enterprise backups of all Microsoft & ORACLE related production and development databases
• Works closely with IT project managers, database programmers, systems administrators and web developers
• Attends all departmental, managers and company meetings
• Long periods of sitting and typing required
• Some travel for seminars or training is expected
• Keeps Management updated on projects
• Ability to work on rotation support 24/7

MINIMUM QUALIFICATIONS
• Bachelor’s degree in Software Development or Computer Science preferred
• 5 years or more experience of SQL Server Database performance tuning and optimization using Profiler, Extended events, Performance Counter, SQL Audit, SQL Trace, and SQL Perfmon.
• 5 years or more experience in an enterprise environment using the following: Microsoft SQL 2012/2014/2016/2017 and Windows 2008/2012
• 4 years hands on experience with enterprise database technology in a Windows environment administering and developing T-SQL, creating stored procedures, index tuning, performance tuning and testing
• Experience in capacity planning and storage management
• Experience with High Availability (HA) and Disaster Recovery (DR)
• Experience with PowerShell and DBA Tools a plus
• Experience with business and casino operations preferred
• Experience with Oracle and DB2 databases is a plus
• Experience with Database Replication (snapshot, transactional, and merge)
• Ability to automate backups, restore/refresh procedures, and SSRS reports
• Ability to automate routine processes in SQL Job Agent
• Well versed in SQL Security Best Practices
• Development background is a plus
• Qualify to obtain a Class “A” Gaming License.
• Good attitude
• Professional demeanour
• Make eye contact while speaking
• Ability to work under stressful situations
• Mentally strong and able to cope with many challenges