Database Administrator 2

Salary: $89,996.00 - $136,842.00 Annually
Location : Dauphin County, PA
Job Type: Civil Service Permanent Full-Time
Job Number: CSSC-2026-61019-01533
Department: Executive Offices
Division: EX OA PS ITDC Sltns Mgmt Div
Opening Date: 10/27/2026
Closing Date: 11/9/2026 11:59 PM Eastern
Job Code: 01533
Position Number: 00053178
Union: Non-Union
Bargaining Unit: A3
Pay Group: ST10
Bureau / Division Code: 00812730
Bureau / Division: Public Safety Information Technology Delivery Center, Solutions Management Division
Worksite Address: 5 Technology Park Drive
City: Harrisburg, Pennsylvania
Zip Code: 17110
Contact Name: Brittany Bradford
Contact Email:

THE POSITION

The Public Safety Information Technology Delivery Center is looking for a Database Administrator 2 who is ready to make a difference behind the scenes in the Solutions Management Division. In this role, you will help build and support critical databases that serve public safety programs across Pennsylvania. Your technical knowledge will help keep important systems running smoothly, securely, and efficiently. Join a team that values innovation, service, and continuous improvement.
DESCRIPTION OF WORK
As a Database Administrator 2, you will support the design, development, administration, and performance of databases used by JNET and PCCD within the Public Safety Information Technology Delivery Center. You will work with technical teams, business partners, and vendors to deliver reliable database solutions, maintain system performance, and support critical business needs. As a Database Administrator 2, you will perform the following duties:

• Database Design: Design and maintain databases while improving stability, reliability, and overall performance
• Technical Support: Analyze database issues, develop solutions, and provide assistance to developers, users, and project teams
• Performance Monitoring: Track database performance, evaluate space usage, and implement improvements that increase efficiency
• Data Solutions: Develop data models, create complex queries, and support data migration, quality assurance, and cleanup activities
• Project Coordination: Manage assigned work efforts, maintain project plans, review service requests, and report progress to stakeholders
• Vendor Collaboration: Evaluate software tools, coordinate with vendors and contractors, and support implementation of database enhancements

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 4:30 PM, Monday - Friday, with a 60-minute lunch.
• Telework: You may have the opportunity to work from home (telework) part-time, up to 3 days per week. 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 a Database Administrator 1 (Commonwealth job title or equivalent Federal Government job title, as determined by the Office of Administration); or
• Six years of information technology experience that includes three years in the analysis, design, and maintenance of databases in overall support of database administration; or
• Four years of information technology experience that includes three years in the analysis, design, and maintenance of databases in overall support of database administration, and an associate's degree in any information technology field; or
• Two years of information technology experience in the analysis, design, and maintenance of databases in overall support of database administration, and a bachelor's degree in any information technology field; or
• An equivalent combination of experience and training.

Other Requirements:

• This particular position also requires possession of a Microsoft Certified Technology Specialist (MCTS) SQL Server certification and Microsoft Certified IT Professional (MCITP) Database Administrator certification.
• 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 Guidance for Generative AI Tools & Job Seekers 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 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.
The Commonwealth is an equal employment opportunity employer and is committed to a diverse workforce. The Commonwealth values inclusion as we seek to recruit, develop, and retain the most qualified people to serve the citizens of Pennsylvania. The Commonwealth does not discriminate on the basis of race, color, religious creed, ancestry, union membership, age, gender, sexual orientation, gender identity or expression, national origin, AIDS or HIV status, disability, or any other categories protected by applicable federal or state law. All diverse candidates are encouraged to apply.

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 a Microsoft Certified Technology Specialist (MCTS) SQL Server certification?If you are claiming certification, you must attach a copy of your certificate for your claim to be accepted toward meeting the minimum requirements. You must attach your certificate prior to the submission of your application by using the "Attachments" tab on the left. You will not be able to add your certificate to the application after it has been submitted.

• Yes
• No

02

Additional Requirement - Do you possess a Microsoft Certified IT Professional (MCITP) Database Administrator certification?If you are claiming certification, you must attach a copy of your certificate for your claim to be accepted toward meeting the minimum requirements. You must attach your certificate prior to the submission of your application by using the "Attachments" tab on the left. You will not be able to add your certificate to the application after it has been submitted.

• Yes
• No

03

Do you have one or more years of experience as a Database Administrator 1 while employed by the Commonwealth of Pennsylvania?

• Yes
• No

04

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

How many years of information technology experience do you possess in the analysis, design, and maintenance of databases?

• 2 or more years
• 1 but less than 2 years
• None

06

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

How many graduate-level college credits in database technology or database concepts do you possess? If you are claiming credits/degree, you must upload a copy of your college transcript(s) for this education to be considered in the eligibility decision. Unofficial transcripts are acceptable. You must attach your transcript(s) prior to the submission of your application by using the "Attachments" tab on the left. You will not be able to add a transcript(s) to the application after it has been submitted.
If your education was acquired outside of the United States, you must upload a copy of your foreign credential evaluation report. We can only accept foreign credential evaluations from organizations that are members of the National Association of Credential Services (NACES). A list of current NACES members can be found by visiting and clicking the Evaluation Services Link.

You must attach your documentation prior to the submission of your application by using the "Attachments" tab on the left. You will not be able to add a document to the application after it has been submitted.

• 30 credits or more
• Less than 30 credits
• None

08

You must complete the supplemental questions below. These supplemental questions are the exam and will be scored. They are designed to give you the opportunity to relate your experience and training background to the major activities (Work Behaviors) performed in this position. Failure to provide complete and accurate information may delay the processing of your application or result in a lower-than-deserved score or disqualification. You must complete the application and answer the supplemental questions. Resumes, cover letters, and similar documents will not be reviewed for the purposes of determining your eligibility for the position or to determine your score.
All information you provide on your application and supplemental questions is subject to verification. Any misrepresentation, falsification or omission of material facts is subject to penalty. If requested, you must provide documentation, including names, addresses, and telephone numbers of individuals who can verify the validity of the information you provide in the application and supplemental questions.

Read each question carefully. Determine and select which "Level of Performance" most closely represents your highest level of experience/training. List the employer(s)/training source(s) from your Work or Education sections of the application where you gained this experience/training. The "Level of Performance" you choose must be clearly supported within the description of the experience and training information entered in your application or your score may be lowered. In order to receive credit for experience, you must have worked in a job for at least six months in which the experience claimed was a major function.

If you have read and understand these instructions, please click on the "Yes" button and proceed to the exam questions.

If you have general questions regarding the application and hiring process, please refer to our

• Yes

09

WORK BEHAVIOR 1 - DEVELOPING STANDARDS, POLICIES, AND PROCEDURES
Develops database and data administration standards, policies, and procedures. Develops and implements policies, plans, and standards related to database design and use, database structure, database integrity, security, configuration, naming conventions, data elements, data dictionary, data sharing, entity relationship diagrams and methodologies, and quality assurance. Develops and approves standards related to security mechanisms and disaster recovery.

Levels of Performance

Select the Level of Performance that best describes your claim.

• A. I have experience developing database or data administration standards, policies, or procedures. I was also responsible for implementing changes to these standards, policies, or procedures.
• B. I have experience implementing database or data administration standards, policies, or procedures. I provided feedback and recommendations for changes to these standards, policies, or procedures.
• C. I have successfully completed college-level coursework related to policy development or data analysis.
• D. I have NO experience or coursework related to this work behavior.

10

In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N/A in the box below.1. The name(s) of the employer(s) where you gained this experience.2. The actual duties you performed related to developing standards, policies, and procedures.3. Your level of responsibility.
11

If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education/training related to this work behavior, type N/A in the text box below.1. College/University2. Course Title3. Credits/Clock Hours
12

WORK BEHAVIOR 2 - DATABASE PLANNING
Designs and implements large, centralized and distributed database structures or system architecture. Plans and implements database expansions, reorganizations, or conversions. Recommends and justifies hardware and software upgrades and enhancement to ensure optimal database performance.

Levels of Performance

Select the Level of Performance that best describes your claim.

• A.I have experience designing database structures or system architecture. I was also responsible for planning and implementing the database structures or system architecture that I designed.
• B.I have experience planning and implementing database structures or system architecture; however, someone else was responsible for designing the database structures or system architecture.
• C.I have successfully completed college-level coursework related to database planning and design, project planning and implementation, or project management.
• D.I have NO experience or coursework related to this work behavior.

13

In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N/A in the box below.1. The name(s) of the employer(s) where you gained this experience.2. The actual duties you performed related to database planning.3. Your level of responsibility.
14

If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education/training related to this work behavior, type N/A in the text box below.1. College/University2. Course Title3. Credits/Clock Hours
15

WORK BEHAVIOR 3 - DATABASE CREATION AND TESTING
Creates and tests physical databases characterized by complex system architecture including the database storage structures and database objects. Ensures that appropriate data links exist and that keys are established to provide processing efficiency.

Levels of Performance

Select the Level of Performance that best describes your claim.

• A. I have experience creating physical databases and their storage structures and objects. I was responsible for testing the database to ensure appropriate data mapping, validation, integrity, and conformity.
• B. I have experience testing databases to ensure appropriate data mapping, validation, integrity, and conformity. Someone else was responsible for the initial creation of the databases and their storage structures and objects.
• C. I have successfully completed college-level coursework related to database creation, database configuration, database alteration, or database testing.
• D. I have NO experience or coursework related to this work behavior.

16

In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N/A in the box below.1. The name(s) of the employer(s) where you gained this experience.2. The actual duties you performed related to database creation and testing.3. Your level of responsibility.
17

If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education/training related to this work behavior, type N/A in the text box below.1. College/University2. Course Title3. Credits/Clock Hours
18

WORK BEHAVIOR 4 - DATABASE MONITORING AND OPTIMIZATION
Monitors database performance using a system of diagnostic reports. Evaluates and recommends database management technology such as database management systems, database monitoring and tuning tools, and database gateways. Researches the technological advances pertaining to the database environment and proposes or performs installations and upgrades to new versions and products.

Levels of Performance

Select the Level of Performance that best describes your claim.

• A. I have experience monitoring and evaluating database performance. I was responsible for performing root cause analysis and taking corrective action.
• B. I have experience monitoring and evaluating database performance. Someone else was responsible for determining root cause based on the data I collected.
• C. I have successfully completed college-level coursework related to database monitoring, database optimization, or database management.
• D. I have NO experience or coursework related to this work behavior.

19

In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N/A in the box below.1. The name(s) of the employer(s) where you gained this experience.2. The actual duties you performed related to database monitoring and optimization.3. Your level of responsibility.
20

If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education/training related to this work behavior, type N/A in the text box below.1. College/University2. Course Title3. Credits/Clock Hours
21

WORK BEHAVIOR 5 - TECHNICAL ASSISTANCE
Troubleshoots and resolves database issues. Responds to escalated incidents by diagnosing and troubleshooting issues and works with end users and service providers to resolve issues. Provides guidance to users, managers, and other information technology professionals in database planning, design, implementation, operation, security, quality assurance, and data administration.

Levels of Performance

Select the Level of Performance that best describes your claim.

• A. I have experience troubleshooting and resolving database issues. I was responsible for resolving all levels of technical questions and issues. I was the escalation point for complex issues referred by lower-level technicians.
• B. I have experience troubleshooting and resolving database issues. I was responsible for resolving routine questions and issues but referred more complex technical issues to a higher-level technician for resolution.
• C. I have successfully completed college-level coursework related to troubleshooting databases.
• D. I have NO experience or coursework related to this work behavior.

22

In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N/A in the box below.1. The name(s) of the employer(s) where you gained this experience.2. The actual duties you performed related to technical assistance.3. Your level of responsibility.
23

If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education/training related to this work behavior, type N/A in the text box below.1. College/University2. Course Title3. Credits/Clock Hours
24

WORK BEHAVIOR 6 - SECURITY
Establishes standards to ensure adherence with established security policies and recommends changes as needed. Processes all security requests for access to application systems and any other pertinent database schemas. Researches current security solutions and informs management of emerging technologies.

Levels of Performance

Select the Level of Performance that best describes your claim.

• A. I have experience establishing database security standards to ensure adherence to security policies. I was responsible for researching current security solutions and their potential impacts on databases.
• B. I have experience researching security solutions and their potential impacts on databases. I provided recommendations but someone else determined the security standards to ensure adherence to established security policies.
• C. I have successfully completed college-level coursework related to information technology security.
• D. I have NO experience or coursework related to this work behavior.

25

In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N/A in the box below.1. The name(s) of the employer(s) where you gained this experience.2. The actual duties you performed related to security.3. Your level of responsibility.
26

If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education/training related to this work behavior, type N/A in the text box below.1. College/University2. Course Title3. Credits/Clock Hours
27

WORK BEHAVIOR 7 - SUPERVISION
Supervises subordinate staff by assigning work; establishes priorities and timeframes for completion of work; reviews employee performance and prepares evaluation reports; disciplines employees; interviews prospective employees and recommends selection; receives, responds to, and resolves grievances and complaints; provides guidance to staff on complex problems; approves/denies leave requests; and identifies training needs and provides training to staff.

Levels of Performance

Select the Level of Performance that best describes your claim.

• A. I have experience supervising subordinate information technology staff; and as a supervisor, I have interviewed and hired staff, rated work performance, established priorities, disciplined employees, identified training needs, and approved leave.
• B. I have experience as a lead worker or a senior staff member, I have provided on-the-job training to newly hired information technology staff, reviewed their work, or served as a team or group leader, but I was not responsible for employee discipline or resolution of grievances.
• C. I have completed supervisory training.
• D. I have NO experience or coursework related to this work behavior.

28

In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N/A in the box below.1. The name(s) of the employer(s) where you gained this experience.2. The actual duties you performed related to supervision.3. Your level of responsibility.
29

If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education/training related to this work behavior, type N/A in the text box below.1. College/University2. Course Title3. Credits/Clock Hours
Required Question