IT Data Management – Journey

WSLCB Vision
Safe communities for Washington State

Mission
Promote public safety, public health, and trust through fair administration and enforcement of liquor, tobacco, cannabis and vapor laws

This recruitment is open until filled. First review of applications will be August 10th, please submit an application on or before August 9th. The hiring authority reserves the right and may exercise the option to make a hiring decision at any time. We encourage all to apply as early as possible.

This position is currently eligible to telework. This position will be required to work in the office at least 1 day per week. This may change based on business needs.

Who we are

The mission of the Washington State Liquor and Cannabis Board (WSLCB) is to promote public safety, public health, and trust through fair administration, education and enforcement of liquor, cannabis, tobacco, and vapor laws. We search for people who demonstrate a strong work ethic, excellence in customer service, partnering and teamwork, and quality performance.

We want to create a culture that fosters excellence in customer service, open and honest communication, transparency and accountability, data driven decisions, and business-initiated process improvement.

Our commitment to DEIB

The WSLCB strives to promote Diversity, Equity, Inclusion, and Belonging (DEIB) in all aspects of our work. This includes a commitment to our workforce and external stakeholders.  It is our mission to build, educate, and inspire an inclusive environment that recognizes, respects, and celebrates diversity in the workplace and in the community we serve. We are committed to maintaining a thriving culture where employees and those we serve feel safe and accepted regardless of education, background, or beliefs. As a WSLCB team member, you will have opportunity to join statewide business resource groups (BRGs) such as, Rainbow Alliance and Inclusion Network, Veteran Employee Resource Group, Latino Leadership Network, Blacks United in Leadership and Diversity, Disability Inclusion Network, Washington Immigrant Network and Hawaiians, Asians, and Pacific Islanders Promoting an Empowerment Network; Supporting our Voices, Empowering Rights, and Engaging Indigenous Governance; and Interagency Committee of State Employed Women.

The Washington State Liquor and Cannabis Board (WSLCB) Information Technology Services Division is announcing an exciting opportunity for an IT Data Management – Journey located in Olympia, WA. This position reports to the IT Operations Manager in the WSLCB’s Information Technology Services Division (ITSD).

The journey-level Database Administrator (DBA) is the technology professional responsible for all functions related to database development, storage, security, and retrieval within the WSLCB.  This position works independently and proactively collaborates with members of the application support teams, infrastructure, product management, business subject matter experts and project teams.

This journey-level DBA develops, installs, tests, troubleshoots, stabilizes, safeguards and continuously improves all WSLCB’s integrated data systems, which includes Microsoft SQL Server and other data management platforms, as required hosted in Azure and AWS cloud environments, as well as on-premise virtual environments. This position is critical to providing accurate, consistent, and efficient data to inform licensing, enforcement and tax collection responsibilities of the agency.

The incumbent will create, monitor, maintain and document database installations, architecture, processing, balancing, and decommissioning. Perform typical system administrative activities such as database creation, backup, restore and issue resolution. Ensure high availability, security, and optimal performance by following established standards, procedures, and automation practices. Work includes building and executing SQL and cloud-native scripts to manage and modify data, collaborating with vendors and team members on performance and scalability improvements, and leading initiatives for physical data modeling and architecture design across hybrid infrastructures.

Problems may be of an urgent and critical nature, requiring work to be done beyond scheduled working hours to bring systems back online. The DBA works collaboratively with numerous cross-functional teams.  The incumbent must independently plan and execute the evaluation of new data initiatives, which include but are not limited to upgraded versions and integration with additional enterprise systems.

Paramount to the mission of this position is the stewardship of data stored in agency systems, hosted both internally and externally, by providing data analysis and documentation for data migration efforts from various systems as well as safeguarding and securing that data. This position is required to independently apply journey level technical knowledge to evaluate and resolve complex tasks.

If you have an interest in providing technical leadership and strategic direction for the technologies, standards, processes, and architectures for the Agency enterprise data analytics hub, we encourage you to apply to be a part of the WLSCB team!

WSLCB provides a modern work environment and excellent benefits including:

• A comprehensive benefits package (including but not limited to Medical/Dental/Vision, Long Term Disability, Life Insurance etc.)
• Paid Vacation, Leave, and Holidays
• Tuition Waiver (enrollment in courses at state universities/colleges on a space availability basis – all or a portion of the tuition/fees may be waived for state employees)
• Tuition reimbursement (courses taken with prior approval in order to further employee’s career development with the WSLCB)
• Training and career development programs (including online courses and LinkedIn Learning)
• A healthy work/life balance (this may include flexible/alternative work schedules and telework/remote work opportunities, when possible)
• Employee Assistance Program – confidential program created to promote the health, safety and well-being of public service employees
• Generous wellness program (we offer reimbursements for certain fitness related activities)
• Onsite exercise facility (for employees working at WSLCB Headquarter Building in Olympia)
• Infants at Work Program to promote parent and infant bonding, parental well-being and healthy infant development. Depending on your job duties, work location and supervisor approval, eligible employees who are new mothers, fathers or legal guardians can bring their infant (six weeks to six months) when they return to work.
• Free parking

• Manages the day-to-day operations of agency databases; Installs, Patches, upgrades and maintains the system health for the database servers and related services.
• Defines and implements enterprise data management strategy and standards, builds database schemas and structures based on customer needs and standards.
• Conducts data modeling techniques and methodology development. Produce entity relationship diagrams for existing databases. Conducts physical schema design of table spaces, rollback segments. and data files.
• Supervise and coordinate cross-divisional collaboration to establish and maintain consistent data governance practices, including data categorization, storage, and classification.
• Manage the development and maintenance of the agency’s enterprise data catalog, including metadata, storage locations, Washington Technology Solutions (WaTech) security classifications, and governance documentation.
• Installs, configures and maintains database management systems software and related services in cloud and on-premise environments.
• Monitoring data systems and environments for issues, including issues with disk space, proper execution of scheduled jobs, potential performance issues, and operating system and server patches.
• Communicate application problems and issues to key stakeholders, including product management, systems and business analysts, application support, developers, and management.
• Maintains, monitors, and conducts performance tuning of databases. Analyze and plan for anticipated changes in data capacity requirements. Ensures security of data systems by auditing permissions. Evaluates Security Auditing and Maintaining server & DB permissions.
• Manage changes to database related DNS, DHCP, Active Directory and Group policies. Ensures data recovery, maintenance, data integrity and space requirements are met for physical database through formulations of policies, procedures and standards to ensure effective data management enterprise wide.
• Deploy requested database structure and data changes as needed by development staff to enable them to more readily service their customers. Develop and maintain SQL Jobs based on maintenance tasks as well as tools and requirements of Application Support, Development, and Data Users.
• Troubleshoots and resolves database integrity issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues. Conducting Root Cause Analysis and develop SOP documents accordingly. Plan, coordinate and execute data conversions and migrations between different platforms and servers.
• Responsible to design, implement and test backup and recovery of databases to ensure continuity of operations; participate in DR when necessary.
• Aid in development of agency-wide business continuity and disaster recovery plans, and maintain current knowledge of plan executables.
• Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.

Five (5) years of professional experience within the last seven (7) years, in SQL programming, experience with entity relationship modeling and notation, or database report development. Experience includes but not limited to independently analyzing, designing, implementing and maintaining databases, and experience with data extraction and transformation (e.g. ETL).  Education or experience  in Computer Science, Information Technology (IT), Science, Technology, Engineering, Mathematics (STEM), or closely related field; or completion of a two (2) year accredited vocational training program in computer programming and database design, database administration, data administration or data analysis.

AND

Working level knowledge and experience in the following:

• Administering, including installing, configuring, and supporting Microsoft Windows Server 2022 and above.
• Of troubleshooting and problem resolution of computer systems applications or databases.
• In administering Microsoft SQL Server, including installing, configuring and supporting SQL Server (2022 and above).
• In administering different data management platforms, including installing, configuring and support.
• Of Active Directory with specific focus on user and group permissions.
• With SQL Server Integration Services (SSIS) and Microsoft Fabric and SQL Server Reporting Services (SSRS) and PowerBI.

Preferred/Desired Qualifications: 

• Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.

Required Equity Competencies:

The ability to take action to learn and grow

This equity competency identifies people who are curious about themselves and others, who take responsibility for knowing their own strengths and weaknesses, and who use their learning to make government programs and processes more efficient and effective to serve all in Washington.

The ability to take action to meet the needs of others 

This equity competency identifies people who are flexible, adaptable, customer-service focused, and willing and able to empathetically respond to the unique needs of the people they work with and serve.

Competencies:

Proactive issue identification, communication, and resolution: Be proactive with respect to identifying potential issues in advance, communicating them to others, and seeing them to resolution/completion. This will mean coordinating and communicating with peers, other teams, customers, and vendors to research and come up with solutions as well.

Research and Ideation: Do adequate research prior to conversing with peers, vendors, and customers and be able to bring ideas to the table that are on topic, innovative, cost-effective, and align with Division and Agency values.

Self-starter: Take immediate ownership of issues that arise and see them to completion. Collaborate and coordinate with stakeholders to ensure solutions to issues will meet business needs.

Flexibility/Adaptability: Be open and aware of changes. Be able to learn from failures. Be able to identify issues and work around them or escalate them.

Continuously understanding, enhancing/improving Customer Experience: Be hyper-aware of the customer and their experience. Seeing things from the customer’s perspective. Always asking how this will affect a customer’s experience and if there is a better way to resolve an issue for the customer to continue to do their job.

Seek Clarity: Always ask clarifying questions when first given and during assignments so that expectations are met. Ask questions at meetings when necessary so that there is an understanding of what is being said.

Analyze and Innovate: Be mindful of how solutions that are brought to the table will align with agency values and impact the agency/division/section financially and reputational. Be able to adapt new or existing solutions to strategically meet goals.

Accountability: Accept personal responsibility for the quality and timeliness necessary to achieve excellent results. With little oversight; develop innovative solutions to a variety of issues. Make timely decisions although faced with limited data or resources. Accept own role when expectations are not met, and respond quickly to resolve issues with others.

Build and Maintain Relationships: Earn the trust, respect, and confidence of coworkers and customers through consistent honesty and professionalism in all interactions. Build and maintain working relationships characterized by mutual acceptance and cooperation. Contribute to an environment that honors diversity, and uses diverse perspectives to meet the agency’s mission and goals.

Effective Communications, General: Convey clear, timely, persuasive messages that positively influence the thoughts and actions of others.   Effectively express ideas and information through the written and spoken word using language that is appropriate to both the complexity of the topic and the knowledge and understanding of the reader or audience (“plain talk”).  Keeps supervisor and co-workers informed while sharing complete and accurate information with others to include staff and people outside the organization. Practices active listening by concentrating on person or caller; listens without interrupting; and asks questions to clarify and verify information.

Effective Communications, Writing Skills: Composes clear, straightforward, and technically correct documents. Proofreads and edits information to improve clarity, organization, content, and correcting errors in grammar, punctuation, and spelling.  Independently compose written responses to emails and letters from customers answering questions, providing information, and/or explaining decisions made regarding eligibility for services or compliance with rules.  Extract and compile data to prepare narrative, statistical or other reports for review, analysis, documentation, etc. (e.g., financial, payroll, labor distribution, purchasing, inventory, registration, patient or student information)

LEAN: Actively pursue opportunities for problem solving and continuous process improvement, participate in team huddles, and promote program priorities and results.

Serving Customers: Build and maintain internal and external customer satisfaction with the products and services offered by the Liquor Control Board, develop innovative ideas that provide solutions to our customers’ challenges.

Safety: Understand and follow agency safety policies and other standards established to maintain a safe work environment.  Carefully organize your personal workspace to minimize the likelihood of accidents.  Report all injuries, accidents or hazards to your supervisor immediately.

If you are excited about this role but not sure if your experience aligns perfectly with every qualification in the job description, we encourage you to apply. At the Washington State Liquor and Cannabis Board, we are dedicated to building a diverse and authentic workplace centered in belonging. You may just be the needed candidate for this or other roles.

IMPORTANT: To be considered for this position, you MUST include the following, failure to do so will result in your application being disqualified:

1. Completed online application.
2. Current Resume.
3. Letter of Interest describing how you meet the specific qualifications for the position.
4. Three professional references to include a current or recent supervisor with email addresses and phone numbers.

The Washington State Liquor and Cannabis Board is an equal opportunity employer and encourages applications from job seekers with diverse backgrounds. Honoring diversity, equity and inclusion means that as an agency, and as individuals, we are committed to ensuring that all employees enjoy a respectful, safe, and supportive working environment.

All qualified applicants will receive consideration for employment without discrimination based on sex, race, creed, religion, color, national origin, age, honorably discharged veteran or military status, sexual orientation including gender expression or identity, the presence of any sensory, mental, or physical disability, or the use of a trained dog guide or service animal by a person with a disability.  You are welcome to include your name and gender pronouns in your application, to ensure we address you appropriately throughout the application process.

For questions about this recruitment, or to request reasonable accommodation in the application process, please email hrjobs@lcb.wa.gov or call (360) 664.1720. For TTY service, please call the Washington Relay Service at 7-1-1 or 1-800-833-6384.