Database Administrator 2 (Data Engineer PCN 112248)

State of Alaska • See Recruitment Details, AK

1d • Hybrid

About The Position

The Alaska Department of Fish and Game, Division of Wildlife Conservation, is recruiting an experienced data engineer to manage data systems in the Data Analytics Group. The role develops and maintains modern, scalable, efficient, and dependable data management and analysis infrastructure that supports the division’s mission to conserve and enhance Alaska’s wildlife and habitats and provide for public uses and benefits. Candidates must be Alaska residents. The position is based in Anchorage or Juneau, Alaska, and offers a flexible work schedule and a hybrid teleworking arrangement. It occasionally requires in-state travel for staff meetings, and there may be opportunities to join biologists in the field.

The Database Administrator 2 works with application developers, analysts, contractors, and other stakeholders to assess data requirements and build secure, efficient, scalable, and well-documented data solutions. The role designs, maintains, and optimizes SQL Server databases, complex T-SQL queries, procedures and functions, Azure Databricks data warehouses, and ETL/ELT processes. It applies information technology, security, and data management standards; implements data security, access controls, and governance; and monitors systems to resolve data quality, performance, and reliability issues. The position requires problem-solving and clear communication of technical concepts to technical and non-technical audiences.

Requirements

• Competencies in critical thinking, database administration, data systems, information assurance, and technical problem solving.
• Knowledge of database system development, implementation, automation, or administration principles, methods, and tools.
• Knowledge of data systems and computing systems as they apply to data handling.
• Knowledge of methods and procedures for protecting information systems and data availability, authentication, confidentiality, and integrity.
• Ability to troubleshoot, diagnose, analyze, and identify system malfunctions and their causes.
• Competencies may be gained through training or education in computer science, software engineering, database administration, data analysis, information technology, or a similar area, and/or professional experience in computer programming, designing database queries, data analysis, and/or database administration.
• Alaska residency.
• If relying on post-secondary education to meet minimum qualifications, complete the Education section of the application and provide transcripts; foreign education must meet the stated credential-evaluation requirements.

Nice To Haves

• Experience or competency in technical problem solving, analytical thinking/problem solving, and data management, including data modeling, backup, recovery, dictionaries, warehousing, mining, archiving, disposal, and standardization.

Responsibilities

• Collaborate with application developers, analysts, contractors, and stakeholders to assess data requirements and develop data solutions.
• Design, maintain, and optimize SQL Server databases, complex T-SQL queries, procedures and functions, Azure Databricks data warehouses, and ETL/ELT processes.
• Follow established information technology, security, and data management standards.
• Implement data security, access controls, and governance practices to protect sensitive information and ensure compliance with applicable requirements.
• Monitor data systems and processes, identify and resolve data quality, performance, and reliability issues, and implement improvements.
• Communicate technical concepts clearly to technical and non-technical audiences.

Benefits

• Opportunity to work with a dynamic, solutions-oriented team of specialists.
• Opportunity to make meaningful contributions to the management and conservation of Alaska’s wildlife.
• Option to join biologists in the field when opportunities arise.
• Flexible work schedule and options for a hybrid teleworking arrangement.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed