Database Analyst

State of Pennsylvania

$69K — $104K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • One year experience as Applications Developer 1 or Information Technology Generalist 1 or equivalent.
  • Four years IT experience with one year in database analysis, design, and maintenance.
  • Two years IT experience with one year in database analysis, design and an associate's degree in IT.
  • Bachelor's degree in any IT field is acceptable.
  • Six months experience with Linux, Oracle database administration, and Erwin Data Modeler software required.

Responsibilities

  • Complete assigned database maintenance and troubleshooting tasks.
  • Monitor system performance, space usage, and operational jobs to prevent downtime.
  • Support data integrity through backup, recovery, and disaster recovery processes.
  • Evaluate logical and physical data models and contribute to design practices.
  • Assist with audit requirements and maintain secure access standards.
  • Provide technical guidance and training on database tools and best practices.

Benefits

  • Comprehensive health coverage, including vision and dental options.
  • Flexible work schedules and remote work opportunities.
  • Generous paid vacation and sick leave policies.
  • Eight weeks of paid parental leave and military leave.
  • Opportunities for professional growth and internal mobility.
  • Employee-only discounts on various services and memberships.
Full Job Description
Salary: $69,086.00 - $104,959.00 Annually
Location : Dauphin County, PA
Job Type: Civil Service Permanent Full-Time
Job Number:
Department: Executive Offices
Division: EX OA Entrprs Tchlgy Srvs Off
Opening Date: 07/16/2026
Closing Date: 7/29/2026 11:59 PM Eastern
Job Code: 01531
Position Number: 00093540
Union: AFSCME
Bargaining Unit: A4
Pay Group: ST08
Bureau / Division Code: 00812800
Bureau / Division: Enterprise Technology Services Office
Worksite Address: 2525 N 7th Street
City: Harrisburg, Pennsylvania
Zip Code: 17110
Contact Name: Matthew Zyroll
Contact Phone: 717.836.3503
Contact Email: [email protected]

THE POSITION
Take the next step in your technical career as a Database Analyst with the Enterprise Technology Services Office. This position supports mission critical databases that operate every day to meet statewide needs. You will help maintain secure systems, improve performance, and assist with important database processes. Be part of a team that values teamwork, accuracy, and strong technical leadership. Build a strong foundation for your future with us!
DESCRIPTION OF WORK
This position supports the Database Management Section by helping maintain secure, reliable, and efficient database environments. The role assists with operational tasks, troubleshooting, system monitoring, and updates across multiple platforms. As a Database Analyst, you will perform the following duties:
  • Database Support: Complete assigned database tasks and assist with maintenance and troubleshooting
  • System Monitoring: Review performance, space usage and operational jobs to prevent downtime
  • Data Integrity: Support backup, recovery and disaster recovery processes to protect critical information
  • Model Review: Evaluate logical and physical data models and contribute to solid design practices
  • Security Compliance: Assist with audit requirements and help maintain secure access standards
  • Technical Guidance: Provide direction and training to staff on database tools, processes and best practices

Interested in learning more? Additional details regarding this position can be found in the position description
Work Schedule and Additional Information:
  • Full-time employment
  • Work hours are 8:00 AM to 5:00 PM, Monday - Friday, with 60-minute lunch.
  • Telework: You may have the opportunity to work from home (telework) part-time, two days in office, three days telework. In order to telework, you must have a securely configured high-speed internet connection and work from an approved location inside Pennsylvania. If you are unable to telework, you will have the option to report to the headquarters office in Harrisburg. The ability to telework is subject to change at any time. Additional details may be provided during the interview.
  • Salary: In some cases, the starting salary may be non-negotiable.
  • You will receive further communication regarding this position via email. Check your email, including spam/junk folders, for these notices.

REQUIRED EXPERIENCE, TRAINING & ELIGIBILITY
QUALIFICATIONS

Minimum Experience and Training Requirements:
  • One year as an Applications Developer 1 or Information Technology Generalist 1 (Commonwealth job title or equivalent Federal Government job title, as determined by the Office of Administration); or
  • Four years of information technology experience that includes one year in the analysis, design, and maintenance of databases in overall support of database administration or in the analysis and design in overall support of data administration; or
  • Two years of information technology experience that includes one year in the analysis, design, and maintenance of databases in overall support of database administration or in the analysis and design in overall support of data administration, and an associate's degree in any information technology field; or
  • A bachelor's degree in any information technology field.
  • Applicants will be considered to have met the educational requirements once they are within 3 months of graduating with a qualifying degree.

Other Requirements:
  • This particular position also requires six months or more of full-time professional experience with Linux operating systems.
  • This particular position also requires six months or more of full-time professional experience with Oracle database administration.
  • This particular position also requires six months or more of full-time professional experience with Erwin Data Modeler software.
  • You must meet the PA residency requirement. For more information on ways to meet PA residency requirements, follow the link and click on Residency Guidelines.
  • You must be able to perform essential job functions.

Legal Requirements:
  • You must pass a background investigation and meet Criminal Justice Information Services (CJIS) compliance requirements.


How to Apply:
  • Resumes, cover letters, and similar documents will not be reviewed, and the information contained therein will not be considered for the purposes of determining your eligibility for the position. Information to support your eligibility for the position must be provided on the application (i.e., relevant, detailed experience/education).
  • If you are claiming education in your answers to the supplemental application questions, you must attach a copy of your college transcripts for your claim to be accepted toward meeting the minimum requirements. Unofficial transcripts are acceptable.
  • Your application must be submitted by the posting closing date. Late applications and other required materials will not be accepted.
  • Failure to comply with the above application requirements may eliminate you from consideration for this position.
  • All application materials and interview responses must reflect the applicant's own experience, qualifications, and work. Applicants may use generative AI tools for preparation purposes only. Use of AI to misrepresent or falsify information, or to assist during interviews, is not permitted. Review the for additional information.

Veterans:
  • Pennsylvania law (51 Pa. C.S. §7103) provides employment preference for qualified veterans for appointment to many state and local government jobs. To learn more about employment preferences for veterans, go to www.pa.gov/agencies/employment/how-to-apply.html and click on Veterans.

Telecommunications Relay Service (TRS):
  • 711 (hearing and speech disabilities or other individuals).

If you are contacted for an interview and need accommodations due to a disability, please discuss your request for accommodations with the interviewer in advance of your interview date.
EXAMINATION INFORMATION

  • Completing the application, including all supplemental questions, serves as your exam for this position. No additional exam is required at a test center (also referred to as a written exam).
  • Your score is based on the detailed information you provide on your application and in response to the supplemental questions.
  • Your score is valid for this specific posting only.
  • You must provide complete and accurate information or:
    • your score may be lower than deserved.
    • you may be disqualified.
  • You may only apply/test once for this posting.
  • Your results will be provided via email.

Learn more about our Total Rewards by watching this short !
See the total value of your benefits package by exploring our

Health & Wellness

We offer multiple health plans so our employees can choose what works best for themselves and their families. Our comprehensive benefits package includes health coverage, vision, dental, and wellness programs.*

Compensation & Financial Planning
We invest in our employees by providing competitive wages and encouraging financial wellness by offering multiple ways to save money and ensure peace of mind including multiple retirement and investment plan options.

Work/Life Balance
We know there's more to life than just work! Our generous paid leave benefits include paid vacation, paid sick leave, eight weeks of paid parental leave, military leave, and paid time off for most major U.S. holidays, as well as flexible work schedules and work-from-home opportunities.*

Values and Culture
We believe in the work we do and provide continual opportunities for our employees to grow and contribute to the greater good. As one of the largest employers in the state, we provide opportunities for internal mobility, professional development, and the opportunity to give back by participating in workplace charitable giving.

Employee Perks
Sometimes, it is the little "extras" that make a big difference. Our employees receive special employee-only discounts and rates on a variety of services and memberships.

For more information on all of these Total Rewards benefits, please visit and click on the benefits box.

*Eligibility rules apply.
01

Additional Requirement - Do you possess six months or more of full-time professional experience with Linux operating systems?
  • Yes
  • No

02

If you indicated YES to the question above, please describe the details of the experience you possess. Please be sure to address the items listed below in your response. The claimed experience must also be provided within the experience section of your application. If you indicated NO to the question above, type N/A in the box below.
  1. The name(s) of the employer(s) where you gained this experience
  2. The specific duties you performed related to your experience with Linux operating systems
  3. Your level of responsibility

03

Additional Requirement - Do you possess six months or more of full-time professional experience with Oracle database administration?
  • Yes
  • No

04

If you indicated YES to the question above, please describe the details of the experience you possess. Please be sure to address the items listed below in your response. The claimed experience must also be provided within the experience section of your application. If you indicated NO to the question above, type N/A in the box below.
  1. The name(s) of the employer(s) where you gained this experience
  2. The specific duties you performed related to your experience with Oracle database administration
  3. Your level of responsibility

05

Additional Requirement - Do you possess six months or more of full-time professional experience with Erwin Data Modeler software?
  • Yes
  • No

06

If you indicated YES to the question above, please describe the details of the experience you possess. Please be sure to address the items listed below in your response. The claimed experience must also be provided within the experience section of your application. If you indicated NO to the question above, type N/A in the box below.
  1. The name(s) of the employer(s) where you gained this experience
  2. The specific duties you performed related to your experience with Erwin Data Modeler software
  3. Your level of responsibility

07

Do you have one year or more of experience as an Applications Developer 1 or Information Technology Generalist 1 gained while employed by the Commonwealth of Pennsylvania?
  • Yes
  • No

08

If you are claiming experience in the above question, please list the employer(s) where you gained this experience in the text box below. The employer(s) and a description of the experience must also be included in the appropriate sections of your application if you would like the experience to be considered in the eligibility decision. If you claimed you do not have experience, type N/A in the text box below.
09

How many years of full-time information technology experience do you possess?
  • 4 or more years
  • 3 to less than 4 years
  • 2 to less than 3 years
  • 1 to less than 2 years
  • Less than 1 year
  • No experience

10

If you are claiming experience in the above question, please list the employer(s) where you gained this experience in the text box below. The employer(s) and a description of the experience must also be included in the appropriate sections of your application if you would like the experience to be considered in the eligibility decision. If you claimed you do not have experience, type N/A in the text box below.
11

Do you possess one or more years of full-time experience in the analysis, design, and maintenance of databases in overall support of database administration or in the analysis and design in overall support of data administration?
  • Yes
  • No

12

If you are claiming experience in the above question, please list the employer(s) where you gained this experience in the text box below. The employer(s) and a description of the experience must also be included in the appropriate sections of your

Similar Jobs

More Jobs at State of Pennsylvania

More Information Technology Jobs

Find similar Database Analyst jobs: