The California State Lottery is looking to fill the exciting role of a

Information Technology Specialist II / Lead Database Administrator!

If this opportunity would be a good fit for you, we encourage you to apply today and join our winning team!

People are drawn to the California State Lottery because we:

• We have a worthy mission that we’re sure you’ll take pride in too.
• Are an energetic, creative, and talented team
• Value diversity and inclusion in the workplace
• Empower team members to bring their knowledge, expertise, and innovation
• Recognize individual and team contributions
• Support the importance of work-life balance
• Invest in the professional development of our team members
• Are dedicated to preserving our environment by lowering our carbon footprint

The California Lottery is a multi-billion-dollar enterprise headquartered in Sacramento. It is one of the few state agencies that is a revenue generator, not accepting taxpayer dollars from the state’s general fund. Our mission is to provide supplemental funding to California schools while simultaneously supporting local communities. Ninety-five cents of every dollar spent by players goes back to local communities in the form of contributions to public schools and colleges, prizes and retailer compensation.

In fiscal year 2022-23, the California Lottery generated sales of approximately $9.2 billion with over $2.2 billion earned for California public schools. Lottery products are sold at more than 23,000 retail locations throughout the state. Product offerings include an average of 52 fun and entertaining Scratchers games and several draw games such as Powerball, Mega Millions, and SuperLotto Plus and daily games such as Fantasy 5 and Hot Spot.

Job Description and Duties:

Under general direction of the Infrastructure Administration & Support Manager (Information Technology Manager I), the Lead Database Administrator is responsible for enterprise data standards and for storage and managing the data to support the complex Data Base Management Systems (DBMS) for the California State Lottery’s (Lottery) infrastructure. The duties for this position are focused in the System Engineering and IT Project Management domains; however, work may be assigned in other domains as needed.

This position requires a current IT Specialist II exam. If you need to take the exam or if your score has expired, click here to gain list eligibility.

This position is headquartered at the Sacramento HQ and is eligible for a hybrid telework schedule. Employees must be able to report to their assigned headquarters office as assigned. Travel expense to and from the assigned headquarters are the responsibility of the employee. Eligibility for telework requires the employee to reside in California per California Government Code Section 14200 which states: “telecommuting means the partial or total substitution of computers or telecommunication technologies, or both, for the commute to work by employees residing in California.

You will find additional information about the job in the Duty Statement.

Working Conditions:

1. Schedule: This position supports the Lottery during normal business hours from 8:00 a.m. to 5:00 p.m. Weekends, long and/or irregular hours, after-hours work, and holiday work may be required.
2. Travel: Statewide overnight travel may be required.
3. Other. This position will be required to carry a Lottery issued cell phone. This position will be required to be reachable outside of normal business hours.

Desirable Qualifications

• Experience managing large-scale databases and complex database environments ensuring performance, availability, and security.
• Expertise in optimizing database performance through indexing, query optimization, and system resource management including identifying and resolving bottlenecks to ensure high availability.
• Experience in designing and implementing backup and disaster recovery plans to prevent data loss and ensure business continuity. Familiarity with tools for automated backups and point-in-time recovery.
• Advanced SQL knowledge writing complex queries, creating stored procedures, functions, and triggers. The ability to debug and optimize SQL queries to maintain high-performing databases.
• Expertise in cloud platforms (e.g., AWS RDS, Azure SQL, Google Cloud SQL) and hybrid environments.
• Experience securing databases to prevent unauthorized access, data breaches, and cyber threats including implementing encryption, auditing, and access controls to ensure compliance with regulations.
• Experience leading and mentoring a team of database administrators.
• Familiarity with automation tools and scripting languages to automate routine tasks like backups, updates, and monitoring, improving efficiency and consistency.
• Knowledge of database clustering, replication, and high-availability architectures to ensure the database systems remain operational and scalable under load.

*Important Note: A resume and Statement of Qualifications are required to submit with your application package in order to be considered.

For more information about this opportunity, benefits, and instructions on how to apply -- click the Apply button.