Database Administrator

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

Qualifications

  • Seven years of experience in enterprise SQL Database administration, specifically with large-scale applications (Microsoft SQL Server 2016+, MySQL, etc.)
  • Proficient in Azure VM deployment, lifecycle patching, and Azure SQL database management
  • Skilled in data modeling and ER/physical design tools
  • In-depth knowledge of OLTP and OLAP concepts
  • Experience with Azure Data Factory for triggers, activities, and data integration
  • Strong communication skills, both written and verbal
  • Ability to work in a 24/7 on-call rotation for critical issues and support

Responsibilities

  • Install, patch, upgrade, and maintain the health of database servers
  • Build database schemas according to customer needs
  • Conduct performance tuning for database systems and structures
  • Identify database requirements through collaboration with customers and analyzing existing systems
  • Manage Azure Data Factory pipeline operations
  • Troubleshoot and resolve database integrity and performance issues
  • Document business continuity processes and procedures

Benefits

  • Flexible working arrangements with remote and on-site collaboration
  • Opportunities for professional development and educational workshops
  • Participation in feedback for disaster recovery plans and tests
  • Support for maintaining personal workspace ergonomics and security
  • Engagement in cross-functional team efforts to meet strategic goals
Full Job Description
Salary : $93,944.00 - $122,535.00 Annually
Location : Thurston County - Olympia, WA
Job Type: Full Time - Permanent
Job Number: 1463
Department: Health Benefits Exchange
Opening Date: 05/06/2026

Description
SUMMARY
The Database Administrator is responsible for administering and maintaining the organization's on-premises and Azure-based database platforms. 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 the Senior Database Administrator on performance and scalability improvements, and leading initiatives for physical data modeling and architecture design across hybrid infrastructures.
Duties
• Installs, Patches, upgrades and maintains the system health for the database servers.
• Builds database schemas and structures based on customer needs and established standards
• Suggests performance tuning database systems/servers and database structures.
• Identifies database requirements by interviewing customers; analyzing department applications, programming, and operations; and evaluating existing systems and designing proposed systems.
• Evaluates and runs SQL and other Database scripts.
• Azure Data Factory (ADF) pipeline management
• Uses data and database processes and procedures for daily tasks such as log analysis.
• Implements and maintains transactional replication for the database environment
• Troubleshooting DB integrity and performance issues
• SQL Job scheduling and automation
• Backup and restore strategy
• Indexing and parameter optimization
• Utility and tool development for DB support
• Collaborate across Dev and User teams related to database setup and data related activities.
• On-call rotation support
• Monitoring tool assessment and set up
• Evaluates Security Auditing and Maintaining server & DB permissions
• Documents business continuity, plan processes and procedures.
• Troubleshoots and resolves database integrity issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Develop and maintain SQL Jobs based on maintenance tasks as well as tools and requirements of Dev and User communities.
• Runs and schedules backup schedules to meet organizational RTO and RPOs.
• Restore data and databases based on organizational needs.
• Test restores data recovery at a regular interval.
• Participate and provide feedback on Disaster recovery plans and tests
• Maintains database performance by calculating optimum values for database parameters.
• Creates and suggests changes to indexes and performance methods.
• Supports database functions by designing and coding utilities.
• 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.
• Contribute to team effort by accomplishing related results as needed.
• Work closely with various Dev and User Community teams in progress of HBE goals/strategies.
• Supporting Microsoft SQL Server Integration Services (SSIS)
• Generating the reports using Microsoft SQL Server Reporting Services (SSRS)
• Modelling the data using Microsoft Data Warehouse technologies
• Create database reports using Business Intelligence concepts and best practices
• Making the changes to database related DNS, DHCP, Active Directory and Group policies
• DB migration-Migrating the databases from on premise to Azure SQL
• Identify the big tables and partitioning the tables based on the usage and application along, Compression and Encryption
• Configuring the SQL Monitoring system or similar products for managing multiple SQL Server instances
• Conducting Root Cause Analysis and SOP documents
Qualifications

Required:
• Seven years of experience in enterprise SQL Database administration with large-scale, mission-critical applications (Microsoft SQL Server 2016+, MySQL, etc.)
• Experience with SSMS, MS tools, Azure VM deployment, lifecycle patching, Azure SQL database
• Experience with Data modeling, ER/physical design tools
• Experience with Database Server Performance and Optimization tools
• Experience in understanding Online Transaction Processing (OLTP), and Online Analytical Processing (OLAP) concepts
• Experience in ADF triggers and activities, data integration, performance monitoring
• Experience in role-based access control, Active Directory, Azure AD, encryption standards
• Experience in implementation of replicate database
• Experience in using performance tools like Extended Events, SQL Profiler, Azure Diagnostics, blocking/deadlock analysis
• Experiencing in scheduling jobs using SQL Agent, ADF scheduling, Logic Apps for orchestration
• Experience managing database backup, restore and data archiving tasks, Azure Backup, Recovery Vault, LRS, ZRS restore validation and compliance
• Experience in Database performance metrics, query optimization tools, cloud-based tuning
• Excellent written, oral and presentation skills and ability to communicate complex concepts
• Experience being on call rotation support 24*7 for monitoring and handling severity problems
• Familiarity with SQL Monitor or similar products for managing multiple SQL Server instances Azure cloud, third party tools
• Experience in Database Auditing, Roles and permissions
• Better understanding on Database internals
• Experience with Database backup and restore
• Experience with Database PAAS solution for backup and recovery
• Experience with Database PAAS for recovery
• Database design
• Excellent analytical skills: ability to identify core issues and formulate a workable plan of action for complex problems that cross the boundaries of database, operating system, and application.
• Self-motivated and driven to improve processes and increase velocity
• Experience of working with Data Warehouse teams and understanding concepts
• Better understanding on BI tools
Desired:
• Bachelor's degree in computer science or related field, or equivalent training and experience
• Scripting knowledge for automating day to day tasks (Shell script, Power shell)
• Experience in automation tools like PowerShell, Python, Azure SDKs, SSMS scripting, tooling automation
• Experience in Develop and maintain SQL Jobs based on maintenance tasks as well as tools and requirements of Dev and User communities.
• Experience in participate and provide feedback on Disaster recovery plans and tests in disaster recovery setup and maintenance
• Experience in Database Partitioning, Compression and Encryption
• Professional demeanor; ability to represent project to stakeholders in a friendly, unbiased and professional manner.
• Experience and understanding the concepts of SSIS
• Experience and understanding the concepts of SSRS
• Experience of working with network and system admins
• Experience in database migration from on premise to cloud
• Experience in database performance tuning
• Experience in setting up database monitoring systems
• Certification in Microsoft SQL Server
Supplemental Information

APPLICATION INSTRUCTIONS
This position will be open until we find a suitable number of candidates to review. If interested, please submit application (click here) as soon as possible. The Exchange reserves the right to close the recruitment at any time.

SALARY INFORMATION
Full Salary Range: $81,690.00 to $122,535.00 annually, with midpoint at $102,113.00.

Hiring Range: $93,944.00 and $102,113.00 annually. This is an estimate of where a qualified candidate can expect to receive an offer.

The actual salary offer will consider candidate experience, skills, qualifications, internal equity, and the market. Our compensation policy reserves the salary range above the midpoint for employees who are meeting and exceeding expectations and for growth and development, up to the maximum.

BENEFITS
Take a peek at our

WORKING CONDITIONS
Core business hours are 8:00 a.m. to 5:00 p.m., Monday through Friday. There are times where irregular hours will be required. The preferred duty station is our Olympia, Washington headquarters. The nature of this role relies heavily on remote and in-person collaboration. While a hybrid remote and on-site schedule may be considered, the position will require flexibility to allow for in-office availability as business needs dictate. Travel requirements will be limited, however there may be occasions where an employee is required to travel and work irregular hours to attend meetings or trainings. Duties of this position require the use of standard office furniture and equipment, including setup for remote work. The employee is responsible for providing and maintaining a safe, ergonomic, and secure workspace at their remote location.

The working conditions and physical demands are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

SPECIAL REQUIREMENTS
A criminal background screen will be conducted for candidates under final consideration, and if hired, every five years of employment where highly sensitive data is processed or maintained by the position. The incumbent in this role will also be required to complete a federal fingerprint background check. The results of these background screens must meet the Exchange s eligibility standards.

OTHER INFORMATION
The above statements are intended to describe the general nature and levels of work being performed. They are not intended to be construed as an exhaustive list of responsibilities, duties and skills of personnel so classified.

This is not an employment agreement or contract. Management has the exclusive right to alter this job description at any time without notice.

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 Database Administrator jobs: