Database Administrator 2 (Data Engineer )

Fish & Game; Alaska; Hybride; USD 85 000 - 120 000; Plein temps

Résumé du poste

The Alaska Department of Fish and Game, Division of Wildlife Conservation, is recruiting a Database Administrator 2 for Anchorage or Juneau. The role focuses on managing data systems, building scalable data solutions, and ensuring security and compliance.

You will work with developers, analysts and contractors to design and optimize data pipelines, ETL/ELT processes and data warehouses using SQL Server and Azure Databricks, adhering to IT and data management standards.

Qualifications

• Knowledge of database administration principles, tools and practices.
• Ability to design and optimize data systems and queries.
• Familiarity with data security, governance, and compliance requirements.

Responsabilités

• Collaborate with developers, analysts, contractors and stakeholders to define data needs and build scalable data solutions.
• Design, maintain and optimize SQL Server databases, T-SQL, procedures, functions, and ETL/ELT processes (Azure Databricks data warehouses).
• Implement data security, access controls, and governance.
• Monitor data systems to identify and resolve quality, performance and reliability issues.

Connaissances

Technical Problem Solving

Analytical Thinking

Data Management

Information Assurance

Problem Solving Mindset

Formation

Computer Science / Software Engineering / Database Administration

Description du poste

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.