IT Database Specialist - Requisition #730186
: Job Details :


IT Database Specialist - Requisition #730186

Infor

Job Location : Temecula,CA, USA

Posted on : 2025-08-06T01:07:36Z

Job Description :

GENERAL SUMMARYThe primary responsibility of the IT Database Specialist is to provide the technical assistance needed to support day-to-day operations of a large 24/7 database environment. This includes assisting Sr DBA with and leading efforts to install, monitor, maintain, and performance tune all Microsoft SQL Server databases. As the IT Database Specialist, you are expected to understand database design, alerting and monitoring, and database backup strategies. The ideal candidate has strong technical and troubleshooting skills, understanding of database technologies used while also ensuring data availability, integrity, and efficiency.This position is remote-friendly; however, it may require occasional onsite work at the discretion of PRC management.

FOUR DIAMOND SERVICE AGREEMENTAll Team Members will display a Four Diamond commitment to Customer Service through the delivery and maintenance of the Quality Standards established by Pechanga Resort Casino.

KEY RESPONSIBILITIES

  • Works directly with IT Sr. DBA to perform installation and upgrades of Microsoft SQL Server.
  • Configuration of database resources (storage and compute), features, tools, and logs.
  • Monitors and maintains production and development databases.
  • Tracks and resolves database-related incidents and requests, fulfills requests, and resolves service-related issues.
  • Responds to database-related alerts and escalations, researches, and proposes solutions to recurring problems.
  • Documents, recommends, and implements approved changes and enhancements to the database environment.
  • Works with the Sr. DBA to design and maintain DB specifications, documentation, and operating procedures.
  • Implements quality standards based on industry standards and best practices.
  • Performs performance, stress, and QA testing.
  • Tests databases upgrade scripts from vendors in QA for system upgrades.
  • Reviews and maintains change documentation for databases.
  • Strong knowledge of troubleshooting issues with SQL Server including: Virtualization, high availability, MSCS/SQL clustering, instancing, blocking, deadlocking, query optimization, linked servers, distributed queries, DTS, recovery models, access violations, hangs, and run-time error scenarios.
  • Very good interpersonal skills, critical thinking, written and oral communication, and strong technical documentation skills required.
  • Performs quarterly security audits of PRC databases.
  • Responsible for enterprise backups of all production and development databases.
  • Works closely with IT Sr DBA, IT project managers, development, systems administrators, and web developers.

    • ACCOUNTABILITYThis position has no supervisory responsibilities.

    QUALIFICATIONS AND GUIDELINES

    EXPERIENCE/TRAINING/EDUCATION:The ideal candidate will have a Bachelor's degree (BS) in an IT related field with a minimum of 3 years' experience. In lieu of a degree, the candidate should have a minimum of 4 years of IT experience in a large 24/7 environment with appropriate database certifications.

    COMMUNICATION SKILLS:This position requires very good interpersonal skills, critical thinking, written and oral communication, and strong technical documentation skills. In addition, you must be able to analyze and interpret common scientific, technical, and industry journals and documents. As the database administrator, you must respond to common inquiries and complaints from customers, management, regulatory agencies, and members of the business community within a reasonable period. Moreover, the database administrator must effectively present information to management, public groups, boards of directors, and conferences when required.

    MATHEMATICAL SKILLS:This position requires the ability to calculate figures, index sizes, table sizes, proportions, percentages, capacity planning, increases/decreases-percentage change, etc. The position also requires the ability to apply concepts of basic algebra and geometry.

    REASONING ABILITY:This position requires the ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. This position also requires the ability to accurately interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

    CERTIFICATES, LICENSES, REGISTRATIONS:

  • Microsoft database certifications.
  • Must be able to pass a background check.
  • Must be able to obtain a Class “A” gaming license.

    • SKILLS/ABILITIES:

  • Practical knowledge and experience in database design and documentation.
  • Optimization of queries, ETL packages, stored procedure, and View creation.
  • Proficient in indices optimization.
  • Knowledge of database engine internals.
  • Knowledge of stored procedures and database security.
  • Knowledge of and ability to write SQL queries.
  • Ability to work under stressful situations.
  • Mentally strong and able to cope with many challenges.

    • ADDITIONAL INFORMATION:

  • Must be able to take direction and follow through with assigned tasks.
  • Must be a self-starter who is highly motivated and resourceful.
  • Must be able to work with a positive attitude in a fast-paced and culturally diverse casino environment.
  • Must be flexible and willing to work nights, weekends, and holidays.
  • Long periods of sitting and typing required.
  • Some travel for seminars or training is expected.
  • Must be comfortable working in a 24/7/365 environment.
  • Position requires 24x7 rotational on-call support.

    • DISCLAIMER:The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.

    IT Systems Management, Temecula, CA 92592

    #J-18808-Ljbffr
    Apply Now!
    Similar Jobs (0)

    -- View More Similar Jobs --