Database Administrator 2

State of Alaska; Alaska; Hybrid; USD 90,000 - 120,000; Full time

Job summary

State of Alaska, Department of Fish and Game, Division of Wildlife Conservation, is seeking a Database Administrator 2 to manage our data systems from Anchorage or Juneau. The role focuses on building secure, scalable data solutions and collaborating with developers, analysts, and contractors to meet agency data needs.

Responsibilities include designing and maintaining SQL Server databases, Azure Databricks data warehouses, ETL/ELT processes, and enforcing data security and governance practices

Qualifications

• Experience in database administration and data systems.
• Knowledge of data security and information assurance practices.
• Strong problem-solving and communication skills.

Responsibilities

• Collaborate with developers, analysts, contractors to assess data requirements and build scalable data solutions.
• Design, maintain, and optimize SQL Server databases and Azure Databricks data warehouses.
• Implement data security controls and governance to protect sensitive information.
• Monitor data systems, identify quality and performance issues, and implement improvements.

Skills

Technical Problem Solving

Analytical Thinking/Problem Solving

Data Management

Information Assurance

Database Administration

Education

Degree or equivalent in computer science / IT

Tools

SQL Server

Azure Databricks

Job description

Database Administrator 2 (Data Engineer PCN 112248) | Workplace Alaska page has loaded.

This position is open to Alaska Residents only. Please check our residency definition to determine if you qualify.

The Alaska Department of Fish and Game, Division of Wildlife Conservation is recruiting for a Database Administrator 2 located in Anchorage or Juneau!

Job Description

This position is open to Alaska Residents only. Please check our residency definition to determine if you qualify.

The Alaska Department of Fish and Game, Division of Wildlife Conservation is recruiting for a Database Administrator 2 located in Anchorage or Juneau!

What you will be doing

The Division of Wildlife Conservation is recruiting an experienced data engineer to manage our data systems.

Typical work includes:

• Collaborating with application developers, analysts, contractors, and other stakeholders to assess data requirements and develop secure, efficient, scalable, well-documented data solutions that support agency objectives.
• Designing, maintaining, and optimizing SQL Server databases, complex T-SQL queries, procedures, and functions, Azure Databricks data warehouses, and ETL/ELT processes in accordance with established information technology, security, and data management standards.
• Implementing data security, access controls, and governance practices to protect sensitive information and ensure compliance with applicable federal, state, and agency policies and requirements.
• Monitoring data systems and processes, identifying and resolving data quality, performance, and reliability issues, and implementing improvements as needed.
• Having a problem-solving mindset and being able to clearly communicate technical concepts to both technical and non-technical audiences.

Our mission, values, and culture

The mission of the Division of Wildlife Conservation is to conserve and enhance Alaska's wildlife and habitats and provide for a wide range of public uses and benefits.

The Data Analytics Group supports this mission by developing modern, scalable, efficient, and dependable data management and analysis infrastructure for the division, fostering reliable information sharing, reproducible research, and collaboration among current and future staff.

The Alaska Department of Fish & Game strives for a diverse and inclusive workforce where safety and well-being are paramount and employees at all levels promote a culture where everyone is valued, treated equitably, and treated respectfully.

The benefits of joining our team

Within the Data Analytics Group, you are a member of a dynamic, solutions-oriented team of specialists who collaborate to develop and implement modern data management and analysis infrastructure for the division.

This position offers a unique opportunity to utilize your distinct talents to make meaningful contributions to the management and conservation of Alaska’s wildlife. You will be given the option to join biologists in the field when opportunities arise.

The working environment you can expect

This full-time position is based at the ADF&G office in either Juneau or Anchorage, Alaska with a flexible work schedule and options for a hybrid teleworking arrangement. You will regularly interact with team members and contractors via MS TEAMS. This position occasionally requires in-state travel to attend staff meetings.

Who we are looking for

We are interested in candidates who possess some or all of the following position specific competencies:

• Technical Problem Solving: Troubleshoots, diagnoses, analyzes, and identifies system malfunctions to determine the source and cause of the problem
• Analytical Thinking/Problem Solving: uses a logical, systematic, sequential approach to address problems or opportunities or manage a situation by drawing on one’s knowledge and experience base and calling on other references and resources as necessary.
• Data Management: Knowledge of the principles, procedures, and tools of data management, such as modeling techniques, data backup, data recovery, data dictionaries, data warehousing, data mining, data archiving, data disposal, and data standardization processes.

To view the general description and example of duties for a Database Administrator 2 please go to the following link: https://www.governmentjobs.com/careers/Alaska/classspecs

Minimum Qualifications

Any combination of education and/or experience that provides the applicant with competencies in:

• Critical Thinking: Uses logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
• Database Administration: Knowledge of the principles, methods, and tools for automating, developing, implementing, or administering database systems.
• Data Systems: Knowledge of computer hardware and software development and systems as they apply to the conception, specification, analysis, planning, development, installation, test, modification and use of data handling and computing systems in support of aerospace flight and ground systems.
• Information Assurance: Knowledge of methods and procedures to protect information systems and data by ensuring their availability, authentication, confidentiality, and integrity.
• Technical Problem Solving: Troubleshoots, diagnoses, analyzes, and identifies system malfunctions to determine the source and cause of the problem.

Equivalent to those typically gained by:

Training and/or education in computer science, software engineering, database administration, data analysis, information technology, or similar area and/or professional experience in computer programming, designing database queries, data analysis, and/or database administration.

Special Note:

“Competencies” means a combination of interrelated knowledge, skills, abilities, and behaviors that enable a person to act effectively in a job or situation.

“Typically gained by” means the prevalent, usual method of gaining the competencies expected for entry into the job.

“Training” and “education” are synonyms for the process of acquiring knowledge and skills through instruction. It includes instruction through formal and informal methods (such as classroom, on-line, self-study, and on-the-job), from accredited and unaccredited sources, and long-duration (such as a post-secondary degree) and short-duration (such as a seminar) programs.

“Professional experience” means work that is creative, analytical, evaluative, and interpretive; requires a range and depth of specialized knowledge of the profession's principles, concepts, theories, and practices; and is performed with the power or right to decide or act according to one's own judgment.

“Progressively responsible” means indicating growth and/or advancement in complexity, difficulty, or level of responsibility.

Contact Information

For specific information in reference to the position please contact the hiring manager: Christine Schmale, IT Manager. [e-mail]

Phone [phone] (Statewide toll-free number)
[phone] (Juneau and out-of-state callers)