State of Washington
IT DATA MANAGEMENT - SR/SPEC-LCT-Database Administrator
State of Washington, Kent, Washington, us, 98089
The ideal candidate for this role is a proactive problem-solver, a clear communicator, and a strategic thinker who recognizes the vital role data plays in supporting the
Paid Family and
Medical Leave (PFML) and WA Cares programs . They are a seasoned professional with deep expertise in
Microsoft SQL Server technologies particularly
Azure SQL Database and have a proven history of managing complex, mission-critical database environments within the
Azure cloud ecosystem. The Innovation & Technology Office (I&T), Information Technology Services Division (ITSD) of the Employment Security Department (ESD)
manages, develops, supports, and maintains the agencys computer systems, web technologies, network and data communications and the data warehouse. It also provides technical assistance for installation and operation of personal computers and software. This position is a member of the Data Management team within ITSD of the Innovation & Technology Office and reports to the Data Ops Supervisor. This role will support the Leave & Care Technology team (LCT) and LCT systems, which are integral to the successful administration of Leave and Care Division programs (PFML and WA Cares) within ESD by supporting agency database systems and the data that resides within them. As a Database Administrator, you will be responsible for the administration, development, optimization, security, and availability of database systems supporting the Leave and Care Technology (LCT) systems for the Paid Family and Medical Leave (PFML) and WA Cares programs. The LCT DBA plays a key role in ensuring the stability, performance, integrity, and security of databases crucial to LCT operations, including those supporting our public-facing benefits portal, call center Microsoft Dynamics CRM application, and Microsoft Dynamics 365 Finance (AX) financial system, primarily hosted within the Azure SQL Database platform and the broader Azure cloud ecosystem. Key responsibilities include designing, implementing, monitoring, tuning, backing up, recovering, and maintaining these critical database environments. Some of your daily tasks may include but not limited to: Provide agency database administration Design and implement and maintain on-prem and Azure-native database solutions, including deployment, backup, replication, and disaster recovery (DR). Optimize databases, ensuring minimal downtime during migrations. Implement security best practices, including role-based access control (RBAC) and Azure Security Center policies. Troubleshoot SQL database issues and manage encryption. Provide agency database Technical & Customer Support Respond to service requests, incidents, and performance issues. Escalate complex issues to LCT Leadership or Microsoft Support (Azure Premier). Oversee and/or execute database changes, patching, and maintenance with application owners. Provide technical consultation on Azure SQL performance best practices. Ensure Database Security and Compliance Apply and enforce security controls, system security plans, and Azure Policy. Conduct security audits and identity access reviews. Monitor Azure Security Center alerts for breaches, suspicious activity, or misconfigurations. Ensure compliance with IT security standards and data protection policies. Maintain Technical Documentation Design and document Azure SQL deployment architecture, migration playbooks, and best practices. Create system diagrams and architecture designs. Design and document troubleshooting procedures for performance tuning, security incidents, and backups. Share knowledge and conduct internal training sessions. Document contingency plans, risk/assessment. Increase knowledge and skills related to technologies and systems Evaluate and recommend new Azure features for enterprise viability. Optimize cost strategies for Azure database services. Remain current with relevant laws, policies, and industry standards. Please click here to request a complete detailed description of the position and its duties. Option 1: At least nine
(9)
years of experience performing database administration. Option 2: Bachelors degree in computer science or closely related field
and
five
(5)
years of experience performing database administration. Option 3: A combination of nine
(9) years of education
and/or
relevant IT experience
and demonstrated experience with documentation of complex databases, data structures, system design and configurations in accordance with LCT standards, procedures and best practices. Desirable/Preferred Education, Experience or Certifications Master's or other advanced degree in computer science, data science, information systems and/or IT Management/Leadership. Microsoft SQL Server Database Administrator Certification. Advanced knowledge SDLC (Software Development Life Cycle), and Agile development methodology. Demonstrated experience with documentation of complex system design activities and configurations in accordance with industrial and/or agency policy and procedural standards. Position Specific Competencies SQL Server Administration-
Proficient in managing SQL Server databases, ensuring high availability, security, and performance. Skilled in database maintenance tasks such as backups, restores, and updates to safeguard critical data. Performance Optimization
Expertise in identifying and resolving database performance issues through techniques like query tuning and indexing. Committed to maintaining efficient and scalable database systems for optimal application responsiveness. Data Solution Design
Capable of analyzing complex requirements to design tailored, robust data solutions. Skilled in implementing scalable architectures that align with organizational objectives and future growth. Information Security
Preserve the confidentiality, integrity, and availability of ESD systems and data in accordance with the policies, procedures, and best practices established and maintained by the ESD information security team. Immediately report any Security event, incident, or breach in reporting. Additional Requirement of Employment: Must be able to pass an Unemployment Insurance (UI) and Paid Family Medical Leave (PFML) Claim & Benefit Information Review (Fraud Checks) Please submit only the required documents as noted below and ensure all Personal Identifying Information (PII) such as Social Security numbers etc. are edited out of your materials for privacy. Please submit your Cover Letter and Resume with yourOnline Applicationthrough the
"Add Attachments"
field. A resume will not substitute for the "work experience" section of the application or vice versa. Applications with blank fields, or supplemental question responses with comments such as "see attachments" may be considered incomplete. Additionally, we ask that you not include photographs or external links within your documents. Any documents uploaded through this platform will be securely transmitted electronically to support application review.
Why work with us? Our agency's mission and
values drive every decision that we make, determine how we interact with others and are at the core of who we are. We value Access, Love, Belonging, Equity, and Stewardship. We understand that a work environment that respects your work/life balance is key; that's why many of our positions are eligible for flexible work schedules and teleworking opportunities. Through support, value, and trust, our employees are empowered to grow and develop into their best self. Opportunity for All We strive to create a working environment that includes and respects cultural, ethnic, racial, religious, sexual orientation, and gender identity diversity. Women, racial and ethnic minorities, people with disabilities, people over 40 years of age, people with religious beliefs, veterans or people with military status, and people of all sexual orientations and gender identities are encouraged to apply. The Employment Security Department is an equal opportunity employer/program. Auxiliary aids and services are available upon request to individuals with disabilities. If you are a person needing assistance in the application process, if you need this job announcement in an alternate format, or if you have general questions about this opportunity, please contactCheyenne Pernitesor the Talent Acquisition Team,
prior
to the recruitment closing or Washington Relay Service 711. If you are having technical difficulties creating, accessing, or completing your application, please contact careershelp@des.wa.gov or (360) 664-1960 or toll free (877) 664-1960, Washington Relay 711. **
This organization participates in E-Verify
** #J-18808-Ljbffr
Paid Family and
Medical Leave (PFML) and WA Cares programs . They are a seasoned professional with deep expertise in
Microsoft SQL Server technologies particularly
Azure SQL Database and have a proven history of managing complex, mission-critical database environments within the
Azure cloud ecosystem. The Innovation & Technology Office (I&T), Information Technology Services Division (ITSD) of the Employment Security Department (ESD)
manages, develops, supports, and maintains the agencys computer systems, web technologies, network and data communications and the data warehouse. It also provides technical assistance for installation and operation of personal computers and software. This position is a member of the Data Management team within ITSD of the Innovation & Technology Office and reports to the Data Ops Supervisor. This role will support the Leave & Care Technology team (LCT) and LCT systems, which are integral to the successful administration of Leave and Care Division programs (PFML and WA Cares) within ESD by supporting agency database systems and the data that resides within them. As a Database Administrator, you will be responsible for the administration, development, optimization, security, and availability of database systems supporting the Leave and Care Technology (LCT) systems for the Paid Family and Medical Leave (PFML) and WA Cares programs. The LCT DBA plays a key role in ensuring the stability, performance, integrity, and security of databases crucial to LCT operations, including those supporting our public-facing benefits portal, call center Microsoft Dynamics CRM application, and Microsoft Dynamics 365 Finance (AX) financial system, primarily hosted within the Azure SQL Database platform and the broader Azure cloud ecosystem. Key responsibilities include designing, implementing, monitoring, tuning, backing up, recovering, and maintaining these critical database environments. Some of your daily tasks may include but not limited to: Provide agency database administration Design and implement and maintain on-prem and Azure-native database solutions, including deployment, backup, replication, and disaster recovery (DR). Optimize databases, ensuring minimal downtime during migrations. Implement security best practices, including role-based access control (RBAC) and Azure Security Center policies. Troubleshoot SQL database issues and manage encryption. Provide agency database Technical & Customer Support Respond to service requests, incidents, and performance issues. Escalate complex issues to LCT Leadership or Microsoft Support (Azure Premier). Oversee and/or execute database changes, patching, and maintenance with application owners. Provide technical consultation on Azure SQL performance best practices. Ensure Database Security and Compliance Apply and enforce security controls, system security plans, and Azure Policy. Conduct security audits and identity access reviews. Monitor Azure Security Center alerts for breaches, suspicious activity, or misconfigurations. Ensure compliance with IT security standards and data protection policies. Maintain Technical Documentation Design and document Azure SQL deployment architecture, migration playbooks, and best practices. Create system diagrams and architecture designs. Design and document troubleshooting procedures for performance tuning, security incidents, and backups. Share knowledge and conduct internal training sessions. Document contingency plans, risk/assessment. Increase knowledge and skills related to technologies and systems Evaluate and recommend new Azure features for enterprise viability. Optimize cost strategies for Azure database services. Remain current with relevant laws, policies, and industry standards. Please click here to request a complete detailed description of the position and its duties. Option 1: At least nine
(9)
years of experience performing database administration. Option 2: Bachelors degree in computer science or closely related field
and
five
(5)
years of experience performing database administration. Option 3: A combination of nine
(9) years of education
and/or
relevant IT experience
and demonstrated experience with documentation of complex databases, data structures, system design and configurations in accordance with LCT standards, procedures and best practices. Desirable/Preferred Education, Experience or Certifications Master's or other advanced degree in computer science, data science, information systems and/or IT Management/Leadership. Microsoft SQL Server Database Administrator Certification. Advanced knowledge SDLC (Software Development Life Cycle), and Agile development methodology. Demonstrated experience with documentation of complex system design activities and configurations in accordance with industrial and/or agency policy and procedural standards. Position Specific Competencies SQL Server Administration-
Proficient in managing SQL Server databases, ensuring high availability, security, and performance. Skilled in database maintenance tasks such as backups, restores, and updates to safeguard critical data. Performance Optimization
Expertise in identifying and resolving database performance issues through techniques like query tuning and indexing. Committed to maintaining efficient and scalable database systems for optimal application responsiveness. Data Solution Design
Capable of analyzing complex requirements to design tailored, robust data solutions. Skilled in implementing scalable architectures that align with organizational objectives and future growth. Information Security
Preserve the confidentiality, integrity, and availability of ESD systems and data in accordance with the policies, procedures, and best practices established and maintained by the ESD information security team. Immediately report any Security event, incident, or breach in reporting. Additional Requirement of Employment: Must be able to pass an Unemployment Insurance (UI) and Paid Family Medical Leave (PFML) Claim & Benefit Information Review (Fraud Checks) Please submit only the required documents as noted below and ensure all Personal Identifying Information (PII) such as Social Security numbers etc. are edited out of your materials for privacy. Please submit your Cover Letter and Resume with yourOnline Applicationthrough the
"Add Attachments"
field. A resume will not substitute for the "work experience" section of the application or vice versa. Applications with blank fields, or supplemental question responses with comments such as "see attachments" may be considered incomplete. Additionally, we ask that you not include photographs or external links within your documents. Any documents uploaded through this platform will be securely transmitted electronically to support application review.
Why work with us? Our agency's mission and
values drive every decision that we make, determine how we interact with others and are at the core of who we are. We value Access, Love, Belonging, Equity, and Stewardship. We understand that a work environment that respects your work/life balance is key; that's why many of our positions are eligible for flexible work schedules and teleworking opportunities. Through support, value, and trust, our employees are empowered to grow and develop into their best self. Opportunity for All We strive to create a working environment that includes and respects cultural, ethnic, racial, religious, sexual orientation, and gender identity diversity. Women, racial and ethnic minorities, people with disabilities, people over 40 years of age, people with religious beliefs, veterans or people with military status, and people of all sexual orientations and gender identities are encouraged to apply. The Employment Security Department is an equal opportunity employer/program. Auxiliary aids and services are available upon request to individuals with disabilities. If you are a person needing assistance in the application process, if you need this job announcement in an alternate format, or if you have general questions about this opportunity, please contactCheyenne Pernitesor the Talent Acquisition Team,
prior
to the recruitment closing or Washington Relay Service 711. If you are having technical difficulties creating, accessing, or completing your application, please contact careershelp@des.wa.gov or (360) 664-1960 or toll free (877) 664-1960, Washington Relay 711. **
This organization participates in E-Verify
** #J-18808-Ljbffr