Database Administrator 1

Commonwealth of Pennsylvania; Pennsylvania; Hybrid; USD 65,000 - 90,000; Full time

Job summary

The Commonwealth of Pennsylvania is seeking a Database Administrator 1 to support the Public Safety Delivery Center’s Solutions Management team. You will design, develop, and support critical databases used by the Pennsylvania State Police and other public safety partners.

Responsibilities include data modeling, building queries and dictionaries, monitoring performance and security, and guiding development projects. Telework up to 3 days per week may be available; in-office work is in Harrisburg.

Qualifications

• One year as a Database Analyst or IT Generalist 2.
• Five years IT experience with two years in database analysis, design, maintenance.
• Three years IT experience with two years in database analysis, design, and maintenance, and an associate’s degree.
• One year of IT experience with a bachelor's degree in IT.
• An equivalent combination of experience and training.

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

Skills

Database administration

Data analytics

System monitoring

Education

Bachelor's degree in information technology

Associate's degree in information technology

Tools

SQL Server

Data modeling tools

Job description

THE POSITION

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 is a great opportunity to make a positive impact while growing your technical skills.

DESCRIPTION OF WORK

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. As a Database Administrator 1, you will perform the following duties:

• 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

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:00 PM, Monday - Friday, with a 30-minute lunch.
• Telework: You may have the opportunity to work from home (telework) part-time, up to 3 days per week (Monday, Thursday, and Friday). 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.

QUALIFICATIONS

REQUIRED EXPERIENCE, TRAINING & ELIGIBILITY

Minimum Experience and Training Requirements

• 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); or
• Five years of information technology experience that includes two years in the analysis, design, and maintenance of databases in overall support of database administration; or
• 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; or
• 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; or
• An equivalent combination of experience and training.

Other Requirements

• This particular position also requires possession of 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.
• This particular position also requires possession of five of more years of full-time professional information technology experience in Database Development (building data structures and automated processes supporting complex business operations).
• This particular position also requires possession of 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).
• 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.

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

Telecommunications Relay Service (TRS)

• 711 (hearing and speech disabilities or other individuals).

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.