Database Administrator (Natural Resources)

Systems Engineering, Architecture, Administration, and Support

• Administer, maintain, monitor, and optimize Oracle databases and supporting infrastructure for WRIS and related applications, including backup, recovery, patching, troubleshooting, and performance tuning.
• Help lead the migration of WRIS databases and related services from on-premises environments to Oracle Cloud Infrastructure, including planning, validation, cutover support, and post-migration optimization.
• Engineer, configure, and support database and system environments, upgrades, patches, hardware replacements, and recovery processes to maintain stable and secure operations.
• Design and support database architecture, data models, stored procedures, triggers, and SQL or PL/SQL code that enable reliable business operations, reporting, data integrity, and system integration.
• Document database architecture and solution design using clear technical artifacts, including entity-relationship diagrams, data flow diagrams, and related documentation methods.
• Monitor database and system resource usage, analyze performance, tune environments for reliability and scalability, and recommend cost-effective improvements.
• Support information security administration by managing database access, permissions, environment controls, patch review, risk mitigation, and compliance with state and agency policies.
• Partner with program staff, developers, GIS professionals, contractors, and other technical teams to gather requirements and translate business needs into effective technical solutions.
• Support GIS-related data integrations, enterprise data services, and document-linked workflows, including systems such as FileNet and related metadata or retrieval processes.
• Support business continuity, disaster recovery, and recoverability objectives for database and related infrastructure services.
• Respond to user support needs, assist with system enhancements, and contribute to modernization efforts that improve service delivery and operational effectiveness.
• May lead projects involving the design, development, implementation, and management of databases, and may be assigned responsibility for project components.
• Demonstrate a willingness and eagerness to explore Artificial Intelligence (AI) in the database and other workflows, including practical uses for automation, monitoring, workflow improvement, reporting support, and future platform modernization

Minimum Qualifications: Equivalent combinations of education and experience may be considered on a case-by-case basis.

• Bachelor s degree in computer science, information systems, information technology or related field
• Three plus years of applicable experience

Knowledge, Skills, and Abilities (KSAs):

Knowledge of:

• Working knowledge of multi-tier architecture, enterprise infrastructure, and systems integration across server, storage, network, and operating environments.
• Knowledge of relational database security principles, including authentication, authorization, auditing, and broader enterprise security practices.
• Database design concepts, includingnormalization, transactional integrity, data warehousing, dimensional modeling, and alternative data models.
• Skill in:
• Virtualization, containerization, and cloud concepts, including platforms such as VMware, Hyper-V, Docker,OracleCloud Infrastructure,and related services/technologies.
• Database views,monitoringtools, performance analysis methods, and scripting or automation tools used to support efficient administration.

Ability to:

• Assess technical risk, support continuity of service, and apply sound judgment inmaintainingstable and secure environments.
• Communicate clearly, organize competing priorities, and work effectively with both technical teams and business partners.