Database Administrator 1

About the role

Take your technology career to the next level with the Public Safety IT Delivery Center, Solutions Management team as a Database Administrator 1. This position offers hands-on experience with database design, administration, security, and cloud-based environments that support multiple public safety partners. You will collaborate with talented professionals, improve data systems, and help drive innovation. This is a great opportunity to grow your technical expertise while supporting important public services.

The Database Administrator 1 supports the design, development, maintenance, and reliability of databases used by public safety agencies and partner organizations. This position combines database administration, technical development, data integration, security, and continuous improvement activities. As a Database Administrator 1, you will perform the following duties:

• Database Support: Administer SQL Server databases, monitor system health, and resolve complex database and server issues
• Data Solutions: Design data models, develop database processes, and create scalable solutions that support business and technical requirements
• Security Management: Maintain database security through access controls, auditing practices, encryption methods, and compliance activities
• Integration Services: Develop and troubleshoot ETL workflows, data warehouses, data marts, and analytics platforms
• Platform Reliability: Manage backups, restores, upgrades, migrations, and capacity planning activities to support system stability
• Technical Collaboration: Partner with development, infrastructure, networking, security, and cloud teams to improve database services

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 7:30 AM to 3:30 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. 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.

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

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.

Telecommunications Relay Service (TRS)

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

Additional information

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.

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