IT Data Management - Journey

State of Washington$90K — $121K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of experience with SQL programming and database management within the last 7 years
  • Strong understanding of entity relationship modeling and database design practices
  • Experience with Microsoft SQL Server (2022 and above) administration
  • Knowledge of cloud environments, including Azure and AWS
  • Ability to analyze, design, implement, and maintain databases and ETL processes

Responsibilities

  • Manage daily operations of agency databases, ensuring system health and uptime
  • Implement enterprise data management strategies and standards
  • Conduct data modeling and produce entity relationship diagrams
  • Coordinate cross-divisional data governance practices
  • Develop and maintain an enterprise data catalog with proper documentation
  • Perform installation and maintenance of database management systems in both cloud and on-premise
  • Monitor database environments for performance and integrity issues

Benefits

  • Comprehensive medical, dental, and vision insurance
  • Paid tuition for state university courses based on availability
  • Tuition reimbursement for pre-approved courses
  • Access to training and development programs
  • Flexible work schedules and remote work opportunities
  • Wellness program with reimbursements for fitness activities
  • Onsite exercise facility for employees in Olympia
Full Job Description
Salary : $90,096.00 - $121,176.00 Annually
Location : Thurston County - Olympia, WA
Job Type: Full Time - Permanent
Remote Employment: Flexible/Hybrid
Job Number:
Department: Liquor and Cannabis Board
Division: Information Technology Services
Opening Date: 07/24/2026

Description
Your opportunity at a glance
The Washington State Liquor and Cannabis Board (WSLCB) Information Technology Services Division is announcing an exciting opportunity for an IT Data Management - Journey locatedinOlympia, 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 (including but not limited to Medical/Dental/Vision, Long Term Disability, Life Insurance etc.)
  • Paid
  • (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)
  • - 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

Duties

Some of the duties you will perform are:

  • 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.

Qualifications

Required Qualifications:
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 s

About State of Washington

State of Washington Careers

Joining the State of Washington's diverse team offers more than just a job; it opens opportunities to build and grow a career in an array of fields. State of Washington is renowned for its commitment to excellence and innovation in public service.

Explore Job Opportunities

State of Washington offers a variety of job opportunities that cater to a range of skills and interests. From environmental science to public health, the state provides roles that contribute significantly to the community and the environment. Each position at the State of Washington supports a culture of leadership and professional growth.

Experience Professional Growth

Career advancement is a cornerstone of employment with the State of Washington. With programs designed to foster leadership skills and professional development, employees are encouraged to ascend through the ranks. The State of Washington is committed to providing career pathways that help individuals achieve their professional goals.

Engage in Diversity Training and Innovation

The State of Washington places a high priority on creating an inclusive work environment. Diversity training is integral, ensuring all team members understand and appreciate the value of differences. Innovation is at the heart of the State of Washington, where new ideas and perspectives lead to effective solutions and services.

Benefits and Culture

Employees at the State of Washington enjoy a comprehensive benefits package that supports both their professional and personal lives. Health benefits, retirement plans, and wellness programs are just the beginning. The culture here is built on mutual respect, collaboration, and a commitment to excellence.

Internship Programs

For those starting their career journey, internship opportunities provide a gateway to full-time employment and a chance to develop valuable industry skills. Internships at the State of Washington are designed to give hands-on experience and insights into the workings of state government.

Join the Team

State of Washington is continuously hiring new talent. Interested candidates are encouraged to review open positions that match their skills and career interests. The hiring process is thorough, ensuring that both the candidate and the position are a perfect match.

Prepare for Your Interview

To help candidates succeed, State of Washington offers resources on how to effectively prepare for interviews. Tips on crafting a compelling resume and mastering interview techniques are available to ensure applicants present their best selves.

Networking and Career Events

Regular networking events and career fairs provide opportunities to connect with leaders in various fields and explore potential job openings. These events are ideal for sharing professional experiences, meeting potential mentors, and learning more about the State of Washington's mission and values.

Stay Connected

Keep up to date with the latest news, job alerts, and career tips from the State of Washington by subscribing to the careers newsletter. Discover the exciting and rewarding opportunities that await at the State of Washington.

SEARCH STATE OF WASHINGTON JOBS

READ CAREERS BLOG

JOB ALERT EMAILS

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Explore the rewarding career opportunities at the State of Washington today.
Learn more about State of Washington

Similar Jobs

More Jobs at State of Washington

More Information Technology Jobs

Find similar IT Data Management - Journey jobs: