Database Administrator 2 (Data Engineer PCN 112248)

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

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

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.

REQUIRED DOCUMENTS

If selected, please provide the following at the time of the interview:

• 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 (907) 465-4095 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 ‘govermentjobs.com’ domains. For information on allowing emails from the ‘governmentjobs.com’ domains, visit the Lost Password Help page located at .

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 (907) 465-4095 if you are located in the Juneau area. Requests for information may also be emailed to recruitment.services@alaska.gov.

For applicant password assistance please visit: