Database Administrator 1

About the Role

Join the Public Safety Delivery Center, Solutions Management team as a Database Administrator 1 and help support critical systems that protect communities across Pennsylvania. This role places you at the center of database design, development, and support for the Pennsylvania State Police and other public safety partners. You will help build reliable data tools that power daily operations and major public safety efforts.

This position supports database development, data analytics, and operational management for systems used by the Pennsylvania State Police and other public safety agencies. The role ensures that critical data tools run smoothly, stay secure, and meet the needs of many teams.

Responsibilities

• Database Design: Create and refine database structures to support application and reporting needs
• Development Support: Partner with development teams to guide data modeling and create dictionaries and documentation
• Data Analysis: Build queries and tools that help teams understand information and support reporting needs
• Operational Monitoring: Track database performance, security, and availability to ensure stable daily operations
• Technical Guidance: Assist staff and project teams with database requirements, feature use, and problem resolution
• System Maintenance: Support upgrades, migrations, and backup processes to protect data and improve reliability

Qualifications

Minimum Experience and Training (one of the following)

• One year as a Database Analyst or Information Technology Generalist 2 (Commonwealth job title or equivalent Federal Government job title, as determined by the Office of Administration)
• Five years of information technology experience that includes two years in the analysis, design, and maintenance of databases in overall support of database administration
• Three years of information technology experience that includes two 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
• One year 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
• An equivalent combination of experience and training

Additional Required Experience

• Five or more years of full-time professional information technology experience in SQL Server Administration supporting business critical systems where reliability, security, and performance are essential
• Five or more years of full-time professional information technology experience in Database Development (building data structures and automated processes supporting complex business operations)
• Two or more years of full-time professional information technology experience in Data Modeling for Analytics (designing data models for business intelligence and analytics solutions)

Other Requirements

• Must meet PA residency requirement (see Residency Guidelines for details)
• Must be able to perform essential job functions
• Must pass a background investigation and meet Criminal Justice Information Services (CJIS) compliance requirements

Work Schedule

• Full-time employment
• Work hours: 8:00 AM to 4:00 PM, Monday–Friday, with a 30-minute lunch
• Telework: Up to 3 days per week (Monday, Thursday, Friday) with a securely configured high-speed internet connection from an approved location inside Pennsylvania. If unable to telework, report to headquarters office in Harrisburg. Telework eligibility subject to change at any time.

Salary

In some cases, the starting salary may be non-negotiable. Further communication regarding this position will be sent via email (check spam/junk folders).

Application Requirements

• Resumes, cover letters, and similar documents will not be reviewed; eligibility must be demonstrated on the application (relevant, detailed experience/education)
• If claiming education in supplemental questions, attach a copy of college transcripts (unofficial acceptable)
• Application must be submitted by the posting closing date; late applications and materials will not be accepted
• All application materials and interview responses must reflect the applicant's own experience, qualifications, and work
• Generative AI tools may be used for preparation only; use of AI to misrepresent or falsify information, or to assist during interviews, is not permitted

Examination Information

• Completing the application, including all supplemental questions, serves as the exam for this position; no additional test center exam is required
• Score is based on detailed information provided on the application and supplemental questions
• Score is valid for this specific posting only
• Must provide complete and accurate information; incomplete or inaccurate information may lower score or cause disqualification
• May only apply/test once for this posting
• Results will be provided via email