Database Specialist 1|2|3 Apply
This position is currently undergoing review as a part of the IT Project job class study and therefore both the title and the pay range assigned may be subject to change upon the completion of the study.
Pay is based on the location of the selected candidate; salaries will be discussed at the time of the interview.
What You Will Be Doing:
As part of the Database Team, you are supporting around 190 servers and 3250 databases in the State of Alaska Enterprise. What this could look like for your daily routine would be:
Review AlaskaNow IT tickets, emails, phone calls, MS Teams chat messages, and daily database report logs (Windows Event Logs and SQL Agent Logs) for identifying and prioritizing workload. Follow up on other databases that require a higher level of attention depending on efforts towards migration or changes to configurations completed previously.
Check planning calendar schedule for patching, reboot events, server upgrades/migrations. Communicate with fellow team members in MS Teams Chat to keep others aware of which projects you are already working on and keep aware what others have already begun. While backups/restores/migrations of data are your typical norm they offer of challenge when discovery of missing database objects or permissions need additional troubleshooting.
While it may sound a little routine, no two issues are identical, and the variances can keep your mind active. High value specs of a reliable database include storage capacity and ease of performance. While getting more storage can seem like an easy solution, you are challenged in how to implement it into that database. Are the permissions or other network factors causing the backups to fail? There is no exact science to performance issues and tuning, and we will offer training and knowledge sharing to help you and the agencies along.
Since we provide support to multiple departments, we encourage your interpersonal and communication skills by meeting with the departments to discuss their needs and collaboration efforts with the Database Team, IT managers, and programmers to innovate effective solutions.
Finally, participate in knowledge pooling and put your technical writing skills to when defining your refined procedures, server/service configurations, and department-based information in our MS Online DevOps Wiki to refer to later and for the rest of the team to potentially incorporate into their own projects.
Our Organization, Mission, and Culture:
The Office of Information Technology Mission: One government, empowered by innovative technical collaboration.
We meet this through our goals: Reduce Complexity, Improve Efficiency, and Encourage Creativity in order to provide better government services to all Alaskans.
The OIT Operations Database Team keeps many state agency services available to Alaska citizens so they can seamlessly apply for the permanent fund dividend, purchase hunting and fishing licenses online, the multitude of DMV online services, and so much more throughout the State.The Benefits of Joining Our Team:
This team is a diverse, technically self-motivated group that embraces the latest technology and develops leading-edge applications for the State of Alaska. Additionally, training platforms offer courses in many areas support your career goals, and a team dedicated to identifying training offerings to help you meet your career goals. This is in addition to the position specific training plan associated with this position for flex-promotion opportunity.
There are advancement opportunities within this flexibly staffed position. These multiple-compensation/range Database Specialist positions are designed to allow you to join our Database Team at your current Database Administrator skill level. After that, you can advance your career and increase your compensation as you expand your skills and gain experience, and ultimately flex to a Database Specialist 3. For example, if hired at the apprentice level (DBA 1), you have the opportunity and path to expand your knowledge and experience and achieve journeyman (DBA 2) and then senior DBA 3; all within the same team and without additional application or hiring processes.
The State of Alaska offers a competitive salary a solid benefit package that includes retirement plans (with employer contributions), health insurance for medical/dental/vision (with employer contributions), and group based insurance benefits such as term life, short/long-term disability, pet insurance, and much more. Click on the Benefits tab of this posting to learn more
The Working Environment You Can Expect:
The Department of Administration, Office of Information Technology (OIT) Database Services Team is primarily working remote, contingent upon telework policy requirements being met. Most duties can be performed remotely, maintain workloads and communications with the team through many technological tools such as O365 and MS Teams, but there may be occasion for in-office team collaboration or physical device contact.
Please note, it is required to be (and remain) a resident of Alaska, even if permitted to telework. Additionally, all telework is limited to be conducted within the State of Alaska (geographically).
The person we are looking for to fill this position will encapsulate the following desired competencies to contribute to the success of Database Services Team:
- Effective and professional communication to expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral and written presentations; listens to others, attends to nonverbal cues, and responds appropriately.
- Experience troubleshooting complex computer systems, in relation to the database services they rely upon.
- Skills in a programming or scripting method in a commonly accepted programming or scripting language (C#, PowerShell, Java etc.) to assist in task automation and database support functions.
- Experience querying database systems in order to retrieve data, including basic knowledge of the principles of indexing and efficient organization of database searches.
Incumbent must be fingerprinted and able to pass an FBI background check. Incumbent will be certified with the business units for the handling of FTI, CJIS and HIPAA data.
Minimum Qualifications
Database Specialist 1 Minimum Qualifications (Range: 20)
Four years of computer programming experience in a recognized computer language. At least one year of the four must have involved programming database applications at the full proficiency programmer level in a wide area networked DBMS environment. This required experience includes, but is not limited to, work such as an Analyst/Programmer 3 with the State of Alaska, or the equivalent elsewhere.
OR
Four years of work experience supporting and maintaining a wide area networked DBMS in a database administration environment that included: 1) leading or serving as shift supervisor for computer operations in a mainframe or database server computer environment or assisting and training on designing and implementing basic computer software; and 2) at least six months actual programming experience in an internal database language. The lead/shift supervisor and design and implementation experience includes, but is not limited to, work such as a Data Processing Technician 3 with the State of Alaska, or equivalent experience elsewhere.
Special Note:
For some positions in these job classes a background investigation including fingerprinting is required.
Database Specialist 2 Minimum Qualifications (Range: 21)
One year of database management systems experience at a level equivalent to a Database Specialist 1 for the State of Alaska.
Special Note:
For some positions in these job classes a background investigation including fingerprinting is required.
Database Specialist 3 Minimum Qualifications (Range: 22)
Two years database management systems experience at a level equivalent to a Database Specialist 2 with the State of Alaska.
Special Note:
For some positions in these job classes a background investigation including fingerprinting is required.
Additional Required Information
At time of application submission, please provide the following:
At time of Interview, please provide the following:
Three (3) professional references and current contact numbers, including two (2) current or former supervisorsCopies of your two (2) most recent employment performance evaluations if available; please substitute with letters of recommendation if evaluations are not available.
A copy of academic transcripts (unofficial are okay, please ensure that the institution name/URL is listed on the transcripts) to verify that you meet the minimum qualifications. if not provided, transcripts will be required prior to appointment.
WRITING SAMPLE
A writing sample is required as part of the application process for this position. Writing samples may include documentation such as user guides, training materials, research papers or blog post you have developed. A cover letter or a resume attachment will not be considered for this writing sample requirement.
APSIN
Employment with the Office of Information Technology is contingent upon successfully completing and maintaining an APSIN background check and security clearance conducted by the Department of Public Safety. Fingerprinting is required.
To verify education is being used to meet and/or support the required minimum qualifications/competencies, 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 used to meet or support the minimum qualifications/competencies for a position and are required with each application. (Unofficial is okay; please ensure the institution/URL name is listed on the transcripts). Transcripts can be attached at the time of application or provided at the time of interview; if not, transcripts will be required before employment.
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.
NOTE: The State of Alaska does not provide VISA Employer sponsorships.
WORK EXPERIENCE:
If using work experience not already documented in your application, also provide the employers 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.
APPLICATION NOTICE:
You can ONLY apply for this position through the Workplace Alaska website or via hardcopy application. If you accessed this recruitment bulletin through a job search portal such as AlaskaJobs or any other database, you MUST use a Workplace Alaska online or hardcopy application to successfully apply. Instructions on how to apply with Workplace Alaska may be found on the Workplace Alaska \\\"How to Apply\\\" webpage, found here: http://doa.alaska.gov/dop/workplace/help/
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 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 (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: https://www.governmentjobs.com/OnlineApplication/User/ResetPassword
Contact Information
Phillip Witt
The following information describes typical benefits available to employees of the State of Alaska. Actual benefits received may differ by bargaining unit or branch of government, position type, or be prorated for other than full time work.
For a quick breakdown of the insurance, health, and retirement benefits available for State Employees you can view an orientation video from Division of Retirement and Benefits. (Please note this video is specifically designed for new State Employees.)
Insurance Benefits
- Health insurance, which includes employer contributions toward medical/vision/dental
- The following employee groups are under AlaskaCare Benefits administered by the State: See https://doa.alaska.gov/drb/programs/index.html for additional information.
- AVTEC
- Confidential
- Correctional Officers
- Marine Engineers
- Mt. Edgecumbe Teachers
- Supervisory
- Unlicensed Vessel Personnel/Inland Boatman's Union
- Exempt employees (not covered by collective bargaining)
- The following employee groups are covered by Union health trusts. Contact the appropriate Union for additional information.
- General Government
- Labor, Trades and Crafts
- Public Safety Employees Association
- Masters, Mates & Pilots
- The following employee groups are under AlaskaCare Benefits administered by the State: See https://doa.alaska.gov/drb/programs/index.html for additional information.
- Employer paid Basic Life insurance with additional coverage available (amount depends on Bargaining Unit)
- Group-based insurance premiums for
- Term life (employee, spouse or qualified same sex partner, and dependents)
- Long-term and short-term disability
- Accidental Death and Dismemberment
- Long-term care (self and eligible family members)
- Supplemental Survivor Benefits
- Employee-funded flexible spending accounts for tax savings on eligible health care or dependent care expenses
Retirement Benefits
- Membership in the Public Employees Retirement System (PERS)/Teachers' Retirement System (TRS)
- Matching employer contribution into a defined contribution program (new employees)
- Employer contribution into a defined benefit or defined contribution program (current employees)
- Contributions to the Alaska Supplemental Annuity Plan in lieu of contributions to Social Security
- Option to enroll in the Alaska Deferred Compensation Program
- Note: The Defined Contribution Plan, Supplemental Annuity Plan and Deferred Compensation Program offer a variety of investment options
- Personal leave with an accrual rate increase based on time served
- Eleven paid holidays a year
Send Us Your Feedback
Sign In
Please check your email. We have sent you a password reset link. This link will expire in one hour.
Please input your account's email
Apply to this Job
Already have account? Login here
Send this job to my email
Please wait..!!