Database Administrator 2 (Data Engineer PCN 112248)

State of Alaska; Juneau (AK); Hybrid; USD 90,000 - 120,000; Full time

Job summary

The Alaska Department of Fish and Game, Division of Wildlife Conservation, is seeking a Database Administrator 2 in Anchorage or Juneau. This full-time role supports data management, security, and analytics for the division, with a hybrid schedule and occasional in-state travel.

Responsibilities include designing and maintaining data warehouses and ETL processes, collaborating with stakeholders, and ensuring information security and compliance with federal, state, and agency policies.

Qualifications

• Minimum qualifications include training/education in computer science, software engineering, database administration or related field, and/or professional experience in database design, data analysis, and administration.
• Knowledge of database administration principles, methods, and tools.
• Ability to communicate technical concepts to both technical and non-technical audiences.

Responsibilities

• Collaborate with developers, analysts, contractors, and stakeholders to assess data requirements and develop secure, scalable data solutions.
• Design, maintain, and optimize SQL Server databases, complex T-SQL queries, procedures and functions, and ETL/ELT processes.
• Implement data security, access controls, and governance to meet policy requirements.
• Monitor data systems, identify data quality and performance issues, and implement improvements.
• Communicate technical concepts clearly to diverse audiences.

Skills

Technical Problem Solving

Analytical Thinking/Problem Solving

Data Management

Information Assurance

Education

Equivalent education/experience in CS/IT/DBA

Tools

SQL Server

T-SQL

Azure Databricks

ETL/ELT

Job description

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:

• 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.

Additional Required Information

REQUIRED DOCUMENTS

• Contact information for three (3) professional references, one of whom must be a current or former supervisor.


• Transcripts, if using to meet minimum qualifications (unofficial copies are acceptable).

EDUCATION

If post‑secondary education is required to meet the minimum qualifications, you must fill in the Education section of the application. If you have not obtained a degree, please indicate the number of units completed. Copies of transcripts are required to verify educational credentials if used to meet the minimum qualifications for a position. Transcripts can be attached at the time of application or within 48 hours of the close of this recruitment to the contact person listed below.

SPECIAL INSTRUCTIONS FOR FOREIGN EDUCATION Education completed in foreign colleges or universities may be used to meet the above requirements, if applicable. If utilizing this education you must show that the education credentials have been submitted to a private organization that specializes in interpretation of foreign educational credentials and that such education has been deemed to be at least equivalent to that gained in conventional U.S. education programs; or an accredited U.S. state university reports the other institution as one whose transcript is given full value, or full value is given in subject areas applicable to the curricula at the state university. It is your responsibility to provide such evidence when applying. Omission of required documentation listed will result in an incomplete application and you will not receive further consideration.

WORK EXPERIENCE If using work experience not already documented in your application, also provide the employer name, your job title, dates of employment, and whether full-or part‑time. Applications will be reviewed to determine if the responses are supported and minimum qualifications are clearly met. If they are not, the applicant may not advance to the interview and selection phase of the recruitment.

NOTE: Attaching a resume or curriculum vitae is not an alternative to filling out the application in its entirety. Noting "see resume or CV" or any similar response on any portion of your application may lead to a determination your application is incomplete and removal from consideration for this job posting.

MULTIPLE VACANCIES This recruitment may be used for more than one (1) vacancy. The applicant pool acquired during this recruitment may be used for future vacancies for up to ninety (90) days after this recruitment closes. Interested applicants are encouraged to apply to each recruitment notice to ensure consideration for all vacancies.

EEO STATEMENT The State of Alaska complies with Title I of the Americans with Disabilities Act (ADA). Individuals with disabilities, who require accommodation, auxiliary aides or services, or alternative communication formats, please call 1-800-587-0430 or [phone] in Juneau or TTY: Alaska Relay 711 or 1-800-770-8973 or correspond with the Division of Personnel & Labor Relations at: P.O. Box 110201, Juneau, AK 99811-0201. The State of Alaska is an equal opportunity employer.

NOTICE If you choose to be contacted by email, please ensure your email address is correct on your application and that the spam filter will permit email from the ’governmentjobs.com’ domains. For information on allowing emails from the ’governmentjobs.com’ domains, visit the Lost Password Help page located at https://www.governmentjobs.com/OnlineApplication/User/ResetPassword .

WORKPLACE ALASKA APPLICATION QUESTIONS & ASSISTANCE Questions regarding application submission or system operation errors should be directed to the Workplace Alaska hotline at 1-800-587-0430 (toll free) or [phone] if you are located in the Juneau area. Requests for information may also be emailed to [e-mail]. For applicant password assistance please visit: https://www.governmentjobs.com/OnlineApplication/User/ResetPassword

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)